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

A_Motia
by • Visitor
  • 0 Views
  • 0 replies
  • 0 kudos

Production table maintenance

Hi Community members,I'm interested in how people monitor the effectiveness of Liquid Clustering as a Delta table grows over time.Consider below scenario:A table initially performs well, but MERGE operations gradually become slower even though the cl...

  • 0 Views
  • 0 replies
  • 0 kudos
Oumeima
by • Contributor
  • 106 Views
  • 2 replies
  • 3 kudos

Lakeflow Connect SQL Server (integrated CDC pipeline): no way to Include/exclude columns

Setup:- Lakeflow Connect, SQL Server source, `connector_type: CDC`, integrated pipeline (gateway-less — extraction and apply in one triggered pipeline on classic compute)- Deployed with Declarative Automation Bundles, `databricks-bundles` 1.20.0, CLI...

  • 106 Views
  • 2 replies
  • 3 kudos
Latest Reply
SumeshKashyap
Contributor
  • 3 kudos

 Hi @Oumeima Just checking in to see whether the explanation above helped, and whether you were able to move forward, either by keeping the gateway-based pipeline for the tables that need include_columns or by projecting the columns downstream. If it...

  • 3 kudos
1 More Replies
databrickspooja
by • Visitor
  • 41 Views
  • 1 replies
  • 0 kudos

Are PATs (user or service principal) accepted by Databricks Apps?

Is the 401 expected behavior, and is it documented anywhere?Is there a supported way for an external system with only a static header to call a Databricks App?I want to receive webhooks from an external SaaS product. The sender can only POST to a pub...

  • 41 Views
  • 1 replies
  • 0 kudos
Latest Reply
SumeshKashyap
Contributor
  • 0 kudos

Hi @databrickspooja Yes, the 401 is expected: the Databricks Apps proxy only accepts OAuth access tokens, not PATs, so it rejects the request before your code runs. A static header can't hold an OAuth token either, because M2M tokens expire after abo...

  • 0 kudos
juanlozadab
by • New Contributor III
  • 131 Views
  • 3 replies
  • 3 kudos

Resolved! Genie spaces with DABs - how do you deal with the table ordering?

Hi all,I'm about to start managing Genie spaces as code with Asset Bundles and wantedto ask before I build it.From what I'm reading, the genie_spaces resource needs the tables in itsdata_sources to already exist when you deploy. That's fine for an en...

  • 131 Views
  • 3 replies
  • 3 kudos
Latest Reply
VladTamas
New Contributor
  • 3 kudos

Short answer: you can keep everything in one bundle and one databricks bundle deploy. Add a job_runs resource that runs the job that builds the tables, and reference that run from the Genie agent so the CLI creates the agent last. On a redeploy the b...

  • 3 kudos
2 More Replies
DaveCh
by • Visitor
  • 55 Views
  • 4 replies
  • 2 kudos

issues creating a foreign catalog

I've created a foreign connection to an on prem sql server...CREATE CONNECTION IF NOT EXISTS `dagrbs-dr01`  TYPE SQLSERVER  OPTIONS (    host = secret('scope-kv-key-vault', 'ip-dagrbs-dr01'),    port = '1433',    user = secret('scope-kv-key-vault', '...

  • 55 Views
  • 4 replies
  • 2 kudos
Latest Reply
Ashwin_DSA
Databricks Employee
  • 2 kudos

Hi @DaveCh, The error message is a strong clue here: "Option host must not be empty and should not contain invalid characters" points to the value being resolved bysecret(), not to the server name itself. As per this documentation, the recommended pa...

  • 2 kudos
3 More Replies
Nick_Pacey
by • New Contributor III
  • 5740 Views
  • 4 replies
  • 1 kudos

Issue when trying to create a Foreign Catalog to a On Prem SQL Server Instance

Hi,We are creating a lakehouse federated connection to our 2016 On Prem SQL Server.  This has an instance in place, so we only want and need to connect to this instance.  From this connection, we want to create a foreign catalog of a database on the ...

  • 5740 Views
  • 4 replies
  • 1 kudos
Latest Reply
DaveCh
Visitor
  • 1 kudos

really appreciate everyone's feedback on this - I took the approach of avoiding the test connection and using only the ip not the secret, whcih included the port. when i created the catalog using a basic script the catolog was created no problem and ...

  • 1 kudos
3 More Replies
oliviaanne
by • Visitor
  • 34 Views
  • 1 replies
  • 1 kudos

Best Practices for Managing Permissions in Databricks Workspaces

Hi everyone,I’m interested in learning how other teams manage user permissions and access control in Databricks workspaces, especially when multiple users and groups need different levels of access.For example, when working with SQL Warehouses, Unity...

  • 34 Views
  • 1 replies
  • 1 kudos
Latest Reply
Aravind_Reddy
Databricks Partner
  • 1 kudos

Hello @oliviaanne In my experience, a scalable approach to managing permissions in Databricks is to combine group-based access control, centralized permission management, and regular access reviews rather than managing permissions individually throug...

  • 1 kudos
karuppusamy
by • Databricks Partner
  • 140 Views
  • 3 replies
  • 2 kudos

Supervisor Agent Deployments!

