Configure and use a Data Exchange¶
Use the information provided here to perform Data Exchange administrative and user tasks.
After you sign in to your Data Exchange as an Data Exchange Admin, you can perform the following tasks:
Set up your Data Exchange.
Create, update, or delete provider profiles. New profiles must be approved by a data exchange administrator. See Manage provider profiles.
Update contact email.
Manage profile editors.
Manage membership in the data exchange.
Assign roles to members of the data exchange. See Grant privileges to other roles.
Note
When logging in to a data exchange for administrative purposes such as joining the exchange, configuring the exchange, or configuring data listings, the member must have the ACCOUNTADMIN role.
Set up your Data Exchange¶
Note
To create a Data Exchange, contact your Snowflake representative or Snowflake Support.
Invite members and assign roles¶
After the Data Exchange is 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.
Sign in to Snowsight.
Select Data Products » 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¶
Sign in to Snowsight.
Select Data Products » 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¶
Sign in to Snowsight.
Select Data Products » 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.
Access consumer 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.
Sign in to Snowsight.
Select Data Products » Private Sharing.
Select the Shared With You tab.
Browse 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.
View listing requests¶
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.
Sign in to Snowsight.
Select Data Products » Private Sharing.
Select the Requests tab.
Select Inbound.
When 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.