- 59 Views
- 2 replies
- 0 kudos
DLT Pipeline with unknown deleted source data
Hello.. I need help. So the context is : - ERP data for company in my group is stored in sql tables - Currently, once per day we copy the last 2 months of data (creation date) from each table into our datalake landing zone (we can however do full cop...
- 59 Views
- 2 replies
- 0 kudos
- 0 kudos
Your solution #1 is very frustrating to me as well, for a number of reasons. Simply put, we have to be able to compare incoming data to target data for normal ETL operations. One way around this is to create a view of your target silver table, outsi...
- 0 kudos
- 38 Views
- 1 replies
- 0 kudos
DLT pipeline failed: streaming table query reading from an unexpected Delta table ID
Hi everyone,I'm running a DLT pipeline that loads data from Bronze to Silver using dlt.apply_changes(SCD type 2)The first run of the pipeline worked fine -- data was written successfully into the target Silver tables.However, when I ingested new data...
- 38 Views
- 1 replies
- 0 kudos
- 0 kudos
This “unexpected Delta table ID” error typically means your Delta Live Tables (DLT) pipeline detected that the underlying Delta table it was reading from has changed since the last checkpoint. When you use dlt.apply_changes() (for SCD Type 2), this i...
- 0 kudos
- 64 Views
- 2 replies
- 1 kudos
Community edition cluster - UI shows incorrect cores
Hi,I am a community edition user which gives me cluster ( as per below image)15GB of memory and 2 cores with one driver node ONLY.However,when I read a csv file of 181MB size,1) it generates 8 partitiones.As per default maxPartitionBytes is set to 12...
- 64 Views
- 2 replies
- 1 kudos
- 1 kudos
Thank you Louis for detailed explaination.Including notifying me about CE updates.However, I have noticed this ( below is the screenshot)spark.sql.files.minPartitionNum does not restun any result.Its wierd.Am I missing anything?Thanks
- 1 kudos
- 47 Views
- 1 replies
- 0 kudos
Unable to Add Multiple Columns in Single ALTER TABLE Statement on Iceberg Table via Unity REST Catal
Hello Databricks Team,I have implemented code to integrate the Iceberg Unity REST Catalog with the Teradata OTF engine and successfully performed read and write operations, following the documentation at https://docs.databricks.com/aws/en/external-ac...
- 47 Views
- 1 replies
- 0 kudos
- 0 kudos
This error stems from the Iceberg table metadata update constraints enforced by the Unity Catalog's REST API. Specifically, the Iceberg REST Catalog currently does not support multiple schema changes in a single commit. Each ALTER TABLE operation tha...
- 0 kudos
- 3159 Views
- 3 replies
- 1 kudos
How to identify which columns we need to consider for liquid clustering from a table of 200+ columns
In Databricks, when working with a table that has a large number of columns (e.g., 200), it can be challenging to determine which columns are most important for liquid clustering.Objective: The goal is to determine which columns to select based on th...
- 3159 Views
- 3 replies
- 1 kudos
- 1 kudos
@Alberto_Umana is it possible to get from system table the columns used in joins & filters of a table being queried?
- 1 kudos
- 1285 Views
- 2 replies
- 0 kudos
Multiple schedules in workflow with different parameters
I have a notebook that takes a file from the landing, processes it and saves a delta table.This notebook contains a parameter (time_prm) that allows you to do this option for the different versions of files that arrive every day.Specifically, for eac...
- 1285 Views
- 2 replies
- 0 kudos
- 0 kudos
You can do multiple schedules with Cron expression. If you are using a Cron expression in Databricks asset bundle YAML, but the limitation is you can't have one running at 0 past the hour and another at 25 past.i.e: quartz_cron_expression: 0 45 9,23 ...
- 0 kudos
- 1612 Views
- 1 replies
- 1 kudos
Delta table size not shrinking after Vacuum
Hi team.Everyday once we overwrite the last X month data in tables. So it generate a every day a larger amount of history. We don't use time travel so we don't need it.What we done:SET spark.databricks.delta.retentionDurationCheck.enabled = false ALT...
- 1612 Views
- 1 replies
- 1 kudos
- 1 kudos
Hi, any update on this? Thanks
- 1 kudos
- 127 Views
- 2 replies
- 1 kudos
Migrating Talend ETL Jobs to Databricks – Best Practices & Challenges
Hi All,I’m currently working on a Proof of Concept (POC) to migrate existing Talend ETL jobs to Databricks. The goal is to leverage Databricks for data processing and orchestration while moving away from Talend.I’d appreciate insights on the followin...
- 127 Views
- 2 replies
- 1 kudos
- 382 Views
- 2 replies
- 1 kudos
Resolved! Ingestion Framework
I would to like to update my ingestion framework that is orchestrated by ADF, running couples Databricks notebook and copying the data to DB afterwards. I want to rely everything on Databricks i though this could be the design:Step 1. Expose target t...
- 382 Views
- 2 replies
- 1 kudos
- 1 kudos
Hey @saurabh18cs , It is taking longer than expected to expose Azure SQL tables in UC. I can do that through Foreign Catalog but this is not what i want due to is read-only. As far i can see external connection is for cloud object storage paths (ADLS...
- 1 kudos
- 114 Views
- 4 replies
- 1 kudos
How to Retrieve DBU Count per Compute Type for Accurate Cost Calculation?
Hello Everyone,We are currently working on a cost analysis initiative to gain deeper insights into our Databricks usage. As part of this effort, we are trying to calculate the hourly cost of each Databricks compute instance by utilizing the Azure Ret...
- 114 Views
- 4 replies
- 1 kudos
- 1 kudos
Hi everyone, just to clarify my question — I’m looking for the DBU count per compute type (per instance type), not the total DBU consumption per workload.In other words, I want to know the fixed DBU rate assigned to each compute SKU (for example, DS3...
- 1 kudos
- 5590 Views
- 8 replies
- 4 kudos
Databricks SQL Warehouse, Tableau and spark.driver.maxResultSize error
I'm attempting to create a tableau extract on tableau server with a connection to databricks large sql warehouse. The extract process fails due to spark.driver.maxResultSize error.Using a databricks interactive cluster in the data science & engineer...
- 5590 Views
- 8 replies
- 4 kudos
- 4 kudos
It sounds like you're running into quite a frustrating issue with Databricks and Tableau! Adjusting the spark.driver.maxResultSize is a good idea, but if you're still facing challenges, consider streamlining your data selections or aggregating your r...
- 4 kudos
- 298 Views
- 3 replies
- 0 kudos
Resolved! AUTO CDC API and sequence column
The docs for AUTO CDC API stateYou must specify a column in the source data on which to sequence records, which Lakeflow Declarative Pipelines interprets as a monotonically increasing representation of the proper ordering of the source data.Can this ...
- 298 Views
- 3 replies
- 0 kudos
- 0 kudos
Thanks Szymon, I'm familiar with the Postgre SQL implementation and was hoping Databricks would behave the same.
- 0 kudos
- 1871 Views
- 1 replies
- 2 kudos
DLT schema evolution/changes in the logs
Hi all,I want to figure out how to find when the schema evolution/changes are happening in the objects in DLT pipelines through the DLT logs.Could you please share some sample DLT logs which explains about the schema changes?Thank you for your help.
- 1871 Views
- 1 replies
- 2 kudos
- 2 kudos
To find when schema evolution or changes are happening in objects within DLT (Delta Live Table) pipelines, you need to monitor certain entries within the DLT logs or Delta transaction logs that signal modifications to the underlying schema of a table...
- 2 kudos
- 2527 Views
- 3 replies
- 0 kudos
DLT Flow Failed Due to Missing Flow Checkpoints Directory When Using Unity Catalog
I’m encountering an issue while running a Delta Live Tables (DLT) pipeline that is managed using Unity Catalog on Databricks. The pipeline has failed and is not restarting, showing the following error:java.lang.IllegalArgumentException: flow checkpoi...
- 2527 Views
- 3 replies
- 0 kudos
- 0 kudos
The best practices for setting up checkpointing in Delta Live Tables (DLT) pipelines when using Unity Catalog are largely centered on leveraging Databricks' managed services, adhering to Unity Catalog's table management conventions, and minimizing th...
- 0 kudos
- 332 Views
- 4 replies
- 1 kudos
Not able to refresh powerbi dashboar form databricks jobs
I am trying to refresh Power BI Dashboard using Databricks jobs and constantly getting this error, but I am providing optional parameters which includes catalog and database. Also, things to note that I am able to do refresh on Power BI UI using both...
- 332 Views
- 4 replies
- 1 kudos
- 1 kudos
Hi @sumitkumar_284 ,Can you provide us more details? Are you using Unity Catalog? Which authentication mechanism you have? In which version of Power BI Desktop you've developed your semantic model/dashboard? Do you meet all below requirements?Publish...
- 1 kudos
| User | Count |
|---|---|
| 1616 | |
| 790 | |
| 469 | |
| 349 | |
| 287 |