Hi Team,Could someone please help me deploy the Supervisor Agent using Azure DevOps? I would appreciate it if you could guide me through the deployment steps as well.Thank you.

  • 140 Views
  • 3 replies
  • 2 kudos
Latest Reply
Valeria_Koz_DBX
Databricks Employee
  • 2 kudos

Hi @karuppusamy , This refers to Databricks’ managed multi-agent orchestration experience in the Agents UI, specifically Supervisor Agent. For Azure DevOps: Create the Supervisor Agent in Agents > Create Agent > Supervisor Agent and add at least one ...

  • 2 kudos
2 More Replies
dkxxx-rc
by • Contributor
  • 75 Views
  • 1 replies
  • 0 kudos

Genie "Field" error: Table name or alias is required for column 'amount'

The documentation at https://docs.databricks.com/aws/en/genie-agents/tune-quality#define-sql-expressions says that you can create a "Field" in a genie agent (in the Examples section of config) with the code CASE WHEN amount < 10000 THEN 'Small' WHEN ...

field.png
  • 75 Views
  • 1 replies
  • 0 kudos
Latest Reply
VK210287
New Contributor II
  • 0 kudos

Hi @dkxxx-rc, Greetings. #1 — Documentation inconsistency: Yes, this appears to be an error in the docs. Notice that the Filter example on the same page correctly qualifies the column: orders.amount > 10000, but the Field example leaves amount unqual...

  • 0 kudos
scott_kao
by • New Contributor
  • 161 Views
  • 2 replies
  • 0 kudos

ServiceNow ingestion failed since October 1st.

I have a data ingestion pipeline ingesting ServiceNow data into databricks. It has been working for several months, but it stopped working since October 1st.From what I see, the pipeline suffered connection time out.However, from the connection, I ca...

Screenshot 2026-10-10 at 2.02.42 PM.png
  • 161 Views
  • 2 replies
  • 0 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 0 kudos

Hello @scott_kao, I took a look at both internal and external documentation and here is what I found. A working token refresh and an active ServiceNow account are good signs, but they don't rule out a connectivity or ServiceNow API performance proble...

  • 0 kudos
1 More Replies
browsingbeaver
by • New Contributor
  • 160 Views
  • 2 replies
  • 3 kudos

Resolved! Add custom_tags and budget_policy_id support to Declarative Automation Bundle presets

Declarative Automation Bundle presets currently allow common deployment configuration to be reused across resources. For enterprise platform teams, it would be valuable if presets could also support custom_tags and budget_policy_id.This would allow o...

  • 160 Views
  • 2 replies
  • 3 kudos
Latest Reply
data_pulse
New Contributor III
  • 3 kudos

@browsingbeaver I did a quick bundle validation around this:presets.budget_policy_id is not currently supported: strict bundle validation reports it as an unknown field.budget_policy_id is valid at the individual job resource level.Adding it under pr...

  • 3 kudos
1 More Replies
a_user12
by • Contributor
  • 252 Views
  • 2 replies
  • 1 kudos

Declarative Pipeline with editable wheel: PYTHON.MODULE_NOT_FOUND_ERROR

Hi!I create a bundle with databricks bundle initand i let create a pipeline including a package. The pipeline definition looks like the following# The main pipeline for pipelinewithpackage resources: pipelines: pipelinewithpackage_etl: n...

databricks.png
Data Engineering
lakeflow pipelines
  • 252 Views
  • 2 replies
  • 1 kudos
Latest Reply
a_user12
Contributor
  • 1 kudos

Hi - Thank you for your quick response.I checked 1-3: everything seems to be fine:I can build manually and see all files workspace.file_path​contains the filesSo I provide additional information.Folder Treeª .gitignore ª AGENTS.md ª CLAUDE.md ª...

  • 1 kudos
1 More Replies
DineshOjha
by • New Contributor III
  • 468 Views
  • 4 replies
  • 3 kudos

Notebook commands hang after restarting a cluster with custom library installed

Hi,I'm experiencing an issue with a Databricks notebook after restarting a cluster that has a custom library installed.Here are the steps I followed:Created a Databricks compute cluster.Attached a notebook to the cluster.Installed a library required ...

  • 468 Views
  • 4 replies
  • 3 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 3 kudos

Hello @DineshOjha,  Short answer: this isn't expected behavior. When terminated compute starts again, Databricks recreates it, reinstalls the configured libraries, and reattaches notebooks. If a library is still pending, fails to install, or conflict...

  • 3 kudos
3 More Replies
Khasim_1
by • New Contributor III
  • 446 Views
  • 4 replies
  • 2 kudos

How does AUTO CDC resolve same-timestamp tie in SEQUENCE BY?

We are using AUTO CDC (APPLY CHANGES INTO) to process change data capture events from an upstream source (via Autoloader ingesting CDC files landed in cloud storage) into our Silver layer tables. Our source occasionally delivers out-of-order events —...

  • 446 Views
  • 4 replies
  • 2 kudos
Latest Reply
Louis_Frolio
Databricks Employee
  • 2 kudos

Hello @Khasim_1, I took a look at both internal and external documentation and here is what I found. You're in good hands in this thread already. @Brahmareddy's STRUCT suggestion and @data_pulse's test both line up with the documented behavior, and @...

  • 2 kudos
3 More Replies
Labels