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

AkhileshVB
by New Contributor
  • 2251 Views
  • 2 replies
  • 1 kudos

Resolved! Syncing lakebase table to delta table

I have been exploring Lakebase and I wanted to know if there is a way to sync CDC data from Lakebase tables to delta table in Lakehouse. I know the other way is possible and that's what was shown in the demo. Can you tell how I can I sync both the ta...

  • 2251 Views
  • 2 replies
  • 1 kudos
Latest Reply
Malthe
Contributor II
  • 1 kudos

Just wanted to mention that the ETL from Lakebase to Delta Tables preview is mentioned here:https://www.databricks.com/blog/how-use-lakebase-transactional-data-layer-databricks-apps 

  • 1 kudos
1 More Replies
julius_bkr
by Visitor
  • 33 Views
  • 3 replies
  • 2 kudos

Hive Metastore End of Life

Hello everyone,is there a rough date on which the Hive Metastore will be deactivated?In the end, I ask the question again, which was already asked 2 years ago:Solved: Hive metastore table access control End of Support - Databricks Community - 50487We...

  • 33 Views
  • 3 replies
  • 2 kudos
Latest Reply
Abhishek_Patel
New Contributor
  • 2 kudos

HI @julius_bkr I do not think Databricks has any plans to retire HMA completely. However, Unity Catalog is the strategic direction and the recommended approach for new deployments and migrating existing data governance. Databricks is investing heavil...

  • 2 kudos
2 More Replies
dpc
by Contributor
  • 81 Views
  • 4 replies
  • 3 kudos

Resolved! Pass parameters between jobs

Hello I have jobIn that job, it runs a task (GetGid) that executes a notebook and obtains some value using dbutils.jobs.taskValuesSete.g. dbutils.jobs.taskValuesSet(key = "gid", value = gid)As a result, I can use this and pass it to another task for ...

  • 81 Views
  • 4 replies
  • 3 kudos
Latest Reply
dpc
Contributor
  • 3 kudos

Thanks @Hubert-Dudek and @ilir_nuredini I see this nowI'm setting using:dbutils.jobs.taskValues.Set()passing to the job task using Key - gid; Value - {{tasks.GetGid.values.gid}}Then reading using: pid = dbutils.widgets.get()

  • 3 kudos
3 More Replies
ismaelhenzel
by Contributor
  • 4476 Views
  • 2 replies
  • 0 kudos

Delta live tables - foreign keys

I'm creating ingestions using delta live tables, the dlt support the use of schema, with constraints like foreign keys. The problem is: how can i create foreign keys between the same pipeline, that has no read/write relation, but has foreign key rela...

  • 4476 Views
  • 2 replies
  • 0 kudos
Latest Reply
User12350
New Contributor II
  • 0 kudos

We ran into similar issues with our client, while migrating their on-prem table relationships to Databricks via DLT/LDP.The first proposed solution does not work on Materialized Views (MV).> 'ALTER TABLE ... ADD CONSTRAINT' expects a table but <objec...

  • 0 kudos
1 More Replies
flashmav1
by New Contributor
  • 85 Views
  • 6 replies
  • 3 kudos

Resolved! [NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up from

I am using dataricks version 15.4 and getting below error whicle reading from jdbc and writing to aws S3 location: [NUMERIC_VALUE_OUT_OF_RANGE.WITHOUT_SUGGESTION] The -12874815911431.6200000000 rounded half up from -12874815911431.6200000000 cannot b...

  • 85 Views
  • 6 replies
  • 3 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 3 kudos

 

  • 3 kudos
5 More Replies
Lenoq
by New Contributor
  • 113 Views
  • 4 replies
  • 2 kudos

Are there SQL linters for Databricks GUI queries and notebook %sql cells?

 I'm looking for SQL linters in two different contexts within Databricks GUI:SQL queries in Databricks SQL Editor (GUI) - Is there a built-in linter for writing SQL queries in the Databricks SQL workspace?%sql magic cells in Databricks notebooks (GUI...

  • 113 Views
  • 4 replies
  • 2 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 2 kudos

in databricks notebook is possible to connect own linters but I don't think it will work in SQL editor.

  • 2 kudos
3 More Replies
thatsawinner
by New Contributor II
  • 128 Views
  • 4 replies
  • 1 kudos

Resolved! Notebook Session Has Crashed

I am getting a pop-up error message in the right hand corner of my Databricks session, "Your notebook session has crashed."  This is a notebook I've been working in for a while.The only line of code I am running is pip listThe error at the bottom of ...

  • 128 Views
  • 4 replies
  • 1 kudos
Latest Reply
Hubert-Dudek
Esteemed Contributor III
  • 1 kudos

From the screen, it looks like an interactive cluster—maybe try rebooting it.

  • 1 kudos
3 More Replies
Lenoq
by New Contributor
  • 66 Views
  • 1 replies
  • 0 kudos

Looking for CLI-based SQL formatter for Databricks: Alternative to gethue/sql-formatter for .

I'm looking for a SQL formatter (CLI) for two different contexts within Databricks.1. SQL queries in .sql files - What tool does Databricks use by default to format SQL?2. %sql magic cells in notebooks (.ipynb files) - What tool does Databricks use b...

  • 66 Views
  • 1 replies
  • 0 kudos
Latest Reply
ilir_nuredini
Honored Contributor
  • 0 kudos

Hi @Lenoq ,As far as I know, currently there is no tool that meets your given criteria by databricks/labs. The closest that I can see is the tool you gave as an example, but as you said its not that good. what I would do maybe is an intermedial optio...

  • 0 kudos
Prasanna_N
by New Contributor
  • 3063 Views
  • 2 replies
  • 2 kudos

Inference table Monitoring

i have data from march1 to march 14 in the final inference table and i have given 1 week granularity. after that profile and drift table is generated and i see the window start time as like this objectstart: "2025-02-24T00:00:00.000Z"end: "2025-03-03...

  • 3063 Views
  • 2 replies
  • 2 kudos
Latest Reply
AbhayPSingh
Databricks Employee
  • 2 kudos

More or less repeating what Mark said and adding some additional thoughts. Why the Window Starts from February 24 The reason you're seeing a window starting from February 24 (even though your data starts March 1) is because monitoring systems align t...

  • 2 kudos
1 More Replies
Ronis
by New Contributor
  • 8948 Views
  • 6 replies
  • 1 kudos

SSRS Connect to Databricks

Hi ,I need to connect databricks query from microsoft SSRS.is it possible ? How do you make the connection?

  • 8948 Views
  • 6 replies
  • 1 kudos
Latest Reply
-werners-
Esteemed Contributor III
  • 1 kudos

SSRS has limited auth methods.  It also is EOL so my answer is: No.This is not a limitation of Databricks but SSRS.You could define the connection as a linked server on sql server, that might open some extra (MS native) options.PS. it is best not to ...

  • 1 kudos
5 More Replies
ManojkMohan
by Honored Contributor
  • 64 Views
  • 1 replies
  • 0 kudos

Exposing Databricks API in Salesforce

Use Case:I want to expose a data bricks API URL in Salesforce, Salesforce will hit that exposed end point every time a record is created and data will be transferred from Salesforce to DatabricksWhen i try creating a serving end pointI am unable to s...

ManojkMohan_0-1761252978733.png
  • 64 Views
  • 1 replies
  • 0 kudos
Latest Reply
mark_ott
Databricks Employee
  • 0 kudos

When integrating Salesforce with Databricks to push data upon record creation, using a serving endpoint is not the most common or optimal approach. Although Databricks Feature Serving endpoints can be used for model or feature APIs, they are primaril...

  • 0 kudos

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