Problem
When logging in as a Delta Sharing data recipient, you expect to see the share tables under the Shared with me section. Instead you see the following message.
Looking for data shared with you? Contact your account administrator to grant you the USE_PROVIDER privilege to view all inbound shares.
Cause
To view tables from a Delta Sharing data provider, a metastore admin must grant you the USE PROVIDER
privilege, or you must be a metastore admin.
Solution
Have the metastore admin use SQL in a notebook or the Databricks UI to grant the USE_PROVIDER
privilege.
Use SQL in a notebook
Run the following SQL command in a notebook.
%sql
GRANT USE_PROVIDER ON METASTORE TO `<user-or-group-name>`
Use the Databricks UI
In your Recipient Databricks workspace:
- Click the Catalog tab.
- Click the gear icon and select Metastore.
- Select the Permissions tab.
- Click the Grant button. Issue the
USE_PROVIDER
privilege to the desired user or group.
For more information, review the Manage Delta Sharing providers (for data recipients) (AWS | Azure | GCP) documentation.