Accessing Databricks data in Salesforce via zero copy

[ManojkMohan]

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

[bianca_unifeye]

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

[szymon_dybczak]

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?

[ManojkMohan]

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

[szymon_dybczak · Accepted solution]

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.

[szymon_dybczak]

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.