liveBook · Manning

Snowflake Marketplace

As explained in Snowflake Data Engineering

Snowflake Marketplace is a catalog and distribution service for discovering and accessing data products and related offerings in Snowflake.

Snowflake Marketplace is a Snowflake platform for discovering, trying, buying, publishing, and accessing datasets from third-party providers. Organizations can use these datasets to enrich analysis, while providers can share data freely, privately, or through monetized listings. section 1.1.2 section 8.1

Use the Marketplace workflow to acquire data for analysis or pipeline work:

  • Search listings by subject and availability, using the “Instantly Accessible” filter for data that does not require provider approval. section 8.1
  • Evaluate free listings for an initial analysis, then consider paid listings when broader or more detailed data is required. section 8.1
  • Get the selected data into the Snowflake account and control which roles can access the resulting database. section 8.1
  • Use public or private sharing to collaborate within an organization or with external consumers. section 1.1.2

Retail expansion analysis

A bakery searches for retail-store, location, and product data, filters for instantly accessible free listings, and selects “Sample Harmonized Data for Top CPG Retailers and Distributors.” Analysts load the data into Snowflake and query it to identify nearby retail stores with strong sales potential. section 8.0 section 8.1

Figure 8.1 Search screen on the Snowflake Marketplace, displaying listings after filtering for “Instantly Accessible” and typing “retail” in the search box
figure

Use the Marketplace search screen to filter for instantly accessible listings and search for retail data. section 8.1

Figure 8.2 Snowflake Marketplace window where we specify the database name and the roles that can access the database before clicking the Get button to get the data into our Snowflake account
figure

Use the acquisition dialog to specify the database name and roles allowed to access the Marketplace data. section 8.1

How Snowflake Data Engineering covers it

How deep it goes
Explains listing discovery, free-versus-paid selection, acquisition, and role access, but stops short of programmatic Marketplace operations.
Examples
Uses retail-store, location, product, consumer-packaged-goods, weather, traffic, research, and machine-learning datasets as examples.
What it assumes
Requires a Snowflake account and Snowsight; acquiring data requires ACCOUNTADMIN or a custom role with CREATE DATABASE and IMPORT SHARE privileges.
What you can do after
Operate/configure Marketplace access through Snowsight and assign database access to appropriate roles.
How it connects
Connects data products with data analysis, data sharing, data governance, and Snowflake databases.

Related concepts

This explainer was generated by Manning's knowledge graph from the text of Snowflake Data Engineering. The section links point to the parts of the book it draws on.