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

Shubh5073
by New Contributor II
  • 791 Views
  • 9 replies
  • 2 kudos

Unable to Enable Unity Catalog – Azure Managed Identity Credential Not Found

Hi Databricks Community,I am trying to enable Unity Catalog in my Azure Databricks account. As part of the setup, I created an Azure Databricks Access Connector and assigned its managed identity the required permissions on my ADLS Gen2 storage accoun...

  • 791 Views
  • 9 replies
  • 2 kudos
Latest Reply
jsaldivarp
Visitor
  • 2 kudos

I hit the same error.When creating a Unity Catalog metastore from the web UI of the Azure Databricks Account Console, the following error appeared during Access Connector validation, despite having all the Azure configuration correctly set up (manage...

  • 2 kudos
8 More Replies
Ashoka
by New Contributor
  • 214 Views
  • 2 replies
  • 1 kudos

Resolved! Title: Oracle CDC pipeline (Lakeflow Connect) never terminates

Setup: Oracle 21c XE (CDB/PDB), Direct CDC Extraction, no gateway, triggered pipeline on hourly schedule, single table.Problem: A triggered run has been active 95+ minutes with no work left. All flows report IDLE, waiting for new data, the source is ...

  • 214 Views
  • 2 replies
  • 1 kudos
Latest Reply
Ashoka
New Contributor
  • 1 kudos

I am using databrick-oracle CDC connector( beta version)

  • 1 kudos
1 More Replies
margarita_shir
by New Contributor III
  • 151 Views
  • 2 replies
  • 0 kudos

Lakehouse Federation (Snowflake) — large query results fail to download from internal stage

We're hitting a consistent failure with Lakehouse Federation to Snowflake where large result sets fail during the result-chunk download, while small results work. Looking for help isolating whether this is the Databricks Snowflake connector or a conf...

  • 151 Views
  • 2 replies
  • 0 kudos
Latest Reply
arhamblake38
New Contributor II
  • 0 kudos

This sounds like it could be related to the size of the result set or the way the internal stage handles large downloads, rather than the federation itself. If smaller query results download successfully while larger ones fail, I’d compare the file s...

  • 0 kudos
1 More Replies
treesloth
by New Contributor
  • 141 Views
  • 2 replies
  • 1 kudos

Making transform dynamic and user-selectable

Hello.  I have a straightforward bar graph visual.  I generally want to display one year's data, displayed monthly.  However, when certain filters are applied, the data becomes limited to 1 month, which just produced one very wide bar.  Not very usef...

  • 141 Views
  • 2 replies
  • 1 kudos
Latest Reply
hayoni
New Contributor
  • 1 kudos

Hi @treesloth You can easily do this by using a dashboard parameter to handle the date grouping directly in your SQL query, while keeping the chart's Transform setting as None. Here is the step-by-step setup:Step 1: Create a dataset for the dropdown ...

  • 1 kudos
1 More Replies
Deny1
by New Contributor
  • 138 Views
  • 1 replies
  • 1 kudos

cross-region DR in Azure Databricks (24h RPO/RTO)

Hi,We're designing a DR strategy for an Azure Databricks platform and would appreciate guidance on current best practices for achieving approximately 24-hour RPO and RTO across Azure regions.Our platform includes Unity Catalog, DAB, Jobs, Notebooks, ...

  • 138 Views
  • 1 replies
  • 1 kudos
Latest Reply
pradeep_singh
Honored Contributor III
  • 1 kudos

Your overall design is sensible, but Databricks’ current recommendation is to use Managed Disaster Recovery when your account is eligible. If Managed DR is unavailable, use an active-passive warm standby with Terraform/DABs, cross-region data replica...

  • 1 kudos
ThiamLee
by New Contributor II
  • 120 Views
  • 2 replies
  • 1 kudos

Suggestions for recommendation

Hey everyone! I’m currently looking for some good tools for data analysis. If you have any recommendations, please share them with me. Would really appreciate it!

  • 120 Views
  • 2 replies
  • 1 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 1 kudos

@ThiamLee You can use Notebooks that let you write Python and SQL code interactively. You use libraries like pandas, matplotlib, ydata profiling and Py Spark for both small and large-scale analysis in it. Databricks SQL provides a dedicated SQL edito...

  • 1 kudos
1 More Replies
karuppusamy
by Databricks Partner
  • 279 Views
  • 4 replies
  • 2 kudos

Oracle CDC Ingestion Pipeline - Schema Exploration finds 0 tables when DB_DOMAIN

Hi,I'm setting up an Oracle Integrated CDC Managed Ingestion Pipeline (LakeFlow Connect) on Azure Databricks. The pipeline connects to Oracle 19c successfully but Schema Exploration always returns 0 tables.Error:Schema Exploration has COMPLETED in 5 ...

  • 279 Views
  • 4 replies
  • 2 kudos
Latest Reply
VTiw25
New Contributor II
  • 2 kudos

@karuppusamy Try using ORCL as the service name.

  • 2 kudos
3 More Replies
FranPérez
by New Contributor III
  • 20221 Views
  • 10 replies
  • 7 kudos

set PYTHONPATH when executing workflows

I set up a workflow using 2 tasks. Just for demo purposes, I'm using an interactive cluster for running the workflow. { "task_key": "prepare", "spark_python_task": { "python_file": "file...

  • 20221 Views
  • 10 replies
  • 7 kudos
Latest Reply
Kamil128
New Contributor
  • 7 kudos

We’re facing the same issue while trying to implement Databricks Asset Bundles (DAB).We’ve checked multiple possibilities, and it looks like packaging the code as a wheel or using `sys.path.append` are the only viable options.It looks like Databricks...

  • 7 kudos
9 More Replies
shubham_007
by Contributor III
  • 13349 Views
  • 12 replies
  • 10 kudos

Resolved! What are powerfull data quality tools/libraries to build data quality framework in Databricks ?

Dear Community Experts,I need your expert advice and suggestions on development of data quality framework. What are powerfull data quality tools or libraries are good to go for development of data quality framework in Databricks ? Please guide team.R...

  • 13349 Views
  • 12 replies
  • 10 kudos
Latest Reply
gbhoglexeliq
Databricks Partner
  • 10 kudos

I have used Databricks labs - DQX for a failrly complex data quality implementation and it handlled the mix of built in validations and custom business rules well. One thing we learned is that performance depended much more on the underlying data lay...

  • 10 kudos
11 More Replies
de01
by Databricks Partner
  • 318 Views
  • 3 replies
  • 5 kudos

Resolved! Auto SCD API Tombstone Garbage Collection

Are there any settings that can be used to influence the frequency at which the auto SCD API runs the tombstone garbage collection process in Spark Declarative Pipelines?  I've seen a couple community posts that referenced the following:  pipelines.a...

  • 318 Views
  • 3 replies
  • 5 kudos
Latest Reply
de01
Databricks Partner
  • 5 kudos

I was able to get this figured out.  The setting that works is pipelines.applyChanges.tombstoneGCFrequencyInSeconds, and it seems like it can be set as either a pipeline configuration or in the spark conf of the individual streaming table(either in c...

  • 5 kudos
2 More Replies
analyticsnerd
by New Contributor III
  • 411 Views
  • 2 replies
  • 2 kudos

Resolved! Transaction log integrity issue

Delta transaction log for one of our tables which is being written to by a Kafka Connect IcebergSinkConnector via the Unity Catalog Iceberg REST endpoint, is currently corrupted and is failing when trying to read with the below exceptionERROR:com.dat...

  • 411 Views
  • 2 replies
  • 2 kudos
Latest Reply
K_Anudeep
Databricks Employee
  • 2 kudos

Hello @analyticsnerd , Delta maintains a checksum file (.crc) for each committed version, along with the commit log (.json), recording the table’s file count, total size, and a distribution of file sizes (a histogram that buckets files by size). For ...

  • 2 kudos
1 More Replies
ChristianRRL
by Honored Contributor II
  • 207 Views
  • 4 replies
  • 5 kudos

Declarative Automation Bundle - How to handle Managed resources?

Hi there,I'm making a new repo from scratch to make it as DAB-compatible as possible. I was considering using DAB for the creation/management of resources such as schemas and volumes.. however, a concern crossed my mind. If these resources are MANAGE...

ChristianRRL_0-1787603890125.png
  • 207 Views
  • 4 replies
  • 5 kudos
Latest Reply
mancy34
New Contributor II
  • 5 kudos

Good point managed schemas/volumes need extra caution with bundle destroy. I’d avoid managing production data resources directly through DABs, or use safeguards to prevent accidental deletion.

  • 5 kudos
3 More Replies
DB1To3
by New Contributor III
  • 222 Views
  • 7 replies
  • 3 kudos

Distinguishing Runs Related to an All-Purpose Cluster

Sorry for the basic question.  If I am using an all-purpose clusters in Databricks, it seems to combine all my runs together and execute them within the same Apache Spark application.  There is only one application shown in the Spark UI.   Unrelated ...

  • 222 Views
  • 7 replies
  • 3 kudos
Latest Reply
Khasim_1
New Contributor
  • 3 kudos

If you must use an All-Purpose cluster (e.g., for cost savings or fast start times), here is how you manage the chaos:The "Job Name" filter in the Jobs UI: Don't look at the Spark UI first. Go to the Workflows > Jobs tab. You can filter the "Runs" li...

  • 3 kudos
6 More Replies
pepco
by New Contributor III
  • 221 Views
  • 2 replies
  • 2 kudos

Resolved! databricks SQL UDF in select statement

In the Unity Catalog we can now create/register SQL UDFs. There are two types - one that returns table and other that returns just a value. If the function that returns value is based on the SQL query and joins it would in standard relational databas...

  • 221 Views
  • 2 replies
  • 2 kudos
Latest Reply
AbhilashNagilla
Databricks Employee
  • 2 kudos

The earlier reply has the mechanism broadly right, and your two questions have clean answers: yes to the first, no to the second. A SQL scalar function whose body is a query is planned as a scalar subquery inside the calling statement. Databricks lab...

  • 2 kudos
1 More Replies
Labels