Delta Share not visible in "Shared with Me" section

Have the metastore admin use SQL in a notebook or the Databricks UI to grant the USE_PROVIDER privilege.

Written by ismael.khalique

Last published at: May 23rd, 2025

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:

  1. Click the Catalog tab. 
  2. Click the gear icon and select Metastore.
  3. Select the Permissions tab.
  4. 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)  (AWSAzureGCP) documentation.