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

DwarkaPandey
by Visitor
  • 39 Views
  • 1 replies
  • 0 kudos

Multi-select dashboard parameter now resolves to NULL instead of empty array?

Hi everyone,We're seeing a change in the behavior of multi-select dashboard parameters in Databricks SQL dashboards.Previously, when no value was selected in a multi-select filter, our query logic worked as expected using:SIZE(:my_parameter) = 0Howev...

  • 39 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor
  • 0 kudos

The platform is aligning with standard SQL semantics (IS NULL etc) and you can follow it. To fix the queries returning zero rows on load, you need to explicitly evaluate for NULL before passing the parameter to any array-specific functions or IN clau...

  • 0 kudos
ChristianRRL
by Honored Contributor
  • 79 Views
  • 1 replies
  • 1 kudos

What is the compute for Lakeflow Connect SharePoint Connector

Can someone help me understand what compute the SharePoint Connector is using by default? I'm trying to use Job Compute, but it "seems" like it may be defaulting to serverless. 

ChristianRRL_0-1784588867082.png
  • 79 Views
  • 1 replies
  • 1 kudos
Latest Reply
anagilla
Databricks Employee
  • 1 kudos

The managed SharePoint connector uses serverless compute; it can't be switched to classic Job Compute. The Job you see is the orchestration layer: Lakeflow Connect creates it for the schedule and runs the ingestion pipeline as a task, while the pipel...

  • 1 kudos
hdu
by New Contributor III
  • 371 Views
  • 3 replies
  • 0 kudos

select table_changes() return unexpected results

Hi Folks,My understanding isSELECT *FROM table_changes('mytable', x)should return all changes from version x through the latest available version, regardless of when I run it. However what happen to me is:When immediately after a streaming table upda...

hdu_0-1783525115352.png
  • 371 Views
  • 3 replies
  • 0 kudos
Latest Reply
binlogreader
New Contributor
  • 0 kudos

 Perhaps you try running one more variation?Your second query groups by date_extraction only which is a business column, so it can't tell us which commit those rows came from. Seeing the 2026-04-09 rows doesn't yet prove the result contains version 2...

  • 0 kudos
2 More Replies
primopragma
by New Contributor II
  • 518 Views
  • 7 replies
  • 0 kudos

Getting 'Unauthorized Access' when Serverless compute is trying to read s3 bucket data

Getting 'Unauthorized Access' when Serverless compute is trying to read s3 bucket data, same works fine with normal compute storage and external location, credentials, IAM policy and serverless egress rules all seems to be correct because normal comp...

  • 518 Views
  • 7 replies
  • 0 kudos
Latest Reply
binlogreader
New Contributor
  • 0 kudos

One data point that may be useful, we run serverless SQL against several external locations that were created manually through the API rather than auto-created, and they read fine from serverless.So I don't think you've hit a general rule that custom...

  • 0 kudos
6 More Replies
ChristianRRL
by Honored Contributor
  • 105 Views
  • 2 replies
  • 1 kudos

Resolved! Lakeflow Connect & Community Connectors - 403 Errors + What is the compute?

Hi there,I am regularly getting 403 errors with Lakeflow Connect or Community Connectors accessing our UC catalog/schema. As far as I'm seeing, I believe that we have the proper role on our Azure storage account (Storage Blob Data Contributor), and t...

ChristianRRL_0-1784587188350.png
  • 105 Views
  • 2 replies
  • 1 kudos
Latest Reply
binlogreader
New Contributor
  • 1 kudos

@ChristianRRL Most likely the compute behind these connectors is serverless, and that would explain both parts of your question. SharePoint and the community connectors run on serverless compute only as far as I know.The docs list serverless as a pre...

  • 1 kudos
1 More Replies
ChristianRRL
by Honored Contributor
  • 428 Views
  • 3 replies
  • 0 kudos

Lakeflow Connect SharePoint - 403 Error

Hi, I'd like some help clarifying how lakeflow connect pipelines work (or should work). I went through the steps to (1) set up a connection, and (2) setup the ingestion, but I keep running into the following error:Operation failed: "This request is n...

ChristianRRL_2-1784142904393.png ChristianRRL_1-1784142354143.png ChristianRRL_0-1784142213049.png
  • 428 Views
  • 3 replies
  • 0 kudos
Latest Reply
GabFernandes
New Contributor III
  • 0 kudos

Hi! The 403 error you're seeing is almost certainly not coming from SharePoint — it's coming from Azure Storage.The key clue is in the error detail: access denied to /cas cloud path. The /cas path is Unity Catalog's managed storage location (Catalog ...

  • 0 kudos
