Ashwin_DSA
Databricks Employee
Databricks Employee

Hi @sdurai,

Yes. Databricks has a native Salesforce connector for core Salesforce (Sales Cloud / Service Cloud / Platform objects) via Lakeflow Connect - Salesforce ingestion connector. It lets you create fully managed, incremental pipelines from Salesforce Platform data into Unity Catalog tables, using Bulk API 2.0 / REST under the hood.

Here are some docs for your reference. As I'm not sure which cloud you are on, I have shared both AWS and Azure links. 

Salesforce ingestion overview: AWS & Azure

Setting up ingestion (UI + Bundles): AWS & Azure

Salesforce connector FAQs (product coverage, APIs, limits): HERE - Same as what @szymon_dybczak has shared.

Lakehouse Federation - Salesforce Data 360 (query federation): HERE

Lakehouse Federation – Salesforce Data 360 File Sharing: HERE

If the managed connector isn’t available in your workspace, common alternatives are either exporting from Salesforce to cloud storage and ingesting with Auto Loader / standard file-based connectors, or building a custom connector in Databricks using the Salesforce REST/Bulk APIs or an OSS tool running on Databricks compute.

Hope this helps.

If this answer resolves your question, could you mark it as “Accept as Solution”? That helps other users quickly find the correct fix.

Regards,
Ashwin | Delivery Solution Architect @ Databricks
Helping you build and scale the Data Intelligence Platform.
***Opinions are my own***

View solution in original post