Introduction to Listings

This topic provides a general introduction to listings and describes how you can use them to share your data products with other Snowflake users.

In this Topic:

What is a Listing?

Listings are based on the Secure Data Sharing feature of Snowflake that allows you to share data in your account with other Snowflake accounts. A listing provides you with additional capabilities, including the following:

  • Discoverability: You can use the Listing Discovery Controls to specify who can view the share and under what conditions.

  • Monetization: You can bill consumers for access to the share.

Listings are based on the provider / consumer model used by Secure Data Sharing. They provide a mechanism where providers can share their data product with consumers using the Snowsight UI. A provider publishes a listing to a specific audience, and consumers within that audience can use Snowsight to mount the share associated with the listing in their account.

Listing Discovery Controls

Listing Discovery Controls enables you to control the discoverability of your listings. Using this capability, you can specify if your listing is discoverable in the Snowflake Marketplace or only available to specific users. You can use Listing Discovery Controls to create private listings instead of a listing that is discoverable in the Snowflake Marketplace.

You can specify that your listing falls into one of the following categories:

  • Marketplace listings: A listing that is available in the Snowflake Marketplace. Any Snowflake consumer can search for and view your listing. Any Snowflake consumer with an account in the region(s) in which you choose to make your data product available may get or purchase your listing.

  • Private listings: A listing that can only be viewed and accessed by the Snowflake accounts you specify.

Monetization

Monetization enables you to specify whether consumers must pay to use your listing or if they can access it free of charge. Monetization can be applied to either listings published to the Snowflake Marketplace or private listings.

  • Free: A listing that is freely available to consumers. Free private listings can also be paid for off-platform.

  • Paid: A listing that consumers must pay to access and use. See Snowflake Marketplace Monetization for more information.

Privileges Required for Working with Listings and Shares

To work with listings and shares, you need to use a role with the following privileges:

Task

Required Permissions

Modify listing details/metadata

OWNERSHIP or MODIFY privileges on the listing.

View a listing

OWNERSHIP, MODIFY, or USAGE privileges on the listing.

Attach a share to a listing

OWNERSHIP of the share or OWNERSHIP or MODIFY privileges on the listing.

For more information about data sharing privileges, see Granting Privileges to Other Roles.

General Considerations for Working with Listings

When creating and managing listings, consider the following:

  • The listing and shares must comply with the Snowflake Provider Policies and Provider Terms of Service.

  • Object identifiers for tables, columns, and share names must be upper case and use only alphanumeric characters to allow data consumers to use shared data objects without using double-quoted identifiers. See Identifier Requirements for more information.

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

  • Before a new or modified free 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.

When working with existing shares:

  • Shares that are currently shared with a consumer account (i.e. via a direct share) can be added 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.

Note

To the extent any data in your listing 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 private listing 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 information via listing, to do so, you must be legally authorized to share the personal information and have obtained all required consents.

There are additional considerations if you are publishing a listing to a remote region:

  • When you publish a listing, consumers will see your listing in all regions and will be able to get or purchase the data product in regions you select.

  • For free listings, you have the option of using listing auto-fulfillment or manually replicating the data. For personalized listings, you will have to replicate data upon consumer’s request. For private listings, Snowsight automatically detects if the target account is in a different region and enable auto-fulfillment. We do not support manual replication for private listings to other regions at this time.

  • If you choose auto-fulfillment, the data is automatically replicated to the regions selected based on the frequency selected. You do not have to worry about provisioning or replicating data manually.

  • If you choose manual replication:

    • You must replicate data to each of the available regions you select before publishing the listing.

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

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

  • Whether you use auto-fulfillment or manually replicate data - make sure to allocate time to set up replication and understand the costs involved.

  • All cross-region data sharing uses Snowflake’s data replication functionality. For more information, see Sharing Data Securely Across Regions and Cloud Platforms.

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

Back to top