- 3059 Views
- 1 replies
- 4 kudos
Resolved! Autoloader clarification
Hi team,Good day! I would like to know how we can perform an incremental load using Autoloader.I am uploading one file to DBFS and writing it into a table. When I upload a similar file to the same directory, it does not perform an incremental load; i...
- 3059 Views
- 1 replies
- 4 kudos
- 4 kudos
Hi @Kanna,Good day! Based on the issue you’re encountering, I believe the problem stems from missing deduplication or upsert logic in your current implementation. Here's an approach that combines the power of Databricks Autoloader and Delta Lake to h...
- 4 kudos
- 6191 Views
- 8 replies
- 1 kudos
Issue with Job Versioning with “Run Job” tasks and Deployments between envinronments
Hello,I am writing to bring to your attention an issue that we have encountered while working with Databricks and seek your assistance in resolving it.When running a Job of Workflow with the task "Run Job" and clicking on "View YAML/JSON," we have ob...
- 6191 Views
- 8 replies
- 1 kudos
- 1 kudos
Hi , Sorry if I don't understand your usecase, are your trying to start/stop databricks job via terraform? for this reason do you want to harcode job-id??
- 1 kudos
- 9297 Views
- 4 replies
- 0 kudos
disable downloading files for specific group of users ?
I see we can disable/enable download button for entire workspace using download button for notebook results.is there a way to disable/enable this just for specific group of users ?
- 9297 Views
- 4 replies
- 0 kudos
- 0 kudos
To future adventurers, the feature described by responder to OP does not exist.
- 0 kudos
- 3289 Views
- 3 replies
- 2 kudos
Delta Live Tables - Dynamic Target Schema
Hi all,I have a requirement where I need to migrate a few jobs from standard databricks notebooks that are orchestrated by Azure Data Factory to DLT Pipelines, pretty straight forward so far. The tricky part is that the data tables in the catalog are...
- 3289 Views
- 3 replies
- 2 kudos
- 2 kudos
@MauricioS Great question!Databricks Delta Live Tables (DLT) pipelines are very flexible, but by default, the target schema specified in the pipeline configuration (such as target or schema) is fixed. That said, you can implement strategies to enable...
- 2 kudos
- 8553 Views
- 6 replies
- 2 kudos
Is there a way to catch the cancel button or the interrupt button in a Databricks notebook?
I'm running oracledb package and it uses sessions. When you cancel a running query it doesn't close the session even if you have a try catch block because a cancel or interrupt issues a kill command on the process. Is there a method to catch the canc...
- 8553 Views
- 6 replies
- 2 kudos
- 2 kudos
I was having the same issue and I think I was finally able to solve it!When you simply except and capture the KeyboardInterrupt signal and do not raise it, the notebook gets into an endless cycle of "interrupting..." and never does anything.However, ...
- 2 kudos
- 1671 Views
- 3 replies
- 0 kudos
instance_id in compute.node_timelines
I am trying to fetch active worker nodes from system tables using the code like below:select count(distinct instance_id)from system.compute.node_timelines where cluster_id = "xx"groupy by instance_id,start_time,end_timesIt gives an output like 20 but...
- 1671 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @Alberto_Umana , Thanks for replying.Even if we add the driver node it should be around 16-17 right, not like 20. I checked for al the clusters, for every cluster there is a difference of 5-7 nodes between max_worker count and count(distinct insta...
- 0 kudos
- 1983 Views
- 3 replies
- 0 kudos
Event based Alert based on certain events from System Audit tables
We need to implement an event-based trigger system that can detect any manual intervention performed by users. Upon detection of such an event, the system should automatically send a warning email. The events can be generated through DLT or other pro...
- 1983 Views
- 3 replies
- 0 kudos
- 0 kudos
Unfortunately the system events are only tracked via the system table, only option to have more recent data will be to re execute the query each time is needed.
- 0 kudos
- 1540 Views
- 3 replies
- 0 kudos
Monitor progress when using databricks-connect
When using databricks-connect how can you monitor the progress? Ideally, we want something similar to what you get in the Databricks notebook, i.e., information about the jobs/stages. We are using Python.
- 1540 Views
- 3 replies
- 0 kudos
- 0 kudos
I would suggest you to submit this as a feature request through https://docs.databricks.com/en/resources/ideas.html#ideas
- 0 kudos
- 4768 Views
- 6 replies
- 0 kudos
Resolved! Use temporary table credentials to access data in Databricks
Hi everybody,I tested the temporary table credentials API. I works great, as long as I use the credentials outside of Databricks (e.g. in a local duckdb instance).But as soon as I try to use the short living credentials (Azure SAS for me) in Databric...
- 4768 Views
- 6 replies
- 0 kudos
- 0 kudos
Hello Matthias, many thanks for sharing this valuable information, it is great to hear your issue got resolved.
- 0 kudos
- 5636 Views
- 2 replies
- 3 kudos
Bridging the SQL-Python Gap
Python often edges out SQL with its metaprogramming capabilities. However, dbt bridges this gap with Jinja templates. Introducing simple "for" loops, especially for parameter iteration, in databricks SQL could significantly enhance the user experienc...
- 5636 Views
- 2 replies
- 3 kudos
- 2364 Views
- 3 replies
- 0 kudos
Data Volume Read/Processed for a Databricks Workflow Job
Hello All, I have a DBx instance hosted on Azure and I am using the Diagnostic Settings to collect Databricks Jobs related logs in log analytics workspace. So far, from the DatabricksJobs table in Azure Loganalytics, I am able to fetch basic job rela...
- 2364 Views
- 3 replies
- 0 kudos
- 0 kudos
Hi @sahasimran98 I think you're right this is more valid for synapse where such configuration exist but you can still give a try for databricks and let us know here the results. otherwise try to find some spark-monitoring package in github for databr...
- 0 kudos
- 5268 Views
- 4 replies
- 1 kudos
Skewness / Salting with countDistinct
Hey Everyone,I experience data skewness for: df = (source_df .unionByName(source_df.withColumn("region", lit("Country"))) .groupBy("zip_code", "region", "device_type") .agg(countDistinct("device_id").alias("total_active_unique"), count("device_id").a...
- 5268 Views
- 4 replies
- 1 kudos
- 1 kudos
you can make use of databricks native feature "Liquid Clustering", cluster by the columns which you want to use in grouping statements, it will handle the performance issue due to data skewness .For more information, please do visit :https://docs.dat...
- 1 kudos
- 2508 Views
- 2 replies
- 2 kudos
Resolved! Incremental load from two tables
Hi, I am looking to build a ETL process for a incremental load silver table.This silver table, lets say "contracts_silver", is built by joining two bronze tables, "contracts_raw" and "customer".contracts_silverCONTRACT_IDSTATUSCUSTOMER_NAME1SIGNEDPet...
- 2508 Views
- 2 replies
- 2 kudos
- 1317 Views
- 1 replies
- 1 kudos
Solution Design for an ingestion workflow with 1000s of tables for each source
Working on an ingestion workflow in databricks which extracts data from on-prem sources in databricks following all standard practices of incremental load, indempotency, upsert, schema evolution etc and storing data properly.Now we want to optimize t...
- 1317 Views
- 1 replies
- 1 kudos
- 1 kudos
I do did the similar kind of work in my recent project, where I need to run many SQL DDL's , so I automated the process using databricks jobs, capturing the dependency using a metadata table and creating tasks likewise in job through job api's, doing...
- 1 kudos
- 3921 Views
- 6 replies
- 2 kudos
Mount point in unity catalog
Hi Everyone,In my existing notebooks we have used mount points url as /mnt/ and we have more than 200 notebooks where we have used the above url to fetch the data/file from the container. Now as we are upgrading to unity catalog these url will no lon...
- 3921 Views
- 6 replies
- 2 kudos
- 2 kudos
@adityarai316 did u get the solution because I am facing the same issue?
- 2 kudos
| User | Count |
|---|---|
| 1645 | |
| 793 | |
| 582 | |
| 349 | |
| 287 |
