Data Sharing and Snowflake Marketplace · Topic 9 of 10

Provider Profiles, Creating Listings and Managing Listing Requests

Create and edit provider profiles, build and submit a listing in Provider Studio, modify published listings, and manage listing requests from consumers.

  • 5 min
In a nutshell
  • Provider Studio holds profiles, listings and requests.
  • Profile needed for Marketplace and paid listings; free private listings need none.
  • Listing path: draft, Submit for Approval, approved or denied, publish.

What it is

Everything a provider does in the Marketplace happens in Provider Studio in Snowsight. It holds three things: profiles (who you are as a provider), listings (the data products you offer) and the requests that consumers send you.

An administrator is expected to know the order: profile first, then a listing, then approval, then the daily work of editing listings and answering requests.

Provider profileidentityapprovedListing draftproduct, access, termsSubmit for ApprovalApprovedreviewed by SnowflakePublishPublished listingconsumers find it

How it works

Provider profiles

A profile is the public identity of the provider: name, description, logo and contacts. It is required for Marketplace listings and for paid listings. Free private listings do not need one.

TaskWhere and how
CreateMarketplace, Provider Studio, Profiles, Create profile
SubmitFill all required fields, then Submit for Approval, or Save Draft
ApprovalSnowflake checks the accepted terms and that the profile follows the Provider Policies
EditOpen the profile in Provider Studio; the role needs the MODIFY privilege on the profile
Several profilesAn account can have more than one, for example per brand
ContactsThe profile contacts receive the approval and denial emails for listings

Create the profile once and reuse it. Editing and deleting are done from the profile management topic of Provider Studio, so check that no live listing depends on a profile before you remove it.

Exam tip

Put monitored team mailboxes in the profile contacts, not a person. Approval and denial decisions for every listing go to those addresses.

Create, submit and publish a listing

There are two creation paths in Provider Studio, and each has its own steps.

Private listing (specified consumers). Create Listing, Specified Consumers. Give a title, add a data product (database objects create a secure share, or pick an existing share), choose Free or Paid, add the consumer organization and account names, add a description and terms, and Publish. For consumers in other regions, configure Cross-Cloud Auto-Fulfillment.

Marketplace listing. Create Listing, Snowflake Marketplace. Give a name, subtitle and profile, choose the product type (secure share, Native App or Connected App) and the access type (Free, Limited trial or Paid), complete the fields and submit for approval.

ElementNotes
Product typeSecure share (a dataset), Native App, or Connected App
Access typeFree, limited trial, paid; a paid listing cannot be changed back to free later, so start a new draft
Business needAt least one is required for a public listing
Sample queriesMust validate before the listing can be submitted
Trial kindsLimited usage, limited time, limited functionality, or a combination
Paid private listingsNeed Marketplace Operations approval and a pricing plan

Submit for Approval is available on the Listings tab only when the listing is fully configured, you hold ACCOUNTADMIN or OWNERSHIP, and all sample SQL validates. The state then becomes Approved or Denied, and both profile contacts are emailed. If denied, read the comments, fix and resubmit.

DraftsavedSubmit for ApprovalIn reviewSnowflakeapprovedPublishedvisibledeniedFix and resubmitfrom comments

Manage and modify a listing

After publishing:

  • For a private listing you cannot change the share that belongs to the listing. To change the product, create a new listing.
  • For a Marketplace listing, changes that need approval publish automatically once approved. To change that, open Settings, Listing Settings, Publishing, Edit Publishing and choose Manual, and you then publish changes yourself.
  • Add objects to the underlying share with normal GRANT ... TO SHARE statements. New data in shared tables shows to consumers at once.
  • Keep sample queries and descriptions current. Failed samples can block resubmission.
  • Use DATA_SHARING_USAGE views to see how the listing is used (a later page).
Watch out

Do not drop the share behind a published listing to "reset" it. Consumers lose access. Create a new listing and move consumers.

Manage listing requests

Some listings need a request. A consumer who cannot simply Get the data sends a request from the listing, and the provider sees it in Provider Studio. The provider reviews who is asking, checks that the account is allowed to receive the data, then approves or declines. Approval adds the consumer account to the listing so that it can get the data.

Good request handling:

  1. Check the requester organization and account.
  2. Confirm the commercial terms or agreement outside Snowflake if needed.
  3. Approve or decline in Provider Studio, and note why.
  4. For regions where the data is not yet present, rely on Cross-Cloud Auto-Fulfillment so the approval takes effect without further work.
Listing kindHow consumers get it
Free publicSelect Get; no provider action
Public on requestRequest, provider approves
Private listingOnly named accounts see it; they Get or request
PaidSubscribe through Snowflake billing under the offer

Common mistakes

Submitting without a valid sample query. The submit action stays disabled.

Creating the profile after the listing is ready. Approval can take time and holds up the launch.

Trying to swap the share of a published private listing. It is fixed; create a new listing.

Switching a paid listing to free. Not possible; delete the draft and create a new one.

Leaving profile contacts to a single person. Decisions are missed when that person is away.

What to remember for the exam

  • Provider Studio holds profiles, listings and requests.
  • Profile needed for Marketplace and paid listings; free private listings need none.
  • Listing path: draft, Submit for Approval, approved or denied, publish.
  • A published private listing cannot change its share; Marketplace changes can publish automatically or manually.
  • Product types: secure share, Native App, Connected App; access types: free, limited trial, paid.

Check yourself

  • Who receives the approval or denial email?

    The contacts listed in the provider profile.

  • Can the share of a published private listing be replaced?

    No. A new listing is needed.

  • When is Submit for Approval available?

    When the listing is fully configured, the user holds ACCOUNTADMIN or OWNERSHIP, and sample SQL validates.

Topic 9 of 10 in Data Sharing and Snowflake Marketplace

Test yourself on Data Sharing and Snowflake Marketplace

The full Snowflake ADA-C02 question bank has 814 questions, with timed practice exams and an explanation for every answer.

This study guide is independent and is not affiliated with, endorsed by, or sponsored by Snowflake. Vendor names, certification names and exam codes are trademarks of their respective owners and are used for identification only.