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

vkondepati
by • Databricks Partner
  • 466 Views
  • 0 replies
  • 1 kudos

V.E.N.K.A.T Framework™

Hello Databricks Community,I recently published the V.E.N.K.A.T Framework™, an enterprise architecture model for the Agentic AI era.The idea is simple:As AI moves from generating insights to taking actions, the architecture underneath becomes critica...

  • 466 Views
  • 0 replies
  • 1 kudos
GJ2
by • New Contributor II
  • 30428 Views
  • 16 replies
  • 2 kudos

Install the ODBC Driver 17 for SQL Server

Hi,I am not a Data Engineer, I want to connect to ssas. It looks like it can be connected through pyodbc. however looks like  I need to install "ODBC Driver 17 for SQL Server" using the following command. How do i install the driver on the cluster an...

GJ2_1-1739798450883.png
  • 30428 Views
  • 16 replies
  • 2 kudos
Latest Reply
lilydays
New Contributor II
  • 2 kudos

If you're only connecting to SSAS, installing the ODBC Driver 17 for SQL Server is usually the first step, but the exact method depends on your cluster environment and operating system. If it's a managed cluster, you may need admin access or an scrip...

  • 2 kudos
15 More Replies
batch_bender
by • New Contributor III
  • 989 Views
  • 2 replies
  • 1 kudos

Resolved! Folder structure for Autoloader and Declarative Pipelines

We have six years of Parquet files organised under yyyy/mm/dd/, with around 100 table files in each daily folder. We want to process these 100 tables using Auto Loader in a Declarative Pipeline with the AUTO CDC API.If each table reads the same root ...

  • 989 Views
  • 2 replies
  • 1 kudos
Latest Reply
GabFernandes
Contributor III
  • 1 kudos

Hi @batch_bender ,Yes, pointing Auto Loader to the root path with a filename wildcard for every table will cause significant file discovery overhead, as each stream independently crawls the entire directory tree (yyyy/mm/dd/).Best Practice Recommenda...

  • 1 kudos
1 More Replies
matko
by • New Contributor II
  • 492 Views
  • 1 replies
  • 0 kudos

oreign Iceberg tables via HMS federation fail with browse_only_table on all compute — request Public

Per your documentation (hms-federation-concepts), Apache Iceberg tables in federated external Hive metastores are Public Preview on Databricks Runtime 16.2+, with no enablement steps listed. On our workspace, every read of a federated Iceberg table f...

  • 492 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 0 kudos

Hi matko,The underlying issue here is mostly a missing backend feature enablement for the workspace. Databricks frequently gates these newer federation capabilities behind workspace-level or account-level enablement during the preview phase.Unity Cat...

  • 0 kudos
Sam500
by • New Contributor III
  • 687 Views
  • 1 replies
  • 0 kudos

Resolved! Multi-Engine Lakehouses

Hi experts,I recently came across an interesting discussion titled “Are enterprises moving from ‘Data Lakehouse’ to ‘Agentic Lakehouse’?” https://community.databricks.com/t5/data-engineering/are-enterprises-moving-from-quot-data-lakehouse-quot-to-quo...

  • 687 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor II
  • 0 kudos

Hi Sam500,The multi engine pattern usually comes to establishing interoperability at the storage format level while maintaining a single, unified governance layer. You handle this primarily through Unity Catalog (UC) and format flexibility such as De...

  • 0 kudos
binlogreader
by • Contributor III
  • 644 Views
  • 2 replies
  • 2 kudos

DLT driver GC pressure during a large initial hydration. Is a bigger driver the only lever?

Last week one of our DLT pipelines spent five hours in RUNNING with nothing landing, and I'd like to compare notes on how people handle the underlying problem, because we found one fix and several dead ends.Setup: A continuous DLT pipeline on classic...

  • 644 Views
  • 2 replies
  • 2 kudos
Latest Reply
masonreed11
Contributor
  • 2 kudos

I ran into something similar, and the event log was the only place that made the root cause obvious. I don't believe there's an officially supported setting to limit concurrent DLT flows, so I'd avoid undocumented configs. For large initial backfills...

  • 2 kudos
1 More Replies
Dhruv-22
by • Contributor III
  • 1347 Views
  • 6 replies
  • 0 kudos

Resolved! VOID column inside STRUCT fails to cast to VARIANT

Let's say I have the following dataframe%sqlCREATE OR REPLACE TEMPORARY VIEW v_temp ASVALUES (NULL, DATE'2025-12-31'), (NULL, DATE'2026-04-12'), (NULL, DATE'2026-06-23') AS T(PAYMENT_DATE, TRANSACTION_DATE);SELECT PAYMENT_DATE, TYPEOF(PAYMENT_DATE), ...

Dhruv22_0-1785136495855.png Dhruv22_1-1785136581445.png Dhruv22_2-1785136658557.png Dhruv22_3-1785136718467.png
  • 1347 Views
  • 6 replies
  • 0 kudos
Latest Reply
AbhilashNagilla
Databricks Employee
  • 0 kudos

