Error: Insufficient Privileges: User Does Not Have Permission CREATE on CATALOG

Issue

Databricks destination connections fail. The following error appears:

Error running query: [INSUFFICIENT_PERMISSIONS] org.apache.spark.SparkSecurityException: [INSUFFICIENT_PERMISSIONS] Insufficient privileges: User does not have permission CREATE on CATALOG.

Environment

Destination: Databricks

Resolution

To resolve this issue, do the following:

1. Log into Databricks with a user account that has administrative privileges.
2. Run the following command to grant the necessary CREATE privilege to the affected user or role:

   GRANT CREATE ON CATALOG <catalog_name> TO <user_or_role>;
   

Cause

This error occurs when the user executing the query doesn't have the CREATE privilege on the specified catalog.