Privilege Issue When Running Delta Table SaveAsTable Command in Databricks Runtime 10.4

drii_cavalcanti
New Contributor III

‎08-31-2023 03:50 PM - edited ‎08-31-2023 03:54 PM

I am attempting to execute the following command from a notebook on a runtime 10.4 cluster, but I'm encountering an error: "current user does not have privilege USAGE on Catalog".

To provide some context, I am using DBR 10.4 specifically because I need to retrieve sensitive data (which cannot be downloaded) from a SQL Server that requires a driver called 'net.sourceforge.jtds.jdbc.Driver' to establish a connection.

The code I'm attempting to run is:

df.write.format("delta").mode("append").saveAsTable(<catalog>.<schema>.<table>)

Is there any parameter that I am not aware of to suppress this permission issue? Any insights or guidance on resolving this privilege issue would be greatly appreciated.

Thank you!

Labels:
0 Kudos

Tharun-Kumar
Databricks Employee
Databricks Employee

‎08-31-2023 09:46 PM

@drii_cavalcanti 

From the error, we could see that you do not have permission to use the catalog. I suppose you are using Unity Catalog. You should 3 levels of permissions to access the Catalog, schema and then tables.

You can refer to this document - https://docs.databricks.com/en/data-governance/unity-catalog/manage-privileges/privileges.html, which explains how to provide access to the catalog, schema and table.