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

drii_cavalcanti — Thu, 31 Aug 2023 22:54:06 GMT

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!

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

Tharun-Kumar — Fri, 01 Sep 2023 04:46:22 GMT

@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.

topic Re: Privilege Issue When Running Delta Table SaveAsTable Command in Databricks Runtime 10.4 in Data Governance

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

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