Skip to main content

What is the Snowflake Marketplace?

Here’s an example of how to access, check, and use a dataset from the Snowflake Marketplace. I’ll put it in Markdown format so you can copy-paste or use it directly.


📊 Example: Accessing a Dataset from Snowflake Marketplace

Let’s walk through how to find a dataset, access it, and use it in your Snowflake environment.


1️⃣ Log in to the Marketplace​

  1. Sign in to your Snowflake account.
  2. In the top menu, click on Marketplace.

2️⃣ Browse or Search for a Dataset​

  • You can search for a dataset (e.g., “Weather data”, “Retail benchmark data”).

  • Or browse categories like:

    • Financial Services
    • Retail
    • Healthcare
    • Geospatial

3️⃣ Preview a Listing​

  1. Click on a dataset (for example, “COVID-19 Tracking Data by Starschema”).

  2. View:

    • Description of the dataset.
    • Schema preview.
    • Sample queries.
    • Provider info.

4️⃣ Request or Get Access​

  • If the dataset is public, you’ll see an option to Get Data.
  • If it requires approval, click Request Access and wait for the provider to approve.

5️⃣ Add to Your Environment​

  • ✅ Once access is granted:

    • Snowflake automatically creates a database in your account with the dataset.

For example:

SHOW DATABASES LIKE 'COVID19_TRACKING_DATA';

6️⃣ Query the Dataset​

You can run standard SQL queries on the Marketplace dataset just like any other table in Snowflake!

Example:

-- Explore COVID data
SELECT
DATE,
COUNTRY_REGION,
CONFIRMED,
DEATHS
FROM
COVID19_TRACKING_DATA.PUBLIC.DAILY_REPORTS
WHERE
COUNTRY_REGION = 'India'
ORDER BY
DATE DESC
LIMIT 10;

7️⃣ Example Use Case​

Let’s say you want to join the Marketplace dataset with your internal sales data:

WITH external_covid_data AS (
SELECT
DATE,
COUNTRY_REGION,
CONFIRMED
FROM
COVID19_TRACKING_DATA.PUBLIC.DAILY_REPORTS
WHERE
COUNTRY_REGION = 'India'
)

SELECT
s.ORDER_DATE,
s.SALES_AMOUNT,
e.CONFIRMED
FROM
MYDB.SALES s
JOIN
external_covid_data e
ON s.ORDER_DATE = e.DATE
WHERE
s.COUNTRY = 'India';

8️⃣ Impact and Benefits​

  • ✅ No ETL – Data is live and queryable immediately.
  • ✅ Security – Snowflake manages permissions and sharing.
  • ✅ Governed – Auditable access via your account.

🔥 How to Try It Yourself​

  • ✅ Go to: Snowflake Marketplace: https://app.snowflake.com/marketplace

  • ✅ Find a dataset like:

    • COVID-19 Tracking Data by Starschema
    • SafeGraph Social Distancing Metrics
    • S&P Global Market Intelligence (for financial data)
  • ✅ Start by using the free datasets to explore how data sharing works!