Managing Data Listings

After you become an approved data provider, you can start adding your data listings to the Snowflake Data Marketplace.

Each data listing submitted to the Snowflake Data Marketplace must go through the Snowflake review and approval process. Data providers create a data listing and submit it for approval. If you have more than one listing in the Snowflake Data Marketplace, each listing must go through the approval process separately.

Once a listing is approved, you can publish it in the Snowflake Data Marketplace. If a listing has been rejected, you can review the feedback comments, update the listing and resubmit it for approval.

To make sure that your data listing submission goes smoothly and does not trigger a rejection, make sure that listing’s metadata meets the requirements.

In this Topic:

Creating a New Data Listing

Considerations for Creating a Listing

Note

These considerations also apply for creating a listing in a remote region.

  • Since the data is shared between different accounts, data consumers should be able to use shared data objects without using double-quoted identifiers (see Identifier Requirements). As a result, object identifiers for tables, columns, and share names must be lower case and use only alphanumeric characters.

  • As part of the verification of the submitted data set and if Snowflake is helping you to set up the share, you may need to grant access to the share to one of the Snowflake designated accounts. After your share is properly set up, this access must be revoked.

  • To ensure that your sensitive data in a shared database is not exposed to users in consumer accounts, see Using Secure Objects to Control Data Access.

  • Shares that are currently shared with a consumer account (i.e. via a direct share) can be added to a listing, as long as the same consumer account is also a consumer in the Data Exchange.

  • Only the role that created the share can attach the share to a listing.

  • A share can only be attached to one listing. If a share has already been attached to a listing, it cannot be attached to another listing, even if the listing has been deleted.

  • The data must be legally shareable (i.e. the provider must own the data or have the right to share it).

    Note

    To the extent any data in your data listing or data set is governed by any laws or contractual obligations, you must ensure that you have the legal and contractual rights to share such data. For example, you can only share protected health information (PHI) through a personalized data share and, to do so, you must: (1) have signed a business associate agreement (BAA) with Snowflake and the Consumer receiving the PHI, and; (2) ensure that the Consumer has also signed a BAA with Snowflake. Also, while you can share personal data through both a standard or personalized data share, to do so you must have the applicable legal and contractual rights if the data is not publicly available.

Considerations for Creating a Listing in a Remote Region and Replicating Data

  • When you publish a listing, you specify the regions where you wish the listing to appear. The listing is auto replicated to each region that you have selected.

  • You do not need to have an account in a region to publish a listing (personalized or standard) in that region. However, once you receive a data request from a consumer, to share data in a region, you must have an account in that region in order to replicate data. If you have more than one account, all accounts must belong to the same organization.

  • When you create an account in a remote region, the account must be added as a provider in the Snowflake Marketplace to be able to share data. To add your remote account as a provider in the Snowflake Marketplace, email a list of URLs for all of your remote accounts to exchange-concierge@snowflake.com.

  • Cross region data sharing utilizes Snowflake data replication functionality, for more information, see Sharing Data Securely Across Regions and Cloud Platforms.

  • The listing is automatically replicated, the data is not.

  • You do not need to replicate the data to each region until a consumer requests it.

  • For standard listings, you have an option to pre-associate a share with the listing in a remote region. This will allow consumers to get the share instantly without submitting a request.

  • To see a list of shares attached to a listing in a remote region, you must log in to the remote account from which you attached the share to the listing.

Creating and Publishing a Data Listing

To create a standard or personalized data listing:

  1. (Skip this step if creating a personalized listing) In the classic web interface, create a share and add one or more accounts to the share. For instructions, see Getting Started with Secure Data Sharing.

  2. In the new web interface, navigate to the Manage menu item, the Listings tab.

  3. In the Create Listing dialog box, provide the details for the listing.

  4. Submit the listing for approval. Once the listing is reviewed by Snowflake, the state changes to Approved or Denied. If the listing has been denied, update the listing based on the feedback provided in comments and resubmit for approval.

  5. When the listing is approved, click Publish to publish the listing to the selected regions. An approved listing does not get published automatically. You must publish the listing. A published listing becomes visible as a tile to all members of the Data Marketplace in the specified regions, even if those members are in a different region than the provider.

  6. (Optionally) Pre-associate a share with a published standard listing to make the share available to consumers in a remote region. To pre-associate a share with a listing:

    Note

    Before you can associate a share with a listing in a remote account, you must replicate the dataset to that account.

    1. In the new web interface, log in to a remote account as an ACCOUNTADMIN.

    2. Navigate to the Manage menu item » the My Listings tab » <listing_name> » the Data section.

    3. Click the pencil icon next to the Data section.

    4. Associate the share with the listing.

