cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

dbernstein_tp
by • Contributor II
  • 600 Views
  • 2 replies
  • 1 kudos

Power BI dashboards using Direct Lake

Hi Everyone, We are experimenting with using Direct Lake for our Power BI dashboards and I wanted to check in with this group to see if people have tried or are currently using this to connect PBI to Databricks tables. If so what is your experience w...

  • 600 Views
  • 2 replies
  • 1 kudos
Latest Reply
NandanHegde15
New Contributor III
  • 1 kudos

Your Power Bi report needs to be in Fabric capacity workspace in order for you leverage Direct Lake mode functionality.So you can try the path of Databricks mirroring :Fabric mirrors Unity catalog metadata and creates OneLake shortcuts to the Delta f...

  • 1 kudos
1 More Replies
bricks_2026
by • New Contributor III
  • 883 Views
  • 3 replies
  • 0 kudos

Resolved! Unexpected behavior of Delta VACUUM – need explanation

HelloI have a question about how VACUUM works.We executed the following VACUUM command from a PySpark job:spark.sql("""VACUUM catalog_name.schema_name.table_name RETAIN 168 HOURS""")The Delta table has a table property retention period of 365 days, b...

  • 883 Views
  • 3 replies
  • 0 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 0 kudos

Greetings @bricks_2026 , glad the first answer helped. Your sliding window observation is sharp, but one correction to the mental model: delta.deletedFileRetentionDuration only drives physical deletion at the moment a VACUUM executes. Between your w...

  • 0 kudos
2 More Replies
Sam500
by • New Contributor III
  • 1100 Views
  • 1 replies
  • 0 kudos

Resolved! Databricks delta tables and Iceberg

Hi experts ,now databricks for support for Iceberg open table format conversion yet not fully though.Databricks calls this Delta Lake UniForm (Universal Format). When tentatively Databricks can support fully open table format Iceberg, Hudi etc.Is the...

  • 1100 Views
  • 1 replies
  • 0 kudos
Latest Reply
DoTA
Valued Contributor III
  • 0 kudos

Worth separating "reading Iceberg from Delta" from "Databricks fully adopting Iceberg as a first-class table format" - those are two different things and Databricks has been moving on both fronts. Today: UniForm (Universal Format) makes a Delta table...

  • 0 kudos
AndriusVitkausk
by • New Contributor III
  • 402 Views
  • 1 replies
  • 0 kudos

transformWithState might be causing 'Module not found'

Hi,So i've been playing around with transformWithState over the last few weeks and have got the code to work exactly as desired.Wrote some integration tests that execute fine within the workspace in serverless and everything, the issue is however is ...

  • 402 Views
  • 1 replies
  • 0 kudos
Latest Reply
DoTA
Valued Contributor III
  • 0 kudos

This smells like a client/server module-resolution mismatch that's specific to Databricks Connect + serverless, rather than a wheel packaging problem per se. A few things worth checking: 1. Where the StatefulProcessor class lives. Since it's defined ...

  • 0 kudos
nareshkumar
by • New Contributor II
  • 280 Views
  • 0 replies
  • 1 kudos

Databricks Certification Exam Suspended - Databricks Certified Data Engineer Associate

Dear Databricks Certification Support Team,My Databricks Certified Data Engineer Associate exam was suspended during the exam session.After the exam was suspended, I verified my system and found that my webcam was not working properly. I believe the ...

  • 280 Views
  • 0 replies
  • 1 kudos
darek554
by • New Contributor II
  • 1602 Views
  • 6 replies
  • 2 kudos

Code on cluster runs idefinitely

Hello.Ive created a custom cluster - m4.large. When i try to execute some code in this cluster the behaviour is as follows:- Cluster starts, have running status- I run code, for example print("Hello")- Code runs indefinitely- I click interrupt, it st...

  • 1602 Views
  • 6 replies
  • 2 kudos
Latest Reply
arhamblake38
New Contributor II
  • 2 kudos

It sounds more like a cluster/driver initialization or resource issue than a Python problem, especially because even SELECT 1 hangs.I’d check these first:Look at the Driver logs and Event log for errors around the first notebook execution. Databricks...

  • 2 kudos
5 More Replies
DineshOjha
by • New Contributor III
  • 648 Views
  • 4 replies
  • 0 kudos

Creating Databricks agent

Hi All,We are trying to create a Databricks agent and were looking for a step by step approach if there is any. We did go through the Author an agent and deploy it on Databricks Apps | Databricks on AWS but weren't very clear on creation of a new age...

  • 648 Views
  • 4 replies
  • 0 kudos
Latest Reply
kartikchoudhary
Contributor
  • 0 kudos

If you're approaching this specifically as a migration validation use case, I'd separate the agent into two layers: the validation tools and the agent reasoning layer.For example, expose controlled tools for querying Hive and Databricks, then have th...

  • 0 kudos
3 More Replies
Vladif1
by • New Contributor II
  • 13020 Views
  • 10 replies
  • 1 kudos

Error when reading delta lake files with Auto Loader

