Managing Data Listings

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

Each data listing submitted to the Snowflake 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 Marketplace, each listing must go through the approval process separately.

When a listing is approved, it can be published in the Snowflake Marketplace. If a listing is 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.

Considerations for Creating a Data Listing

Provider Studio for Snowflake Marketplace

Provider Studio lets data providers perform the following actions:

  • Create and manage listings for the marketplace.

  • Submit listings to Snowflake for review.

  • View consumer requests for your data.

  • Read announcements about the Snowflake Marketplace.

For general information about Provider Studio, see Provider Studio.

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 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 uses Snowflake’s 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 you used to attach the share to the listing.

Creating and Publishing a Data Listing

Creating a New Data Listing

To create a standard or personalized data listing:

  1. In the left navigation bar of Snowsight, the Snowflake web interface, click Data » Provider Studio » 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 types of listings, 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:

    • You are not the share owner.

    • Any of the provided sample SQL queries fail validation. To be valid, the sample query must:

      • Return at least one row.

      • Reference objects that are explicitly in the share.

      • Qualify objects by SCHEMA.OBJECT. Do not include the database name. For example, EXAMPLE_SCHEMA.TABLE_A.

      For more information, see Data Listing Fields.

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

    Next, learn about Publishing a Data Listing.

Data Listing Fields

The following tables describe the parameters required for creating and configuring a data listing in the Snowflake Marketplace.

Basic information

The following table describes the available fields in the Basic Information section.

Field Name

Description

Example

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.

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

The following table describes the available fields in the Details section.

Field Name

Description

Example

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) Introductory 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 Product

The Data Product section contains groups of settings. The following table describes the available fields in the Data Product section, organized by group.

Group Name

Field Name

Description

Data

Database Objects or Secure Share

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

Attributes, Free Sample Attributes, Paid Data Attributes

Update Frequency

How often your data product is updated to Snowflake

Geographic Coverage

What geographic area that the data covers.

Geographic Granularity

The geographic granularity of the data. For example, postal code.

Time Range

The range of time that the data covers.

Timestamp Granularity

The time interval between data points. For example, daily.

Additional attributes (optional)

Any additional information that you want to communicate to your users. For example, include a description of the scope and scale of your data, and why someone will find your data useful.

Pricing

Pricing

How a consumer pays for your data. This field is only available if you are creating or editing a paid listing.

Business Needs

The following table describes the available fields in the Business Needs section.

Field Name

Description

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 Queries

The following table describes the available fields in the Sample SQL Queries section.

Field Name

Description

Example

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

Code for your sample SQL queries. Snowflake automatically validates your sample queries. To be valid, a sample query must return at least one row. If a query fails to validate, you can only save the listing. The listing cannot be published until all queries are successfully validated.

Region Availability

The following table describes the available fields in the Region Availability section.

Field Name

Description

All available regions or Specific Regions

Regions where your listing will be visible. Availability only applies to the visiblity of your listing, and doesn’t automatically replicate your data. You must replicate the data to the regions where you want to make your data available. You can edit the Region Availability 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.

Publishing a Data Listing

The details of publishing differ slightly based on the type of listing (personalized or standard) you create.

Publishing Personalized Listings

By default, Snowflake automatically publishes your personalized listings after they are submitted and approved. No further steps are required. To stop your listing from being automatically published, see Deactivate Automatic Publishing.

Publishing Standard Listings

The first time a standard listing is approved, you must manually publish the listing. See Manually Publishing a Data Listing.

Snowflake automatically publishes subsequent changes to the listing. Changes that require approval by Snowflake are automatically published after the listing is approved. To stop your listing from being automatically published, see Deactivate Automatic Publishing.

Manually Publishing a Data Listing

To publish a data listing manually:

  1. In the left navigation bar of Snowsight, click Data » Provider Studio.

  2. At the top of the page, click the Listings tab.

  3. Click the approved listing that you want to publish.

  4. In the upper-right corner of the listing, click Publish Listing.

Deactivate Automatic Publishing

To deactivate automatic publishing for a listing:

  1. In the left navigation bar of Snowsight, click Data » Provider Studio.

  2. At the top of the page, click the Listings tab.

  3. Click a listing that is automatically published.

  4. At the top of the listing, click the Settings tab.

  5. In the Publishing row of the Listing Settings, click the Edit Publishing button.

  6. In the Publish Setting box, select Manual.

  7. Click Save.

    The listing is no longer automatically published. Now, when you make changes to your listing, you must manually publish the listing. See Manually Publishing a Data Listing.

Managing Existing Data Listings

Viewing Requests for Personalized Listings

To view requests for personalized listings:

  1. In the left navigation bar of Snowsight, click Data » Provider Studio.

  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 left navigation bar of Snowsight, click Data » Provider Studio.

  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.

  • When a new version of a listing is published, the previous version is replaced and cannot be recovered.

To edit a data listing:

  1. In the left navigation bar of Snowsight, click Data » Provider Studio.

  2. Click the Listings tab.

  3. 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 of Snowsight, click Data » Provider Studio.

  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 of Snowsight, click Data » Provider Studio.

  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

Deleting a Data Listing

When you delete a data listing, you permanently remove the listing from the Marketplace. A deleted data listing cannot be recovered or republished to the Marketplace. Only listings that are unpublished can be deleted.

If there are consumers using your listing, Snowflake starts the process of retiring your listing:

  • The consumers are immediately notified by email.

  • The consumers retain their current access to your data until the last day of the next month after you delete the listing. For example, if you deleted a listing on March 3, the consumers would retain access until April 30.

If there are no consumers using your listing, the listing is immediately deleted.

If your data was replicated to other regions using auto-fulfillment (currently available in Private Preview), it is removed when the listing is deleted.

To delete a data listing:

  1. In the left navigation bar of Snowsight, click Data » Provider Studio.

  2. Click the Listings tab.

  3. Click the name of the listing you want to delete.

  4. If the listing is active, in the top-right corner, click Live » Unpublish.

  5. In the top-right corner, click Delete.

  6. If your listing has consumers, review the Initiate Listing & Consumer Access Removal summary, and then click Initiate Removal.

  7. To confirm that you want to remove the listing, click Proceed. This process cannot be reversed.

  8. Click Done.

Until the listing is deleted, you can return to the listing to check the status of the process.