Configuring and using a Data Exchange¶

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:

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:

  1. Entering the name for your Data Exchange.

  2. 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:

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. Navigate to the Manage Exchanges tab.

  4. Select the exchange you want to manage.

  5. Select the Members tab.

  6. Select Add Member to add a new member. To manage an existing member, select their member row.

  7. Select the role for the member, Provider or Consumer, by selecting the appropriate checkbox.

  8. Save your changes.

Manage member listings¶

To examine, review, and otherwise manage member listings:

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. Select the Manage Exchanges tab.

  4. Select the exchange you want to manage.

  5. Select the Member Listings tab.

  6. Select Any, Pending, or Reviewed to manage listings in different states.

  7. Open a listing by selecting its row.

  8. 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:

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. Select the Manage Exchanges tab.

  4. Select the exchange you want to manage.

  5. 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:

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. 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.

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. Select the Requests tab.

  4. 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.

Accessing the shared data¶

If your request for a listing in the Data Exchange is approved:

  1. Sign in to Snowsight.

  2. Select Data Products » Private Sharing.

  3. Select the Shared With You tab.

  4. Locate the listing you requested and select Get Data for the listing.

  5. Enter the name for the database to create in your account from the share.

  6. Select roles that you want to have access to the database created from the share.

  7. Accept Snowflake’s consumer terms and the provider’s terms of use. You only need to accept the listing terms when you create a database from a share for the first time.

    Note

    Accepting terms using SQL is not supported.

  8. Select Create Database.

After you create the database from share, the Get Data button is replaced with the View Database button.

See also: Usage metrics shared with providers