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

bbastian
by New Contributor
  • 208 Views
  • 1 replies
  • 1 kudos

Resolved! [VARIANT_SIZE_LIMIT] Cannot build variant bigger than 16.0 MiB in parse_json

I have a table coming from postgreSql, with one column containing json data in string format. We have been using parse_json to convert that to a vraiant column. But lately it is failing with the SIZE_LIMIT error. When I isolated the row which gave er...

  • 208 Views
  • 1 replies
  • 1 kudos
Latest Reply
szymon_dybczak
Esteemed Contributor III
  • 1 kudos

Hi @bbastian ,Unfortunately, as of now there is strict limitation regarding size - a variant column cannot contain a value larger than 16 MiB.Variant support in Delta Lake | Databricks on AWSAnd tbh you cannot compare the size of this json string to ...

  • 1 kudos
sslyle
by New Contributor III
  • 7687 Views
  • 9 replies
  • 5 kudos

Resolved! Combining multiple Academy profiles

I have this profile @gmail.com; my personal professional profile.I also have a @mycompany.com profile.How do I combine both so I can leave my current job for a better life without losing the accolades I'm accumulated under my @mycompany.com login giv...

  • 7687 Views
  • 9 replies
  • 5 kudos
Latest Reply
jChantoHdz
New Contributor II
  • 5 kudos

I have the same question, how this can be done?

  • 5 kudos
8 More Replies
gzr58l
by New Contributor
  • 170 Views
  • 1 replies
  • 0 kudos

How to setup lakeflow HTTP for connector with M2M Authentication

I am getting the following error about content-type with no option to pick a different content-type when configuring the lakeflow connectorThe OAuth token exchange failed with HTTP status code 415 Unsupported Media Type. The returned server response ...

  • 170 Views
  • 1 replies
  • 0 kudos
Latest Reply
saurabh18cs
Honored Contributor II
  • 0 kudos

Hi @gzr58l are you configuring a custom Lakeflow connector or external connection in Databricks? Also, consider using a service principal or personal access token (PAT) for authentication as a temporary workaround.

  • 0 kudos
JeffSeaman
by New Contributor III
  • 679 Views
  • 8 replies
  • 1 kudos

Resolved! JDCB Error trying a get schemas call.

Hi Community,I have a free demo version and can create a jdbc connection and get metadata (schema, table, and columns structure info). Everything works as described in the docs, but when working with someone who has a paid version of databricks the s...

  • 679 Views
  • 8 replies
  • 1 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 1 kudos

@JeffSeaman , please let us know if any of my suggestions help get you on the right track. If they do, kindly mark the post as "Accepted Solution" so others can benefit as well. Cheers, Louis.

  • 1 kudos
7 More Replies
jakesippy
by New Contributor III
  • 737 Views
  • 7 replies
  • 14 kudos

Resolved! How to get pipeline update duration programmatically

I'm looking to track how much time is being spent running updates for my DLT pipelines.When querying the list pipeline updates REST API endpoint I can see start and end times being returned, however, these fields are not listed in the documentation. ...

  • 737 Views
  • 7 replies
  • 14 kudos
Latest Reply
jakesippy
New Contributor III
  • 14 kudos

Originally went with the approach of exporting to and reading from the event log table, which has been helpful for getting other metrics as well.Also found today that there is a new system table is in public preview which exposes the durations I was ...

  • 14 kudos
6 More Replies
VIRALKUMAR
by Contributor II
  • 9641 Views
  • 5 replies
  • 0 kudos

How to Determine the Cost for Each Query Run Against SQL Warehouse Serverless?

Hello Everyone.First of all, I would like to thank you to databricks to enable system tables for customers. It does help a lot. I am working on cost optimization topic. Particularly sql warehouse serverless. I am not sure all of you have tried system...

  • 9641 Views
  • 5 replies
  • 0 kudos
Latest Reply
skumarraj
New Contributor II
  • 0 kudos

Can you Share the query that you used ?

  • 0 kudos
4 More Replies
aranjan99
by Contributor
  • 555 Views
  • 4 replies
  • 2 kudos

Databricks Pipeline SDK misisng fields

Looking at the Databricks Java SDK for Pipeline events, I see that the Rest API returns a details field that has the same information as event log details. But this is not surfaced in SDK, should be a small change to add it. Is that something which c...

  • 555 Views
  • 4 replies
  • 2 kudos
Latest Reply
ManojkMohan
Honored Contributor
  • 2 kudos