Hi,When reading Delta Lake file (created by Auto Loader) with this code: df = (    spark.readStream    .format('cloudFiles')    .option("cloudFiles.format", "delta")    .option("cloudFiles.schemaLocation", f"{silver_path}/_checkpoint")    .load(bronz...

  • 13020 Views
  • 10 replies
  • 1 kudos
Latest Reply
stephen4
Contributor
  • 1 kudos

The key point is using the correct format for Delta tables rather than treating them like raw files. The same idea of using the right tool for the job applies in other technical workflows too, such as a delta executor apk when handling Android relate...

  • 1 kudos
9 More Replies
prathamesh1982
by • New Contributor
  • 691 Views
  • 2 replies
  • 0 kudos

how to enable column level lineage in databricks

I have bronze layer data which is directly referred in silver. there are one or two columns from bronze layer which are used to build silver column.is there any way I can have column-level lineage shown in databricks like table lineage@DATA @lineage

  • 691 Views
  • 2 replies
  • 0 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 0 kudos

Hi @prathamesh1982 , Good news: there's nothing to enable. @balajij8  has it right, Unity Catalog captures column-level lineage automatically. I'll add some prerequisites and gotchas to check if the lineage doesn't appear. If your bronze and silver t...

  • 0 kudos
1 More Replies
binlogreader
by • Contributor III
  • 569 Views
  • 2 replies
  • 1 kudos

S3 LIST costs on high commit rate Delta tables: is there a start-after option on Databricks runtime?

Hi All,If you run streaming or continuous pipelines that commit to Delta tables on S3 every few minutes, your _delta_log folders are probably much bigger than your tables. A CDC or MERGE flow commits every cycle whether or not data arrived, and with ...

  • 569 Views
  • 2 replies
  • 1 kudos
Latest Reply
binlogreader
Contributor III
  • 1 kudos

@brianjorge178 @cartergray70543 Thanks for your thoughts. I had a long chat with Databricks support team, and here is where have landed so far if it interests you:What we believed. The pipelines committed every few minutes, so each table's transactio...

  • 1 kudos
1 More Replies
Brahmareddy
by • Esteemed Contributor II
  • 1739 Views
  • 6 replies
  • 1 kudos

Are We Entering the Context Engineering Era?

I’ve been thinking about how enterprise AI is changing, especially after attending the Data + AI Summit 2026 and hearing Ali Ghodsi emphasize the importance of enterprise context. It made the direction much clearer to me. We already have very capable...

  • 1739 Views
  • 6 replies
  • 1 kudos
Latest Reply
nick_martinek
New Contributor III
  • 1 kudos

There is one thing I'd add which is that many large enterprises still struggle with governance, ownership and sometimes even with common definitions of what their data means. The interesting question is not only how much context we can give to tools ...

  • 1 kudos
5 More Replies
QuanDo1
by • New Contributor II
  • 1119 Views
  • 7 replies
  • 1 kudos

If statement in DAB YAML file support

Hi,Is there a plan to have if statement support in DAB YAML file?For example, I would like to have different schedule for jobs based on the environment (higher frequency in PROD, lower frequency in DEV, QA). How can I do it in Databricks via workflow...

  • 1119 Views
  • 7 replies
  • 1 kudos
Latest Reply
Niyojit
Databricks Partner
  • 1 kudos

Hi @QuanDo1 You don't need to use if/else for this use case. Databricks Asset Bundles (DAB) already supports variables that can be overridden per target environment.You can define your variables once and then assign different values for each target (...

  • 1 kudos
6 More Replies
bts136
by • Databricks Partner
  • 6272 Views
  • 4 replies
  • 1 kudos

Reading Excel files with Spark returns formula values instead of computed values

Hi,I'm seeing inconsistent behavior when reading Excel files using the built-in connector Lakeflow Connector with spark.read.format("excel") (doc: https://docs.databricks.com/aws/en/query/formats/excel). I read an .xlsx file from S3 using this functi...

  • 6272 Views
  • 4 replies
  • 1 kudos
Latest Reply
honey_sharma
New Contributor III
  • 1 kudos

Yes, this can happen with Excel readers when formula evaluation/cached values are handled differently. In an .xlsx file, the formula itself and its last calculated value are stored separately, so the reader may return the formula string if it doesn't...

  • 1 kudos
3 More Replies
rodrigocms
by • New Contributor
  • 4269 Views
  • 3 replies
  • 0 kudos

Get information from Power BI via XMLA

Hello everyone I am trying to get information from Power BI semantic models via XMLA endpoint using PySpark in Databricks.Can someone help me with that?tks

  • 4269 Views
  • 3 replies
  • 0 kudos
Latest Reply
NandanHegde15
New Contributor III
  • 0 kudos

You would need the power bi report to be in a Fabric/premium capacity workspace and Capacity setting XMLA Endpoint = Read (or Read/Write) Any specific reason why via XMLA endpoint?Via the REST API : Datasets - Execute Queries - REST API (Power BI Pow...

  • 0 kudos
2 More Replies
xwu
by • Databricks Partner
  • 878 Views
  • 2 replies
  • 0 kudos

Resolved! Error DELTA_CATALOG_MANAGED_TABLE_UPGRADE_WITH_OTHER_PROPERTIES during catalog commit upgrade

Hi everyone,I'm encountering an issue with the Catalog Commit functionality while attempting to upgrade a table, following the official Databricks documentationCatalog commits | Databricks on AWSWhen running the following command on a Managed Iceberg...

Data Engineering
Catalog Commit
Iceberg
Unity Catalog
  • 878 Views
  • 2 replies
  • 0 kudos
Latest Reply
amitsharma1707
Databricks Partner
  • 0 kudos

This looks like an interaction between the catalog-managed protocol upgrade and VARIANT shredding, rather than an issue with the SQL syntax itself.delta.feature.catalogManaged needs to be enabled as a standalone table/protocol upgrade. In this case, ...

  • 0 kudos
1 More Replies
Labels