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