Data Listing Fields

The following table describes parameters required for creating and configuring a data listing in the Snowflake Data Marketplace.

Field Name

Description

Example

Provider Profile

Select the name of the provider profile that provides the share. You must create a provider profile before you can publish a listing.

Listing Title

Title of the data listing. The title cannot exceed 80 characters.

Historical Weather by Postcode

Subtitle

Subtitle of the data listing. The subtitle cannot exceed 80 characters. Title and subtitle should not be repetitive.

Historical Weather Data by Location

Description

Description of the shared dataset. The description must include: (a) Best use cases, (b) Scale of data, (c) Description of tables/views, (d) Whether the dataset is a sample, (e) Where to find data dictionaries.

ACME is the number one supplier of customized, pinpoint weather warnings to large enterprises, as well as a vital information source for worldwide weather forecasts, data and meteorological consulting services. This data is historical weather data for US zip codes that can be used to further enhance your existing data to provide deeper analytics.

Data Updates

Data update frequency.

Available values: Near real-time, Daily, Weekly, Monthly, Quarterly, Annually, Never (Static Data).

Link to Documentation

A link to a page on provider’s website with more detailed documentation. Documentation must be clear and reference the right schema objects present in the Snowflake share. It cannot be just standard documentation.

https://developer.acme.com

Listing Type

See, Types of Data Listings.

Available Values: Standard, Personalized

Share Name

The name of the share. For a standard listing, this is the name of the share that will publish on the Data Marketplace. The data share must be owned by the same role that is creating the listing and attaching the share.

ACME_BENCHMARKS_SHARE

Example Title

Title for a use case to help consumers understand the data. You can add more than one example using the navigation on the right.

Description

Description of the example with additional instructions, e.g. name of the schema, sample tables, fields, use cases.

Sample Query

Sample queries or image URLs to help consumers understand the data. Sample queries should highlight interesting aspects of the data. Key guidelines for sample queries: (a) Test sample queries against the database you use to create the share. You must test queries against your database and not try to create a new database from your own share. Creating a database from your own share results in an error message. (b) Use SQL comments to provide guidelines, such as which schema to use, or whether there are multiple schemas in the share.

Region Availability

Regions where your listing will be visible. You will still need to replicate the data to these regions. You can edit the list of available regions at any time. You do not need an admin approval. If you remove a region that was previously available, consumers in that region will no longer be able to see the listing.

Available values: Anywhere Snowflake Marketplace is Available, Specific Snowflake Regions.

Category

Data listings are categorized for easy discovery.

Viewing Requests for Personalized Listings

Note

At this time, no email notifications are sent to providers to notify them of data requests. You should review data requests in the web interface on a regular basis.

To view requests for personalized listings:

  1. In the new web interface, in the left menu, click the Manage link.

  2. Click the Inbound Requests tab. Use the filtering drop down list to view requests by status.

Approving Requests for Personalized Listings or Standard Listings in a Remote Region

Note

For standard listings, data is not automatically available in remote regions. The provider is responsible for replicating their data to each of these regions. For standard listings, you have an option to pre-associate a share with the listing in a remote region. This allows consumers to get the share instantly without submitting a request. You can also replicate data and attach a share to a listing after receiving a request from the first consumer in a region. Once the listing is attached to the share, all consumers in that region can access the share instantly.

