cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

DLT cluster : can be manipulated?

kiko_roy
New Contributor III

Hi All 

I am using DLT pipeline to pull data from a ADLS gen2 which is mounted. The cluster that is getting fired has access mode is set to shared. I want to change it to single user. But the cluster being attached to DLT , I am not ablr to update and save.

is it non editable at all? I am getting error :[INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have permission SELECT on any file.

how can I handle? with the same User I tried reading the file from normal notebook with All purpose cluster which has access mode: No isolation shared

1 ACCEPTED SOLUTION

Accepted Solutions

AlliaKhosla
New Contributor III
New Contributor III

Hi @kiko_roy 

Greetings!

You can't use a single-user cluster to query tables from a Unity Catalog-enabled Delta Live Tables pipeline, including streaming tables and materialized views in Databricks SQL. To access these tables, you need to use a shared cluster running Databricks Runtime 13.1 or newer.

Check Below link :

https://docs.databricks.com/en/compute/access-mode-limitations.html#fine-grained-access-control-limi...

View solution in original post

2 REPLIES 2

AlliaKhosla
New Contributor III
New Contributor III

Hi @kiko_roy 

Greetings!

You can't use a single-user cluster to query tables from a Unity Catalog-enabled Delta Live Tables pipeline, including streaming tables and materialized views in Databricks SQL. To access these tables, you need to use a shared cluster running Databricks Runtime 13.1 or newer.

Check Below link :

https://docs.databricks.com/en/compute/access-mode-limitations.html#fine-grained-access-control-limi...

kiko_roy
New Contributor III

thanks @AlliaKhosla for the clarification

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.