Configuring and using a Data Exchange¶
Data exchange is not enabled for all accounts
To inquire about enabling a data exchange, please contact Snowflake Support.
This topic provides instructions for performing all the administrative and user tasks associated with using your Data Exchange.
Note
When logging in to a data exchange for administrative purposes (e.g. joining the exchange, configuring the exchange, configuring data listings), the member must have the ACCOUNTADMIN role.
Data Exchange admin¶
After logging in to your Data Exchange as an Exchange Admin, you can configure your Data Exchange.
You can perform the following tasks in a data exchange:
Set up your Data Exchange.
Create, update, or delete provider profiles. New profiles must be approved by a data exchange administrator. See Becoming a data provider in a Data Exchange.
Update contact email.
Manage profile editors.
Manage membership in the data exchange.
Assign roles to members of the data exchange. See Granting privileges to other roles.
Setting up your Data Exchange¶
Note
Currently, Snowflake creates the Data Exchange. If you want to create a Data Exchange, contact your Snowflake representative or Snowflake Support.
Setting up your Data Exchange involves:
Entering the name for your Data Exchange.
Entering a description for your Data Exchange.
Inviting members and assigning roles¶
After the Data Exchange has been set up, you can start inviting accounts as members and designating them as data providers, data consumers, or both. You invite members using their Snowflake account name or account URL.
To add, review, and otherwise manage members:
Sign in to Snowsight.
Select Data » Private Sharing.
Navigate to the Manage Exchanges tab.
Select the exchange you want to manage.
Select the Members tab.
Select Add Member to add a new member. To manage an existing member, select their member row.
Select the role for the member, Provider or Consumer, by selecting the appropriate checkbox.
Save your changes.
Manage member listings¶
To examine, review, and otherwise manage member listings:
Sign in to Snowsight.
Select Data » Private Sharing.
Select the Manage Exchanges tab.
Select the exchange you want to manage.
Select the Member Listings tab.
Select Any, Pending, or Reviewed to manage listings in different states.
Open a listing by selecting its row.
View the listing, or select Review to review the listing and approve or deny it for your Data Exchange.
Manage member profiles¶
To examine, review, and otherwise manage member profiles:
Sign in to Snowsight.
Select Data » Private Sharing.
Select the Manage Exchanges tab.
Select the exchange you want to manage.
Select the Member Profiles tab. On the tab, you can do the following:
Select Pending or Reviewed to view profiles in different states.
You can view already reviewed profiles, or select Review to approve or deny a member profile.
Data providers¶
These topics provide instructions for becoming a data provider in the Data Exchange and managing data listings.
Data consumers¶
How do I access the Data Exchange to browse listings?¶
All users can browse listings in the Data Exchange, but only users with the ACCOUNTADMIN role or the IMPORT SHARE privilege can get or request data.
If you do not have sufficient privileges, you can do one of the following:
Request your ACCOUNTADMIN to grant you the IMPORT SHARE privilege.
Request your ACCOUNTADMIN to get data, and grant you IMPORTED PRIVILEGES on the database created from the share. For more information, see Granting privileges on a shared database.
To access the listings available to you as a consumer of the Data Exchange:
Sign in to Snowsight.
Select Data » Private Sharing.
Select the Shared With You tab.
Browsing data listings¶
After you sign in to a Data Exchange, review the Listings section of the Shared With You tab to view available listings.
In a Data Exchange, the following types of listings are available to you:
Free listings, which you can access by selecting Get to create a database out of the shared data inside of your Snowflake account.
Personalized listings, which you can access by selecting Request to request access to the data. An email notification is sent to the data provider with your request.
Viewing listing requests¶
To view requests that you made for data in a Data Exchange, use the Requests tab.
Sign in to Snowsight.
Select Data » Private Sharing.
Select the Requests tab.
Select Inbound.
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. See Managing Listing Requests as a Provider.
If a request is denied, a comment is provided next to the request, explaining the reason for denial. In such cases, you can make the necessary adjustments and resubmit your request.