To approve a request for a data listing submitted by a consumer:

  1. In the new web interface, navigate to Data » Manage » Snowflake Data Marketplace » Inbound Requests.

  2. Next to a request, click the Review button.

  3. If the consumer is in a different region, before attaching a share:

    1. Log in to an account residing in the same region as a consumer.

    2. If you do not have an account in that region, a user with the ORGADMIN role can create an account.

    Note

    • If the organization object is not enabled, contact your Snowflake account representative to create a new account or to request to join the Organization private preview which will allow you to create your own accounts. For more information, see Organizations.

    • If the organization object is enabled but you still cannot create an account in a different region, contact your Snowflake account representative to request your accounts linked for replication.

    1. When you create an account in a remote region, the account must be added as a provider in the Snowflake Marketplace to be able to share data. To add your remote account as a provider in the Snowflake Marketplace, email a list of URLs for all of your remote accounts to exchange-concierge@snowflake.com.

    2. Set up replication of data to this account from your primary account. For more information, see Sharing Data Securely Across Regions and Cloud Platforms.

      Tip

      A user with the ORGADMIN role must enable accounts for replication by executing the following command:

      -- Assume the ORGADMIN role
      use role orgadmin;
      
      -- View the list of the accounts
      show organization accounts;
      
      -- Enable replication for an account
      SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('<account1_name>',
      'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');
      
  4. To create a share, click the Create a share in the Classic Console link.

  5. If needed, in the classic web interface, create a new share and add objects to the share. For instructions, see Getting Started with Secure Data Sharing.

  6. In the new web interface, the Review Request dialog box, from the Secure Share drop-down list, select an existing share or the newly created share.

    Note

    If you do not see a share, it is either already attached to another listing, or has been previously shared with consumers.

  7. Click Save. The share is now associated with the listing and is available to the consumer.

Tip

If you receive an error when fulfilling a request for a remote region, consider the following:

  • Has the remote account been added to the Marketplace as a provider?

  • Is the remote account part of the same organization as the account you published the listing from?

  • Did you create a new share using the ACCOUNTADMIN role?

  • Have you added other consumers to the share you are trying to attach?

Viewing Fulfilled Listing Requests

Providers who fulfill standard or personalized listing requests using the new Snowflake User Interface can view records of consumers added to the share (ALTER SHARE statements) in the classic User Interface » the History tab. The Include client-generated statements checkbox must be selected. For more information, see Using the History Page to Monitor Queries.

These records are also available in the QUERY_HISTORY View.

Managing Existing Data Listings

Editing a Data Listing

When you edit a data listing:

  • Each time you edit a data listing, a new draft is created. You must submit it for approval and republish it before the changes become available to consumers.

  • Editing available regions does not require an approval, you can make the change at any time.

  • If you remove a region that was previously available, consumers in that region will no loinger have access to the shared dataset.

  • Once a listing is approved, you must publish it to make it available to consumers.

To update a data listing:

  1. Log in to the Marketplace new Web Interface as an ACCOUNTADMIN.

  2. In the left navigation bar, click Manage.

  3. Click the My Listings tab.

  4. Click the name of the listing you wish to update.

  5. In the top-right corner, click the Edit & Publish button.

Updating a Data Listing

When you update a data listing:

  • You can create a draft of a listing, and submit it for approval while the original data listing is published.

  • Editing available regions does not require an approval, you can make the change at any time.

  • If you remove a region that was previously available, consumers in that region will no loinger have access to the shared dataset.

  • Once a draft is approved, you must publish it to make it available to consumers.

  • When you publish a new version of the listing, it overwrites the previously published listing.

Unpublishing a Data Listing

When you unpublish a data listing, existing consumers can still access the data share unless you remove them from the share. New consumers cannot see it.

To unpublish a data listing:

  1. Log in to the Data Marketplace using the new Web Interface as an Account Administrator.

  2. In the left menu, click Manage,

  3. Click the name of the listing you wish to unpublish.

  4. In the top-right corner, from the drop-down list select Unpublish.

  5. Click Unpublish to unpublish the listing.

Republishing a Data Listing

When a data listing is republished, it does not require an approval unless changes have been made to the listing.

To republish a data listing:

  1. Log in to the Data Marketplace using the new Web Interface as an Account Administrator.

  2. In the left menu, click Manage.

  3. Click the name of the listing you wish to republish.

  4. In the top-right corner, from the drop-down list select Re-publish.

  5. Click Re-publish to republish the listing.

Updating a Data Share

You can update a data share using the Snowflake classic we interface. Keep in mind that each time you modify a data listing, you must notify the consumers to ensure that you do not break their processes. Examples of breaking changes include:

  • Adding/removing a column.

  • Renaming objects.

  • Removing objects.