The start and end time fields in the Pipeline Updates API are currently present in the Databricks REST API but are not yet supported (i.e., not included or mapped) in the Databricks Java SDK as of September 2025.This means:You can see these fields (s...

  • 2 kudos
3 More Replies
manish24101981
by New Contributor
  • 1779 Views
  • 1 replies
  • 1 kudos

Resolved! DLT or DataBricks for CDC and NRT

We are currently delivering a large-scale healthcare data migration project involving:One-time historical migration of approx. 80 TB of data, already completed and loaded into Delta Lake.CDC merge logic is already developed and validated using Apache...

  • 1779 Views
  • 1 replies
  • 1 kudos
Latest Reply
mark_ott
Databricks Employee
  • 1 kudos

For cost-sensitive, large-scale healthcare data streaming scenarios, using Delta Live Tables (DLT) for both CDC and streaming (Option C) is generally the most scalable, manageable, and cost-optimized approach. DLT offers native support for structured...

  • 1 kudos
allancruz
by New Contributor
  • 1820 Views
  • 1 replies
  • 1 kudos

Resolved! Embedding Dashboards on Databricks Apps

Hi Team,I recently tried the Hello World template and embedded the <iframe> from the dashboard that I created. It works properly fine before I added some code to have a Login Form (I used Dash Plotly on creating the Login Form) before the dashboard a...

  • 1820 Views
  • 1 replies
  • 1 kudos
Latest Reply
mark_ott
Databricks Employee
  • 1 kudos

in databricks, I recently tried the Hello World template and embedded the <iframe> from the dashboard that I created. It works properly fine before I added some code to have a Login Form (I used Dash Plotly on creating the Login Form) before the...

  • 1 kudos
databricksdata
by New Contributor
  • 1653 Views
  • 1 replies
  • 1 kudos

Resolved! Assistance Required with Auto Liquid Clustering Implementation Challenges

Hi Databricks Team,We are currently implementing Auto Liquid Clustering (ALC) on our Delta tables as part of our data optimization efforts. During this process, we have encountered several challenges and would appreciate your guidance on best practic...

  • 1653 Views
  • 1 replies
  • 1 kudos
Latest Reply
mark_ott
Databricks Employee
  • 1 kudos

To implement Auto Liquid Clustering (ALC) on Delta tables in Databricks, especially when transitioning from external partitioned tables to unpartitioned managed tables, a careful and ordered process is crucial to avoid data duplication and ensure con...

  • 1 kudos
saicharandeepb
by New Contributor III
  • 1901 Views
  • 1 replies
  • 1 kudos

Resolved! Understanding High I/O Wait Despite High CPU Utilization in system.compute Metrics

Hi everyone,I'm working on building a hardware metrics dashboard using the system.compute schema in Databricks, specifically leveraging the cluster, node_type, and node_timeline tables.While analyzing the data, I came across something that seems cont...

  • 1901 Views
  • 1 replies
  • 1 kudos
Latest Reply
mark_ott
Databricks Employee
  • 1 kudos

Your observation highlights a subtlety in interpreting CPU metrics, especially in distributed environments like Databricks, where cluster and node-level behaviors can diverge from typical single-server intuition. Direct Answer No, seeing both high cp...

  • 1 kudos
piotrsofts
by New Contributor III
  • 1722 Views
  • 1 replies
  • 0 kudos

Resolved! LakeFlow Connect-&gt;GA4 - creation of Liquid Clustered stream table

Hello While creating new Data Ingestion from GA4, can we set-up Liquid Clustering (either Manual or Automatical) on destination table which will contain fetched data from GA4? 

  • 1722 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

Yes, in Databricks, it is possible to set up Liquid Clustering—both manual and automatic—on destination tables that store data ingested from Google Analytics 4 (GA4). This feature significantly improves table management and query performance compared...

  • 0 kudos
IONA
by New Contributor III
  • 179 Views
  • 1 replies
  • 0 kudos

Dabs Databricks asset bundles

Hi!I am relatively new to Dabs, but getting on quite well.I have managed to deploy both a job that uses a notebook defined in the bundle itself and a job that points to a notebook living in an azure devops git repo. While these are two viable solutio...

  • 179 Views
  • 1 replies
  • 0 kudos
Latest Reply
saurabh18cs
Honored Contributor II
  • 0 kudos

Hi @IONA ,you need to add a step into your CD pipeline to copy the notebook:- checkout: self- script: |cp path/to/notebook_in_repo/notebook.py .bundle/notebook.pydisplayName: 'Copy notebook into bundle'- script: |databricks bundle deploydisplayName: ...

  • 0 kudos
BenLambert
by Contributor
  • 3910 Views
  • 2 replies
  • 0 kudos

How to deal with deleted files in source directory in DLT?

We have a DLT pipeline that uses the autoloader to detect files added to a source storage bucket. It reads these updated files and adds new records to a bronze streaming table. However we would also like to automatically delete records from the bronz...

  • 3910 Views
  • 2 replies
  • 0 kudos
Latest Reply
boitumelodikoko
Valued Contributor
  • 0 kudos

I am looking for a solution to use with DLTs

  • 0 kudos
1 More Replies
shashankB
by New Contributor III
  • 329 Views
  • 2 replies
  • 4 kudos

Resolved! How to invoke Databricks AI Assistant from a notebook cell?

Hello Community,I am exploring the Databricks AI Assistant and wondering if there is a way to invoke or interact with it directly from a notebook cell instead of using the workspace sidebar UI.Is there any built-in command (like %assistant) to open o...

  • 329 Views
  • 2 replies
  • 4 kudos
Latest Reply
nayan_wylde
Esteemed Contributor
  • 4 kudos

@shashankB There are no command like %assistant exists today to interact with Databricks Assistant. As @szymon_dybczak mentioned in the reply  the exiting modes that you can interact with Assistant today.Also there is no published Assistant‑specific ...

  • 4 kudos
1 More Replies

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now
Labels