2 More Replies
TheDataMaverick
by Databricks Partner
  • 2877 Views
  • 2 replies
  • 3 kudos

Resolved! Cost-Effective Databricks Pipeline for API Ingestion - Best Practices?

Hi Community,As a senior data engineer migrating ETL workloads to Databricks (with Unity Catalog and Delta Lake), I'm building a cost-effective pipeline to ingest data from a REST API. Goals: minimize DBU costs, handle incremental loads, ensure scala...

  • 2877 Views
  • 2 replies
  • 3 kudos
Latest Reply
Pat
Esteemed Contributor
  • 3 kudos

HI @TheDataMaverick ,The most efficient approach for your REST API ingestion pipeline on Databricks is to use an external service like Azure Functions (or AWS Lambda) to handle API calls, then land raw JSON/Parquet in ADLS/S3 for Auto Loader ingestio...

  • 3 kudos
1 More Replies
kosarchik
by New Contributor
  • 114 Views
  • 1 replies
  • 0 kudos

Jobs and pipelines UI

Hello, Could you please explain how to enable the same UI interface that my colleague has (shown in the first picture)? Unfortunately, my interface looks like the second picture, where the Error code filter does not highlight or display the number of...

  • 114 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor
  • 0 kudos

What you are seeing is likely a classic staged UI rollout. Databricks frequently pushes updates such as the aggregated error code metrics on the Job Runs page using user-level feature flags or testing cohorts. Because these flags can be evaluated at ...

  • 0 kudos
Mizan1
by New Contributor
  • 71 Views
  • 1 replies
  • 0 kudos

😑Datafactory insists on Cluster compute BUT Databricks defaults to Serverless compute!

Hi all,#Databricks#DatafactoryI hope you are well.I have bullet pointed my situation to allow other community members to easily diagnose my problem (I want to make your lives easy as well!).I have also included screenshot of data pipeline in DataFact...

datafactory_pipeline-diagram.png publishing_pipeline_error.png databricks_compute_SQL-warehouses-redirection.png
  • 71 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor
  • 0 kudos

The reason you are only seeing SQL Warehouses when clicking Compute is likely because the workspace admin has locked down interactive cluster creation. Check if you have the cluster creation entitlement. Your workspace admin can grant you the correct...

  • 0 kudos
Niyojit
by New Contributor
  • 95 Views
  • 1 replies
  • 0 kudos

Resolved! How to load PDFs incrementally in volume?

 I'm building an Intelligent Document Processing pipeline using Databricks AI Functions (ai_parse_document and ai_extract).I want to ingest PDF files from a Google Drive folder into a Unity Catalog Volume. I can perform a full load successfully using...

  • 95 Views
  • 1 replies
  • 0 kudos
Latest Reply
balajij8
Esteemed Contributor
  • 0 kudos

You can use the Google Drive Managed connector that does most of it primarily built for syncing structured data directly to Delta Tables or the Standard connector that allows you to use Databricks (SQL, Auto Loader, pipelines) directly against a Goog...

  • 0 kudos
prakharsachan
by New Contributor III
  • 220 Views
  • 4 replies
  • 2 kudos

Databricks YAML files

when i change the yam file(not the resources one but can be any config yml) locally and then redeploy that bundle , the changes are not visible in the remote yml but other files(.py, .sql) do reflect these changes. FYI: during dev , i make changes in...

  • 220 Views
  • 4 replies
  • 2 kudos
Latest Reply
binlogreader
New Contributor
  • 2 kudos

@prakharsachan What you're seeing is designed behavior, not a bug.When you run `bundle deploy`, the CLI does not upload everything in your bundle folder. It builds the upload list by walking the directory and skipping anything your .gitignore matches...

  • 2 kudos
3 More Replies
rjcrystal786
by New Contributor II
  • 448 Views
  • 3 replies
  • 0 kudos

Advanced Learning Festival (15 June - 06 July 2026) - Voucher Eligibility Confirmation

Hello @Jim ,I completed all four modules of Learning Pathway 1 (Associate Data Engineering) for the Advanced Learning Festival on July 6, 2026, the published end date of the event. My Academy account email is [datasci.patel.rupesh@gmail.com]. Screens...

  • 448 Views
  • 3 replies
  • 0 kudos
Latest Reply
rjcrystal786
New Contributor II
  • 0 kudos

Hi @Ashwin_DSA ,Thank you for the confirmation. Following up as it's now July 17 and I haven't yet received the voucher at the email address associated with my Academy account (I've checked spam/promotions folders as well).For reference, I completed ...

  • 0 kudos
2 More Replies
Labels