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
- Sign in to your Snowflake account.
- 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
-
Click on a dataset (for example, “COVID-19 Tracking Data by Starschema”).
-
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!