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.

If you edit an approved listing, you must resubmit it for approval. The exception is the Region Visibility section which can be edited at any time without additional 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:

Permissions Required for Working with Listings and Shares

Task

Required Permissions

Modify listing details/metadata

To perform this task, the role must have the OWNERSHIP or MODIFY privileges on the listing.

View a listing

To perform this task, the role must have the OWNERSHIP, MODIFY, or USAGE privileges on the listing.

Attach a share to a listing

to perform the task, the role must have: . - The OWNERSHIP of the share, and . - The OWNERSHIP or MODIFY privileges on the listing.

If the role does not have the required combination of permissions, performing these tasks on the listing will fail.

For more information about the roles, see Granting Provider Privileges to Other Roles in the Snowflake Marketplace or a Data Exchange.

Consideratons for Creating a Data Listing

General Considerations for Creating a Data 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 upper case and use only alphanumeric characters.

  • 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. Consumers must accept the listing terms in the Snowflake Data Marketplace web interface before they can create a database from the share.

  • Only the share owner can attach a share to a listing. For more information about data sharing privileges, see Granting Privileges to Other Roles.

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

  • Before a new or modified standard listing can be submitted for approval or published, all sample queries are auto-validated to ensure that referenced objects are added to the share and the queries can be run successfully.

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

  • The listing and data share must be in compliance with the Snowflake Provider Policies.

Considerations for Creating a Data Listing in a Remote Region

  • When you publish a listing, consumers will see your listing in all selected regions.

  • While listings are automatically replicated, the data is not.

  • For standard listings, you must replicate data to each of the selected regions before publishing the listing.

  • For personalized listings, you can replicate data upon consumer’s request.

  • Make sure to allocate time to set up replication and understand costs involved.

  • 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 publish a listing in a remote region, you can either allow all accounts in your organization to fulfill listing requests or explicitly add individual accounts as providers. Only the listing owner can specify who can fulfill listing requests.

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

  • 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 a New Data Listing

Creating and Publishing a Data Listing

To create a standard or personalized data listing:

  1. In the new Snowflake web interface, navigate to Data » Manage » Snowflake Data Marketplace » My Listings.

  2. Click the New Listing button.

  3. In the New Listing dialog box, enter the listing title as it appears to the consumers and select the listing type. For more information about listing type, see Types of Data Listings.

  4. Complete each of the sections for the new listing. You can save the draft at any time to finish it later. For a description of each section and related fields, see Data Listing Fields.

    For a standard listing, to associate a share with the listing, when editing the Data section:

    Note

    Until a listing is published, it can only be associated with a share in the local/primary account. After the listing is published, it can be associated with a share in additional regions that you have selected.

    1. Click Select Data.

    2. If a secure share exists, navigate to the share and select it. If a share does not exist, navigate to the desired database and select the database objects you wish to add to the share.

      Note

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

    3. Click Done.

    4. (Optional) You can change the default name for the secure share.

    5. Click Save.

  5. Once you complete all of the sections, the Submit for Approval button is activated, and you can submit the listing for approval.

    The Submit for Approval button is not activated if:

    • Any of the provided sample SQL queries fail validation. For more information, see Data Listing Fields.

    • You are not the share owner.

  6. 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 it for approval.

    Snowflake Data Marketplace providers are notified when their listing is approved or denied. An email notification is sent to both Business Contact and Technical Contact email addresses in the provider profile associated with the listing.

    For more information, see Provider Profile Fields.

  7. When the listing is approved, navigate to Data » Manage » Snowflake Data Marketplace » My Listings.

  8. Select the approved listing.

  9. Click Publish Listing to publish it to the selected regions. An approved listing does not get published automatically.

Data Listing Fields

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

Section

Field Name

Description

Example

Basic Information

Listing Type

See, Types of Data Listings. Once you publish a listing, the listing type and secure share cannot be changed.

Available Values: Standard / Personalized

Profile

Name of the provider profile that owns the share. You must create a provider profile before you can publish a listing.

Title

The title of the dataset. The listing title cannot exceed 110 characters, but it is recommended that the title is between 40-60 characters. All major words should be capitalized (i.e. follow the Title Case format). . The title appears below your company name on the listing tile, and it must be unique (i.e. different from any other listings you may have). . If you decide to use a Standard listing to showcase a subset of your data, and a Personalized listing to allow consumers to request the full dataset, make sure to distinguish the two listings with different but related titles. For example, <title-demo> for the Standard listing and <title> for the Personalized listing. . Standard listings used to showcase other personalized listings should use a -Demo or - Sample suffix. . Standard listings available for a limited time should use a - Trial suffix.

Historical Weather by Postcode.

Subtitle

Subtitle of the data listing. The subtitle cannot exceed 110 characters and only the first word of the subtitle should be capitalized. Title and subtitle should not be redundant.

Historical weather data by location.

Data Update Frequency

How often the data is updated. Select the desired frequency from the drop-down list of available values.

Category

Data listings are categorized for easy discovery. Select the desired category from the drop-down list of available values.

Terms of Service

