Managing listing requests as a provider¶
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 which 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:
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 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 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 listing, do the following to approve the request:
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.
Note
If you do not see a share, it is either already attached to another listing, or has been previously shared with consumers.
Select Done.
(Optional) Change the default name for the secure share.
Select Fulfill Request.
Viewing fulfilled listing requests¶
After you fulfill a free or 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.
- Snowsight
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.
- SQL
Use the QUERY_HISTORY View.