Preparing data for a listing¶
This topic contains guidance for preparing to create a listing, including how to prepare a share for a listing.
Prepare to create a listing¶
Before you create a listing, do the following:
Decide what type of listing you want to create. See Types of listings.
Set up roles and privileges to simplify creating listings. See Set up roles and privileges for listings.
Identify the objects that you want to share. See Decide what to put in a listing.
Prepare the objects to be shared with others. See Prepare the shares for your listing.
Determine if you want to charge for your listing. See Preparing shares for a paid listing.
Choose which cloud region(s) you want to offer your listing in. See Prepare your listing to be shared in other regions.
The listing and data share must be in compliance with the Snowflake Provider Policies.
Set up roles and privileges for listings¶
When you create a listing, you create it from the account that has the data in it. Within that account, you can do one of the following to create and manage listings:
Use the ACCOUNTADMIN role.
Create and use a dedicated role with the global CREATE DATA EXCHANGE LISTING privilege.
The role that creates a share also owns the share, and that role must be used to attach the share to a listing. If the role that created the share is different from the role that you use to create and modify the listing, grant the MODIFY LISTING privilege on that listing to the role that owns the share so that users with that role can publish the listing.
For more information about data sharing privileges, see Granting Privileges to Other Roles.
Decide what to put in a listing¶
As you prepare to share data from your account with a listing, decide what to put in the listing.
First, make sure that the data you want to share is in Snowflake, and that you have the legal and contractual rights to share the data. If needed, load the data that you want to share into Snowflake. See Overview of Data Loading.
Note
To the extent any data in your 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 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 data through both a free or personalized listing, to do so you must have the applicable legal and contractual rights if the data is not publicly available.
Next, decide how to offer the data that you have as a listing. If you plan to offer listings on the Snowflake Marketplace or only as private listings directly with specific customers, you might make different decisions about what to place inside the listing.
Consider the availability of your data.
Consider the consumers that you expect to access your listings.
Consider the formats of the data that you select for the share, such as a table, view, secure view, or other database object.
For example, if you want to provide listings about dog grooming, you might make decisions like the following:
Offer a publicly available free listing on the Snowflake Marketplace with information about dog breeds and fur length.
Offer a private listing to a partner organization with insights about the length of time it takes to groom various dogs, and the typical frequency of grooming appointments for different dog breeds.
In this example, you offer valuable data on the Snowflake Marketplace, but offer more specific insights to an organization that you already have a trusted business relationship with.
Preparing to offer a paid listing¶
If you want to charge for your listing, you must do the following:
Determine if you can offer paid listings. See Who Can Provide Paid Listings.
Prepare the data to offer a trial of the data. See Preparing shares for a paid listing.
Decide on the pricing plan that best fits your listing. See Paid listings pricing models to review the available pricing plans.
Where you can publish paid listings¶
Only providers in certain regions can publish paid listings. See Who Can Provide Paid Listings
In addition, paid listings can only be published to certain regions. See Where paid listings are available to consumers to see to which regions you can publish paid listings.