Managing Personalized Listings for the Snowflake Marketplace¶
Personalized listings are deprecated, but if you continue to provide personalized listings on the Snowflake Marketplace, you can refer to this guide.
When possible, use a limited trial listing instead. See Limited trial listings.
A personalized listing lets consumers request specific datasets from providers. A personalized listing can contain premium data that a provider charges for, or data that is specific to each consumer.
For more about how accessing a personalized listing as a consumer, see Request a personalized listing.
Configuring Personalized Listings¶
When configuring personalized listings, note the following:
Terms of Service Agreements are optional.
Data products are optional.
Data dictionaries are optional.
Auto-fulfillment is not supported for personalized listings.
Viewing requests for listings¶
To view requests for a personalized listing, do the following:
Sign in to Snowsight.
In the left navigation bar, select Data » Provider Studio.
In the Listings section, locate the personalized listing for which you want to view requests.
Select Consumer Requests to view requests from consumers.
You can review details about the consumer requesting the data product, such as their Snowflake region, company, contact information, and a brief message from the consumer.
If the consumer account requesting a personalized listing is:
In the same region as your account, you can approve the listing request. See Approve a listing request.
In a different region from your account, you must manually replicate the data before you fulfill the request. See Manually replicate data before fulfilling a listing request.
Manually replicate data before fulfilling a listing request¶
If you offer personalized listings to consumers in a different region from your account, you must manually replicate the data product to other regions when consumers request your listing.
To manually replicate the data product to other regions, you must do the following:
Set up accounts in all target regions where you want to make your listing available. The remote accounts must be part of the same organization as the account that originally published the personalized listing.
Set up provider profiles for each account.
Replicate the data product to each account. You do not need to replicate the data to a region until a consumer in that region requests it.
See Sharing Data Securely Across Regions and Cloud Platforms for details on creating accounts in the relevant remote regions and replicating the data shares used by your listings.
After completing those steps, you can approve listing requests.
Approve a listing request¶
To approve and fulfill listing requests, you must use a role that has been granted or inherits the OWNERSHIP or MODIFY privilege on the listing.
If a consumer requests a personalized listing, do the following to approve the request:
If the consumer account is located in a different region than your account, you must first manually replicate the data to their region.
Sign in to Snowsight.
In the left navigation bar of Snowsight, select Data » Provider Studio.
Locate the listing for which you want to view requests.
Select Consumer Requests.
Select the listing name for a request in pending status.
In the Associate Secure Share section, select the account where you want to create the share.
Select the role in that account that has the OWNERSHIP privilege on 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.
Choose Select Data.
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 want to add to the share.
If you do not see a share, it is either already attached to another listing, or has been previously shared with consumers.
(Optional) Change the default name for the secure share.
Select Fulfill Request.
Viewing fulfilled listing requests¶
After you fulfill a personalized listing request, you can view records of consumers added to the share by reviewing the query history for your account to identify the query used to fulfill the request. Queries that fulfill requests use the ALTER SHARE command.
Select Data » Private Sharing and select the Shared By Your Account tab.
Select Activity » Query History and enable a SQL Text filter for ALTER SHARE and enable the Client-generated statements filter.
- Classic Console
Select the History tab and select the Include client-generated statements checkbox. For more details, see Using the History Page to Monitor Queries.
Use the QUERY_HISTORY View.