Snowflake Marketplace

Snowflake · Data Sharing & Collaboration

Theory

Snowflake Marketplace is a catalog of listings published by data providers, such as weather, financial, demographic and reference data, and also Snowflake Native Apps. When you get a listing, it is mounted in your account as a read-only database built on Secure Data Sharing, so you can query it right away with your own warehouse, without loading files or building pipelines.

Listings can be free, paid, or offered on request with personalised terms. For example, adding a free weather listing lets you join daily temperatures to your sales table within minutes. Organisations can also publish private listings to specific accounts using the same listing mechanism.

Why we use it

Buying third-party data traditionally means contracts, file transfers and recurring loads. The Marketplace turns that into a few clicks, and the data stays current because the provider updates it in place.

When to use it

Use it to enrich your data with external datasets or to try apps that run inside Snowflake. Check the listing's terms, refresh frequency and regions before building on it. Publish a listing when you want to offer your own data to many consumers.

Getting Data In

Adding a Marketplace listing to your account works like accepting a share — the data becomes an ordinary (if read-only) database, immediately queryable alongside your own tables with no ETL involved.

Free and Paid Listings

Some listings (weather, public financial data) are free; others are commercial products with a subscription managed directly through the Marketplace billing flow, without a separate contract to set up.

Becoming a Provider

Any account can list its own data or a Native App on the Marketplace, turning data sharing into a distribution channel rather than a one-off integration.

How it works

  1. Open Marketplace → Snowflake Marketplace in Snowsight
  2. Open a listing and review terms, sample queries and regions
  3. Is the listing free or already approved? Yes: Click Get to mount it as a database. No: Request access or purchase.
  4. Grant the database to roles that need it
  5. Query and join it with your own data

Example

-- After adding a listing from the Marketplace UI, query it immediately:
SELECT * FROM weather_data_share.public.daily_temperatures LIMIT 10;

Key points

Snowflake topics

Snowflake Fundamentals

Warehouses & Performance

Staging & SnowSQL

Tables & Data Handling

Cloud Integrations

Storage & Optimization

Security & Governance

Views, Pipelines & Automation

Data Types & SQL Fundamentals

Semi-Structured Data Deep Dive

Advanced Features

Data Sharing & Collaboration

Cost Management & Monitoring

Databases, Schemas & Objects

Performance Deep Dive

Advanced Security & Governance

Stored Procedures & UDFs

Ecosystem & Integrations

SnowPro Certification Prep

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Mastering Snowflake

The modern data cloud, from architecture to SnowPro certification. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice Snowflake SQL Sharpen the SQL you use in Snowflake: 150 query problems in a live editor with instant checking. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Snowflake  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

{{ sec.h }}

{{ sec.body }}

{{ sec.body }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax
{{ current.syntax }}
Example
{{ current.example }}
Want to run this yourself? Unlike the SQL and Python courses, Snowflake needs a real account — there's no in-browser engine for it. Click Copy above, then paste it into a free Snowflake trial (30 days, no card required) and run it in Snowsight.
Key Points — click to check off as you learn
  • {{ pt.mark }} {{ pt.text }}

Share this topic