Your screenshot already uses TO_VARIANT_OBJECT; the VOID field inside the STRUCT is what causes the failure. TO_VARIANT_OBJECT requires every field to be convertible to VARIANT, but VOID is not accepted in that nested path. Scalar CAST(PAYMENT_DATE A...

  • 0 kudos
5 More Replies
swang-pg
by • New Contributor II
  • 414 Views
  • 1 replies
  • 2 kudos

Merging 2 versions of an SCD table created from a managed ingestion pipeline

We've been using the Salesforce Databricks connector to ingest data into Databricks with history tracking (SCD2) turned on. The licence to one of the add-on modules was accidentally revoked for our ingestion user and subsequently reinstated. This led...

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

@swang-pg We did not run into the error but had a similar situation of stitching tables while using Salesforce and Mysql connectors so I can share what we did. Two things about the situation shape what the merge can look like.The first is that the me...

  • 2 kudos
Soham-003
by • New Contributor II
  • 1268 Views
  • 2 replies
  • 1 kudos

Resolved! Genie Ontology access on Free Edition

Hi Community,I am currently using the  Free Edition and I would like to explore Genie Ontology as part of a project.I checked my account and it seems Genie Ontology is not yet available on the Free Edition. Could someone guide me on how to request ac...

  • 1268 Views
  • 2 replies
  • 1 kudos
Latest Reply
GabFernandes
Contributor III
  • 1 kudos

Hi!To answer your question directly: Databricks Genie (and Genie Spaces / Ontology) is not available on the Databricks Community Edition (Free Edition), and there is currently no waitlist to enable it within that environment.Here is why, along with t...

  • 1 kudos
1 More Replies
dbernstein_tp
by • Contributor II
  • 1189 Views
  • 3 replies
  • 4 kudos

Resolved! Recommendations for a spreadsheet like interface that writes back to a databricks table

Hi Everyone, There is a need for a lakehouse front-end tool at my company that operates like an excel spreadsheet but reads/writes to a lakehouse table. This would replace actual spreadsheets that are passed around, manually updated, and then collate...

  • 1189 Views
  • 3 replies
  • 4 kudos
Latest Reply
dbernstein_tp
Contributor II
  • 4 kudos

Thanks, great information!

  • 4 kudos
2 More Replies
Phani1
by • Databricks MVP
  • 6039 Views
  • 5 replies
  • 2 kudos

Multi languages support in Databricks

Hi Team,How can I set up multiple languages in Databricks? For example, if I connect from Germany, the workspace and data should support German. If I connect from China, it should support Chinese, and if I connect from the US, it should be in English...

  • 6039 Views
  • 5 replies
  • 2 kudos
Latest Reply
honey_sharma
New Contributor III
  • 2 kudos

Great question! Databricks doesn't automatically change the workspace or data language based on a user's location. The best practice is to keep your data language-neutral, store translations in separate tables, detect the user's preferred language (s...

  • 2 kudos
4 More Replies
shama1
by • New Contributor II
  • 4829 Views
  • 3 replies
  • 3 kudos

Resolved! Not able to reset password with password re-set link

I am not able to reset password https://community.cloud.databricks.com/When I use link provided in the email to re-set the password, and I enter new password, request never gets completed.Password reset link keeps on loading even after entering passw...

image
  • 4829 Views
  • 3 replies
  • 3 kudos
Latest Reply
Anusha6
New Contributor II
  • 3 kudos

I am not able to connect to Databricks partner academy login. The databricks SSO login directs me to MFA passkey. But I donot have a passkey setup.

  • 3 kudos
2 More Replies
maninegi05
by • New Contributor II
  • 562 Views
  • 1 replies
  • 1 kudos

Databricks Apps (Streamlit) - How to Implement Proper Logout Functionality?

We have built a Databricks App using Streamlit and are looking for a way to implement a proper logout functionality.Currently, we built Logout functionality where we can clear the Streamlit session state and client-side cookies. However, the Databric...

  • 562 Views
  • 1 replies
  • 1 kudos
Latest Reply
emma_s
Databricks Employee
  • 1 kudos

Hi, At the moment this is not a supported feature, you may want to raise it as a feautre request via your account team. Having said that there are a few things you could try to get a near but not perfect experience. Here are some options for you to e...

  • 1 kudos
LincolnGarbin
by • New Contributor III
  • 1303 Views
  • 2 replies
  • 3 kudos

Resolved! What happens to Databricks notebooks and jobs when a user's Microsoft account is deactivated?

Hi everyone,I recently joined a company where we use Databricks to process and transform data that is ultimately used in our Power BI reports and dashboards.The person who has been training me is leaving the company. Our Databricks environment is int...

  • 1303 Views
  • 2 replies
  • 3 kudos
Latest Reply
GabFernandes
Contributor III
  • 3 kudos

Hi!This is a very common scenario when dealing with identity integration between Microsoft Entra ID (Azure AD) and Databricks.Here is a breakdown of what happens when a corporate account is deactivated, followed by the best practices to ensure zero d...

  • 3 kudos
1 More Replies
17abhishek
by • New Contributor III
  • 399 Views
  • 1 replies
  • 0 kudos

Issue with Notebook Scrolling Position While Switching Between Multiple Notebooks

Hi Team,For the past 1–2 weeks, I have been experiencing an issue while working with multiple notebooks simultaneously. Whenever I switch from one notebook to another, the notebook automatically scrolls back to Cell 1 instead of retaining my current ...

  • 399 Views
  • 1 replies
  • 0 kudos
Latest Reply
Brahmareddy
Esteemed Contributor II
  • 0 kudos

Hi Abhi,How are you doing today? as per my understanding, this looks like a notebook state or browser session issue. As a temporary workaround, try opening notebooks in separate browser tabs, testing in incognito mode, or clearing the browser cache.I...

  • 0 kudos
Labels