A link to provider’s Terms of Service hosted on the provider’s website. Consumers accept the terms before they can access the data. Terms of Service are required for standard listings, and are optional for personalized listings.

https://www.acme.com/en/legal

Details

Description

Description of the shared dataset. The description should be between 250 and 6000 characters, with line breaks between paragraphs. Use dashes in lieu of bullet points. The description must include: . (a) Intro paragraph with scale of data . (b) Description of included tables/views . (c) Key data fields . For data enrichment and services listings, the description must include the expected workflow for consumers to access your services or secure functions. The description can optionally include sources or additional information not covered in other input fields.

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. . Samples/tables included: . - Daily historical weather data from 2016-Present . - 15-day Daily Forecast weather data . - Daily 15-year climatology data (weather statistics, i.e. avg, std, freq, etc.) . Fields included: . - Date . - Zip Code . - Country . - Min, Max, Avg weather statistics (temperature, precipitation, wind, humidity, etc.)

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 share. The link must be accessible, and not locked behind a login screen.

https://developer.acme.com

Data

Database Objects or Secure Share

Data you wish to share. This section is only available for standard data listings.

Business Needs

Business Need

Data listings are grouped by business needs for easy discovery. . - You can select up to six business needs for your listing. If you do not see a relevant business need in the drop-down list, you can create a custom one. . - Consumers can easily discover listings based on business needs available in the drop-down list. However, custom business needs you add are not included, and are only visible in your listing details. . - You can edit the list of business needs at any time without resubmitting the listing for administrator’s approval.

Description

Description of how your data or data service addresses the business need.

Sample SQL Query

Title

Descriptive title for the query to help consumers understand the data. You can add more than one example.

Determine if an outdoor event will be impacted by rain.

Description (Optional)

Description of the example with additional instructions, e.g. name of the schema, sample tables, fields, use cases. Use <schema>.<table> format when referencing tables and views in your SQL, and do not include the database name in the query.

If you are hosting an outdoor event in 7 days, utilize our forecast data to determine if the event may be impacted by rain.

SQL Query

Test sample queries against the database you use to create the share. Snowflake auto-validates the queries to ensure that all referenced objects are added to the share and the queries run successfully. If the validation fails, an error message with a reason is displayed. You can see an exclamation sign next to each query that failed.

Region Availability

All available regions or Specific Regions

Regions where your listing will be visible. You will need to replicate the data to these regions. You can edit the list of available regions at any time without resubmitting the listing for administrator’s approval. If you remove a region that was previously available, consumers in that region will no longer be able to see the listing.

Managing Existing Data Listings

Viewing Requests for Personalized Listings

To view requests for personalized listings:

  1. In the new web interface, in the left menu, navigate to Data » Manage » Snowflake Data Marketplace.

  2. Click the Consumer Requests tab.

Approving Consumer Data Requests

Note

If the consumer is in a different region, before attaching a share, you must set up replication of data to the account in the remote region. For more information, see Sharing Data Securely Across Regions and Cloud Platforms.

  • For personalized 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.

  • You can specify whether a listing can be fulfilled by selected provider account(s), or by any account in the organization.

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

  1. In the new web interface, in the left menu, navigate to Data » Manage » Snowflake Data Marketplace.

  2. Click the Consumer Requests tab.

  3. Click the listing name for a request in pending status.

  4. In the Associate Secure Share section, select an account where you wish to create the share.

  5. Select the role that owns the share and the shared database objects, or has the necessary privileges on the database objects to be able to add them to a share.

  6. Click Select Data.

  7. If a secure share exists, navigate to the share, and select it. If a share does not exist, navigate to the desired database, and select the database objects you wish to add to the share.

    Note

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

  8. Click Done.

  9. (Optional) Change the default name for the secure share.

  10. Click Fullfill Request.

    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.

Editing a Published Data Listing

When you edit a published data listing:

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

  • Editing available regions, and business needs fields do not require an approval, you can make changes at any time.

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

  • Once a listing 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.

To edit a data listing:

  1. Log in to the Marketplace new web interface as an ACCOUNTADMIN.

  2. In the left navigation bar, click Data » Manage » Snowflake Data Marketplace.

  3. Click the Listings tab.

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

  • To add or remove regions where the listing is available, click Edit in the Region Availability section. You can skip the rest of the steps as no administrator approval is required.

  • To change other fields, such as the listing description, click Edit in the applicable section and select Continue when prompted. This generates a new draft that is not visible to consumers until submitted, approved, and published.

  • If you have existing changes in progress, select the New Draft toggle next to the listing title to continue working on an existing draft. You can discard this draft by selecting the Delete button at the top right of the page.

  1. Click Submit for Approval when you are ready to submit your new draft for review.

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 the removed listing.

To unpublish a data listing:

  1. In the left navigation bar, click Data » Manage » Snowflake Data Marketplace.

  2. Click the Listings tab.

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

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

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. In the left navigation bar, click Data » Manage » Snowflake Data Marketplace.

  2. Click the Listings tab.

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

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

Updating a Data Share

You can update a data share using the Snowflake classic web 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