Managing Listings as a Provider¶
After you create and publish listings to consumers, either privately or on the Snowflake Marketplace, you can manage your listings.
Managing Consumer Listing Requests¶
If you offer personalized listings or free listings that require manual replication of the data product to other regions, you must review and approve requests for your listings before consumers can access the listings.
Whether or not consumers need to request a listing depends on the type of listing and the region availability capabilities you choose for the listing:
Paid listings offered on the Snowflake Marketplace and all private listings use cross-cloud auto-fulfillment to provide data products to consumers, no matter the region they use Snowflake in. These listings are available to consumers immediately.
Free listings offered on the Snowflake Marketplace can use cross-cloud auto-fulfillment, or you can choose to replicate data manually to provide data products to consumers in regions other than the region of the data share that the listing is based on. Free listings that use cross-cloud auto-fulfillment are available to consumers immediately, otherwise consumers must request these listings.
Personalized listings require manual data replication to provide data products to consumers in regions other than the region of the data share that the listing is based on. Consumers must request these listings.
Viewing Requests for Listings¶
To view requests for a personalized or free listing, do the following:
In the left navigation bar of Snowsight, click 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 for your personalized listing.
If the consumer requesting a personalized listing is in the same region as your account, you can approve the listing request. See Approve a Listing Request.
If the consumer requesting your listing is not in the same region, 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 or free listings with manual data product fulfillment, 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 the regions where you make your listing available. The remote accounts must be part of the same organization as the account you published the listing from.
Set up provider profiles for each account.
Replicate the data product to each account. You do not need to replicate the data to each region until a consumer 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¶
By default, only the listing owner can approve and fulfill listing requests. As the listing owner, you can either allow all accounts in your organization to fulfill listing requests or explicitly add individual accounts as providers.
If a consumer requests a listing, do the following to approve the request:
Sign into 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 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.
Click 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 wish 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 free or personalized listing requests, you can view records of consumers added to the share in the classic web interface History tab. Requests use the ALTER SHARE command.
To see the request history, you must select the Include client-generated statements checkbox.
For more details, see Using the History Page to Monitor Queries.
You can also use SQL to view the records of consumers added to the share used by your listing. Use the QUERY_HISTORY View.