Data Providers: Creating and Managing Listings

In this Topic:

How Do I Create a Listing?

Before you create a listing, your organization needs to complete some technical steps:

When you’re ready to create the listing, use Snowflake’s Provider Studio. Provider Studio is the home of your listings and Marketplace information. Using Provider Studio, you’ll:

  • Create the listing. When creating the listing, you’ll specify where the data is available, provide information about the data, and set a price, if any.

  • Submit the listing for review. Snowflake reviews each submission to the Marketplace and works with your organization if any additional effort is needed to prepare the listing.

  • Publish the listing. After your listing is accepted, your organization needs to take the last step of publishing the listing. When the listing is published, consumers can start accessing your data.

Requirements to Create a Listing

Before you start creating and publishing your listings, make sure the following requirements are met:

  • Create a data share for your listing. You can create a data share using SQL, or using the web interface.

  • The same Snowflake role should own the listing and the share. If the same role can’t own both the share and the listing, then assign the share owner the MODIFY LISTING privilege. The share owner must publish the listing.

Managing Listings

This page provides instructions for creating and configuring paid listings.

For general instructions for creating and managing data listings, see Managing Data Listings.

Creating Paid Listings

Note

Only account administrators (i.e. users with the ACCOUNTADMIN role) or a role with the global CREATE LISTING privilege can complete the steps in this section.

To create a paid data listing:

  1. Log in to Snowsight, the Snowflake web interface.

  2. At the top of the left navigation bar, click the user menu and switch to the ACCOUNTADMIN role, or a role with the global CREATE DATA EXCHANGE LISTING privilege.

  3. In the left navigation bar, click Data » Provider Studio » Listings.

  4. Click the New Listing button. The New Listing dialog opens.

  5. Enter a display title for your listing.

  6. From the list of consumer access options, choose Purchase with a free sample.

  7. Click the Next button.

  8. Finish creating the listing. The listing details page opens.

    If you plan to configure your data listing now, continue to Step 6 in Configuring Paid Listings (in this topic). Otherwise, you are done.

    Note

    You can create draft listings before accepting the Snowflake Marketplace Provider Terms of Service. If you try to submit your listing and you haven’t yet accepted the terms, you will be prompted to review and accept the terms. You must also confirm a valid payout method with Stripe.

Configuring Paid Listings

Note

Only account administrators (i.e. users with the ACCOUNTADMIN role) or the listing owner (i.e. the role that has the OWNERSHIP privilege on the listing) can complete the steps in this section.

To add details to a paid listing such as the share, pricing plan, and features of the trial data:

  1. Log in to Snowsight.

  2. At the top of the left navigation bar, click the user menu and switch to the ACCOUNTADMIN role, or a role with ownership of the listing.

  3. In the left navigation bar, click Data » Provider Studio » Listings.

  4. Click on a listing. The listing details page opens.

  5. In the Data Product area of the page, click the Add button beside each of the following fields, and configure the requested information.

    Field

    Description

    Data

    Attach the share you created for the listing. The share must include the secure views you created in Preparing Shares With Paid and Trial Data.

    For more information about shares, see Data Providers: Sharing Data.

    Pricing

    Choose the pricing plan for the listing. The options are described in Pricing Model.

    Note that prices are currently in US dollars only.

    Free Sample Features

    Describe any free data samples in the listing. Note that this trial data is available to consumers indefinitely in any regions where the data listing is published.

    Paid Data Features

    Describe the paid data samples in the listing.

  6. Click the Save button.

    Note

    You can create draft listings before accepting the Snowflake Marketplace Provider Terms of Service. If you try to submit your listing and you haven’t yet accepted the terms, you will be prompted to review and accept the terms. You must also confirm a valid payout method with Stripe.

Publishing Paid Listings

The first time a paid listing is approved, you must manually publish the 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.

To publish a paid listing manually:

  1. Log in to Snowsight.

  2. At the top of the left navigation bar, click the user menu and switch to the ACCOUNTADMIN role, or a role with ownership of the listing.

  3. In the left navigation bar, click Data » Provider Studio » Listings.

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

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

Types of Queries That Incur Charges for Paid Access

Snowflake invoices consumers for queries that access paid data in a share, regardless of whether the query returns results. For example, a query could scan a set of paid data but filter out every row. Examples of queries that produce charges for paid access include SELECT and DML statements that access paid data. DDL statements do not produce charges unless they access paid data (e.g. using CREATE TABLE AS SELECT).

Changing Existing Listings to Paid Listings

Currently, providers cannot convert existing listings to paid listings. If you have already published a listing without a pricing plan, no pricing plan can be added later. To offer a paid listing, you must attach a pricing plan to the listing before it is first published. However, you can update some pricing details in an attached plan after the listing is published, subject to approval.

You can unpublish an existing listing if you are replacing it with a paid listing.

Similarly, a paid listing cannot be converted to a free listing. If a listing has been published with a pricing plan, then the pricing plan cannot be set to null or a “zero” pricing plan afterwards. Note that a zero pricing plan is not allowed.

Changing the Price of a Published Listing

Changing the price of a published data listing requires that you resubmit the listing for approval. This process is a technical part of republishing the listing; Snowflake doesn’t provide feedback about the price change. After the listing is approved and published, Snowflake automatically notifies current consumers of the listing about the price change. The price change applies immediately to any new consumers that purchase your data. Existing consumers of your listing are charged the new price after the end of their next billing cycle.

Region Support

Currently, only regions in the United States support paid listings.

SQL Functions

SYSTEM$IS_LISTING_PURCHASED

Determines whether the current account is participating in the paid data access for the current listing. Call this SQL function in a secure view to filter access to paid data. The function infers the listing associated with the database that contains the view and determines if the account that executes the query has agreed to purchase paid data in the listing.

Syntax

SYSTEM$IS_LISTING_PURCHASED()

Arguments

None.

Examples

Create a secure view that selects all columns in a table. The view returns rows only when queried within a consumer account that has agreed to purchase paid data:

CREATE SECURE VIEW paid_v
  AS
  SELECT
    *
  FROM
    paid_t
  WHERE
    SYSTEM$IS_LISTING_PURCHASED();