- 89 Views
- 5 replies
- 0 kudos
Lakebridge analyzer not able to determine DDL.
Databricks analyzer does not shows any DDL statement count, I've also tested with just a simple SELECT * query (SELECT * FROM SCHEMA_NAME.TABLE_NAME;) . Is there any solution for this ?My target was to get a detailed analysis on SnowSQL code. Any h...
- 89 Views
- 5 replies
- 0 kudos
- 0 kudos
The Lakebridge analyzer counts DDL statements, not regular queries. A simple SELECT * is DML, not DDL, so it won’t show up in the DDL count.To get meaningful results for SnowSQL code analysis:Include actual DDL statements like CREATE TABLE, ALTER TAB...
- 0 kudos
- 17 Views
- 1 replies
- 0 kudos
Adding maven dependency to ETL pipeline
Hello guys,I'm building ETL pipeline and need to access HANA data lake file system. In order to do that I need to have sap-hdlfs library in compute environment, library is available in maven repository.My job will have multiple notebook task and ETL ...
- 17 Views
- 1 replies
- 0 kudos
- 0 kudos
Hi @anhnnguyen ,Unfortunately, Scala or Java libraries are not supported in lakeflow declarative pipeline (ETL Pipelines). So you need to use regular job if you want to install maven dependencies.Manage Python dependencies for pipelines | Databricks ...
- 0 kudos
- 10 Views
- 0 replies
- 0 kudos
I/F security about using medallion architecture
I’m new to writing requirement definitions, and I’d like to ask a question about interface (I/F) security.My question is:Do I need to define the authentication and security mechanisms (such as OAuth2, Managed Identity, Service Principals, etc.) betwe...
- 10 Views
- 0 replies
- 0 kudos
- 4106 Views
- 1 replies
- 0 kudos
Schema Registry certificate auth with Unity Catalog volumes.
Greetings.We currently have a Spark structured streaming job (Scala) retrieving avro data from an Azure Eventhub with a confluent schema registry endpoint (using an Azure Api Management gateway with certificate authentication).Until now the .jks file...
- 4106 Views
- 1 replies
- 0 kudos
- 0 kudos
Thanks for the detailed context—here’s a concise, actionable troubleshooting plan tailored to Databricks with Unity Catalog volumes and Avro + Confluent Schema Registry over APIM with mTLS. What’s likely going wrong Based on your description, the ini...
- 0 kudos
- 4665 Views
- 2 replies
- 0 kudos
Adding a message to azure service bus
I am trying to send a message to a service bus in azure. But I get following error:ServiceBusError: Handler failed: DefaultAzureCredential failed to retrieve a token from the included credentials.This is the line that fails: credential = DefaultAzure...
- 4665 Views
- 2 replies
- 0 kudos
- 0 kudos
It looks like the issue is with the Azure credential chain rather than Service Bus itself; in Databricks notebooks, DefaultAzureCredential won’t succeed unless there’s a valid identity available (env vars, CLI login, managed identity, or a Databricks...
- 0 kudos
- 4056 Views
- 2 replies
- 1 kudos
DLT x UC x Auto Loader
Now that the Directory Listing Mode of Auto Loader is officially deprecated, is there a solution for using File Notification Mode in a DLT pipeline writing to a UC-managed table? My understanding is that File Notification Mode is only available on si...
- 4056 Views
- 2 replies
- 1 kudos
- 1 kudos
Yes: use Auto Loader’s UC-managed file events in DLT with DBR 14.3 LTS or later; enable file events on the UC external location and set managed file events in the stream. This avoids the legacy file notifications’ single-user compute limitation and w...
- 1 kudos
- 4937 Views
- 2 replies
- 0 kudos
How Install Pyrfc into AWS Databrick using Volumes
I'm trying to install Pyrfc in a Databricks Cluster (already tried in r5.xlarge, m5.xlarge, and c6gd.xlarge). I'm following these link.https://community.databricks.com/t5/data-engineering/how-can-i-cluster-install-a-c-python-library-pyrfc/td-p/8118Bu...
- 4937 Views
- 2 replies
- 0 kudos
- 0 kudos
Thanks for the details. The PyRFC package is a Python binding around the SAP NetWeaver RFC SDK and requires the SAP NW RFC SDK to be present at build/run time; it does not work as a pure Python wheel on Linux without the SDK. The project is archived ...
- 0 kudos
- 2774 Views
- 2 replies
- 1 kudos
how to add Microsoft Entra ID managed service principal to aws databricks
Hi,I would like to add a Microsoft Entra ID managed service principal to AWS Databricks, but I have noticed that this option does not appear to be available-I am only able to create managed service principals directly within Databricks.For comparison...
- 2774 Views
- 2 replies
- 1 kudos
- 1 kudos
You cannot add a Microsoft Entra ID–managed service principal to Databricks on AWS today; AWS workspaces only support Databricks‑managed service principals that you create in the Databricks account/workspace, not service principals federated from Ent...
- 1 kudos
- 3085 Views
- 3 replies
- 0 kudos
What is the best way to connect Oracle CRM cloud from databricks?
What is the best way to connect Oracle CRM cloud from databricks?
- 3085 Views
- 3 replies
- 0 kudos
- 0 kudos
Oracle CRM on Demand is a Cloud platform not a relational database.Is there any proven solution for this requirement?
- 0 kudos
- 48 Views
- 5 replies
- 3 kudos
Resolved! Accessing Databricks data in Salesforce via zero copy
I have uploaded clickstream data as shown belowDo i have to mandatorily share via Delta sharing for values to be exposed in Salesforce ?At the Salesforce end i have confirmed that i have a working connector where i am able to see samples data , but u...
- 48 Views
- 5 replies
- 3 kudos
- 3 kudos
So, for instance I have catalog called project in databricks free edition. If I would like to assign proper permission for my Service Principal (so that it can see the tables wihtin catalog and can query them) first I need to set 2 preequisite permis...
- 3 kudos
- 9544 Views
- 5 replies
- 6 kudos
Resolved! Limit on number of result rows displayed on databricks SQL UI
Databricks SQL UI currently limits the query results display to 64000 rows. When will this limit go away? Using SSMS I get 40MM rows results in the UI and my users won't switch to databricks SQL for this reason
- 9544 Views
- 5 replies
- 6 kudos
- 6 kudos
want to understand the reason behind it. retrieving 500k records is not a problem, is it rendering over the http thats the problematic?
- 6 kudos
- 28 Views
- 4 replies
- 2 kudos
Lakeflow jobs
Hi I am currently working on migrating all ADF jobs to LakeFlow jobs. I have a few questions:Pipeline cost: What is the cost model for running LakeFlow pipelines? Any documentation available? ADF vs Lakeflow Job?Job reuse: Do LakeFlow jobs reuse the...
- 28 Views
- 4 replies
- 2 kudos
- 2 kudos
Hi @Nidhig ,1. Regarding pipeline cost - here you're mostly paying for compute usage. So the exact price depends on which plan you are at and which cloud provider you are using. For instance, for Azure premium plan and US East region you have followi...
- 2 kudos
- 38 Views
- 2 replies
- 1 kudos
How to make streaming files?
Thanks for reviewing my threads.I am trying to test streaming table /files in databricks FREE edition.-- Create test streaming tableCREATE OR REFRESH STREAMING TABLE user.demo.test_bronze_st ASSELECT * FROM STREAM read_files('/Volumes/xxx_ws/demo/raw...
- 38 Views
- 2 replies
- 1 kudos
- 1 kudos
Thanks for weighing in. Are you saying CREATE OR REFRESH STREAMING TABLE user.demo.test_bronze_st cannot be used in FREE Edition?If we can use it, how do to create STREAM read_files('/Volumes/xxx_ws/demo/raw_files/test.csv'),where .csv sitting on lo...
- 1 kudos
- 34 Views
- 1 replies
- 0 kudos
Can’t save results to target table – out-of-memory error
Hi team, I’m processing ~5,000 EMR notes with a Databricks notebook. The job reads from `crc_lakehouse.bronze.emr_notes`, runs SciSpaCy UMLS entity extraction plus a fine-tuned BERT sentiment model per partition, and builds a DataFrame (`df_entities`...
- 34 Views
- 1 replies
- 0 kudos
- 0 kudos
You’re right that the behaviour is weird at first glance (“5k rows on a 64 GB cluster and I blow up on write”), but your stack trace is actually very revealing: this isn’t a classic Delta write / shuffle OOM – it’s SciSpaCy/UMLS falling over when loa...
- 0 kudos
- 32 Views
- 1 replies
- 1 kudos
What the best Framework/Package for data quality
Hi everyone,I’m currently looking for a data-quality solution for my environment. I don’t have DTL tables or a Unity Catalog in place.In your opinion, what is the best framework or package to implement reliable data-quality checks under these conditi...
- 32 Views
- 1 replies
- 1 kudos
- 1 kudos
Here are few DQ packages for DLT or LDP that you can try.1. Databricks Labs DQXPurpose-built for Spark and Databricks.Rule-based checks on DataFrames (batch & streaming).Supports quarantine and profiling.Lightweight and easy to integrate.2. Great Exp...
- 1 kudos
| User | Count |
|---|---|
| 1619 | |
| 790 | |
| 488 | |
| 349 | |
| 287 |
