topic Re: Accessing Databricks data in Salesforce via zero copy in Data Engineering

Accessing Databricks data in Salesforce via zero copy

ManojkMohan — Mon, 17 Nov 2025 15:50:23 GMT

I have uploaded clickstream data as shown below

Do 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 unable to see SFDB data

unbale to see SFDB

Looking for help to nail down the root cause

I am using the databricks free community edition

Re: Accessing Databricks data in Salesforce via zero copy

bianca_unifeye — Mon, 17 Nov 2025 16:03:26 GMT

@hasnat_unifeye I think you setup recently the Salesforce connector. Can you please have a look at the issue described above? Thanks.

Re: Accessing Databricks data in Salesforce via zero copy

szymon_dybczak — Mon, 17 Nov 2025 17:54:54 GMT

Hi @ManojkMohan ,

You need to assign a correct set of grants to your service principal on Unity Catalog.

To query a table in Unity Catalog you need at minimum following privileges

- USE CATALOG - on the parent catalog of the table

- USE SCHEMA - on the parent schema of the table

- SELECT on the table itself

So, could you assign those permission to the Service Principal you're using to connect to databricks in Salesforce?

Re: Accessing Databricks data in Salesforce via zero copy

ManojkMohan — Mon, 17 Nov 2025 18:02:58 GMT

@szymon_dybczak But does the data bricks community free edition have unity catalog capabilities ?

Re: Accessing Databricks data in Salesforce via zero copy

szymon_dybczak — Mon, 17 Nov 2025 18:16:08 GMT

Yes @ManojkMohan , it does. Based on your setup you have created sfdb catalog with default schema and 2 tables: e_clothing and salesforce_activation_data.

Now you need to grant the permission I've mentioned at post above to your service principal.

Re: Accessing Databricks data in Salesforce via zero copy

szymon_dybczak — Mon, 17 Nov 2025 18:20:16 GMT

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 permission (red number 3 on screen below):

Here you can also specify SELECT permission in READ section - then all schemas and tables will be available for your service principal through inheritance.
If you want to grant your service principal access to selected table then pick that table and grant select permission on the table level.

Re: Accessing Databricks data in Salesforce via zero copy

Rash_Databrick — Wed, 10 Dec 2025 03:34:25 GMT

HI Team ,

Please help me my task is to connect Databrick and salesforce data cloud with zero copy . where we need databricks data in Salesforce data cloud , also just to mention my databricks workspace + ADLS stoarge is on private end point. any help is needed , i recommend reverse proxy but looks like salesforce people dont want that.