You are trying to create an external hive table, but keep getting a User does not have permission SELECT on any file error message.
java.lang.SecurityException: User does not have permission SELECT on any file.
Table access control (AWS | Azure | GCP) is enabled your cluster and you are not an admin.
The Databricks SQL query analyzer enforces access control policies at runtime on Databricks clusters with table access control enabled as well as all SQL warehouses.
When table access control is enabled on a cluster, the user must have specific permission to access a table in order to be able to read the table.
The only users who can bypass table access control are Databricks admins.
An admin must grant SELECT permission on files so the selected user can create a table.
Review the Data object privileges (AWS | Azure | GCP) documentation for more information.
- Start the cluster.
- Open a notebook.
- Run the following to grant SELECT permission on any file to the specified user.
%sql GRANT SELECT ON ANY FILE TO `<user@domain-name>`