Share and Manage Shared Data using Snowsight¶
You can use Snowsight to share data and manage data that has been shared with you, or that you shared with others.
You must use the ACCOUNTADMIN role, or a role with either the CREATE SHARE (as a data provider) or IMPORT SHARE (as a data consumer) privilege.
View and Manage Data Shared with You¶
Using Snowsight, you can see data that was shared with you by doing the following:
Sign into Snowsight.
Select Data » Private Sharing.
Select the Shared with You tab.
You can view the following:
Privately Shared Listings that have been shared with you. You can also see Data exchange listings that you have access to in this section.
Snowflake Marketplace listings that have been imported into a database and are ready to query. This section does not display all listings with shares that are available for you to get. Instead, you can find all Snowflake Marketplace listings available to you in the Marketplace menu. Refer to Exploring Listings.
Direct shares that have been shared with you. Depending on the share status, shares are grouped into two sections:
Direct shares that are ready to get (i.e. a database has not been created from the share).
Direct shares that have been imported into a database and are ready to query.
For data shared with you, you can do the following:
Create a database from a share.
Filter by provider or the status of data shared with you.
View and Manage Data Shared by You¶
Using Snowsight, you can see data that was shared by your account using a listing, a direct share, or as part of a data exchange.
To see data shared by your account, do the following:
Sign into Snowsight.
Select Data » Private Sharing.
Select the Shared by Your Account tab.
On this page, you can do the following:
View the shares that you have created or have privileges to access. The information provided includes the database for the share, the consumer accounts (if any) that have been added to the share, date when the share was created, and objects that have been shared.
View the shares associated with listings offered to specific consumers or to any consumer on the Snowflake Marketplace.
View shares that are shared with private data exchanges.
To view and manage listings offered to specific consumers or publicly on the Snowflake Marketplace, use Provider Studio instead. Refer to Managing Listings as a Provider.
You can use the following filters to selectively display shared data:
Filter by type with the All Types drop-down list. Choose to display only secure shares or listings shared with a data exchange. Some secure shares are shares associated with listings.
Filter by consumer account or data exchange with the Shared With drop-down list. Select one or more specific consumers or data exchanges to see all shares or listings associated with your selection or selections.
Click a share to manage the share and revoke access to the share for individual consumer accounts or add a description. To manage secure shares that are offered as listings, use Provider Studio. Refer to Managing Listings as a Provider.
Share Data in Snowsight¶
To share data in Snowsight, use the Share drop-down list and select from the list of available options.
Sign into Snowsight.
Select Data » Private Sharing.
Select the Share drop-down list.
There are several ways to share data in Snowflake:
Provide a listing to specific consumers or publicly on the Snowflake Marketplace using Provider Studio. Refer to Creating and Publishing a Listing.
Share data with consumer accounts in your region using a direct share
Publish a listing in a data exchange
Data Requests¶
Using Snowsight, you can see inbound and outbound requests from a data exchange in the Requests tab.
Sign into Snowsight.
Select Data » Private Sharing.
Select the Requests tab.
Note
To see requests from listings on the Snowflake Marketplace, such as those for personalized listings or free listings in another region, use Provider Studio. Refer to Managing Listings as a Provider.
Inbound Requests¶
Inbound requests are requests from data consumers to access your data. You can sort the requests by status and review (approve or deny) them. For more information, refer to Viewing Requests for Personalized Listings.
Outbound Requests¶
Outbound requests are requests that you have submitted for data listings from other providers in a data exchange. You can sort the requests by status. If a request has been denied, a comment is provided next to the request. You can make the necessary adjustments and resubmit your request.
Manage Exchanges¶
If you have the Data Exchange Admin role, or Provider Profile Level Privileges, you can create and manage provider profiles for a data exchange in the Manage Exchanges tab.
Sign into Snowsight.
Select Data » Private Sharing.
Select the Manage Exchanges tab.
Note
If your organization does not have a data exchange, the Manage Exchanges tab is not displayed.
You can perform the following tasks for a provider profile in a data exchange:
Create a new profile
Update a profile
Update contact email
Manage profile editors
Delete a profile
For more information, refer to Becoming a Data Provider in a Data Exchange.