Snowflake Architecture · Topic 4 of 18
Data Clean Rooms, Snowflake Marketplace and Data Exchange
Choose between Snowflake Data Clean Rooms, the public Marketplace and a private Data Exchange, and know the roles, listing types and edition rules.
- 5 min
- Clean room: analysis without exposing raw rows; owner, data provider and analysis runner roles; templates in Jinja SQL.
- Clean room data providers need Enterprise Edition; trial accounts, government and Virtual Private Snowflake are not supported.
- Marketplace: public listings, access types free, limited trial (1 to 90 days) and paid; listings can be private or organization too.
What it is
Three collaboration features sit on top of Secure Data Sharing, and the exam tests which one fits a scenario.
- Snowflake Data Clean Rooms: several parties analyze their combined data without handing over the raw rows.
- Snowflake Marketplace: a public catalog where providers publish data products and any consumer can find them.
- Data Exchange: a private hub where only invited members share and discover data.
The question to ask is whether the parties want to see each other's data, find and get data publicly, or analyze together under rules.
How it works
Data Clean Rooms
A clean room lets collaborators run approved analyses over data that stays in each party's account. A typical case is advertiser and publisher overlap analysis, where neither side may reveal customer lists.
The main pieces of a collaboration:
| Piece | Role |
|---|---|
| Owner | Creates and manages the collaboration from a YAML specification naming collaborators, roles and resources |
| Data provider | Shares data offerings with specific analysis runners |
| Analysis runner | Runs approved templates on the data offerings shared with it |
| Data offering | Package of tables or views, a live view of the source and not a snapshot; its specification controls exposed columns and policies |
| Template | A Jinja SQL query that analysis runners can execute |
| Code spec | Custom Python function or procedure that templates can call |
Collaborators must review and join a collaboration before their resources become usable. Changing a collaboration requires approval from the affected collaborators.
Edition and account rules from the documentation:
- Data providers must be on Enterprise Edition. Owners and analysis runners can use Standard Edition.
- Standard Edition accounts cannot share data with policy enforcement, but can use others' offerings.
- Activating results to another Snowflake account needs Enterprise Edition.
- Trial accounts are not supported. Availability is limited by region, and government and Virtual Private Snowflake deployments are excluded.
- Collaborators in other cloud regions must enable Cross-Cloud Auto-Fulfillment before they can join.
Choose a clean room when the requirement says collaborators must not see each other's raw data. Choose a plain share when the consumer is allowed to query the data directly.
Snowflake Marketplace
The Marketplace is where providers publish public listings that many consumers can get without a separate sharing arrangement for each. A listing packages a data product, either a share or a Snowflake Native App, with a title, description and sample SQL.
Listing access types:
| Access type | Meaning |
|---|---|
| Free | Instant access to the full data set |
| Limited trial | Instant limited access for 1 to 90 days; consumer can then request unlimited access |
| Paid | Charged access using Snowflake pricing models, public or private |
The same listing mechanism also creates private listings sent to named accounts, and organization listings for accounts inside your own organization. A listing can reach any Snowflake region and cloud, using Cross-Cloud Auto-Fulfillment. Paid listings are limited to specific provider and consumer regions.
Consumers see Marketplace data in their account as a read-only database, created in a click. Data in the Marketplace is not copied into the consumer account in the sharing sense, so there is no storage cost for it.
Data Exchange
A Data Exchange is a private hub for a selected group, such as departments, suppliers and partners. The account that hosts it is the Data Exchange Admin. An ACCOUNTADMIN there adds or removes members and sets each member as a provider, a consumer or both.
- Providers create and publish listings in the exchange.
- Consumers browse exchange listings, and can switch between the exchange and the Marketplace.
- The admin can apply security controls and audit usage.
- Data Exchange is not enabled for all accounts; you request it through Snowflake Support.
| Feature | Marketplace | Data Exchange | Direct share |
|---|---|---|---|
| Audience | Public | Invited members | Named accounts |
| Discovery | Catalog | Private catalog | None, you tell them |
| Control | Provider controls each listing | Exchange admin controls members | Provider controls the share |
Common mistakes
Using a direct share when the requirement says raw data must stay hidden. A share exposes the shared rows to the consumer. A clean room runs approved templates instead.
Treating the Marketplace as private. A public listing is visible to everyone. For a closed group use a private listing or a Data Exchange.
Assuming clean rooms need Enterprise everywhere. Only data providers sharing with policy enforcement need Enterprise. Owners and runners can be Standard.
Forgetting Cross-Cloud Auto-Fulfillment for clean rooms. Collaborators in other regions must enable it before joining.
What to remember for the exam
- Clean room: analysis without exposing raw rows; owner, data provider and analysis runner roles; templates in Jinja SQL.
- Clean room data providers need Enterprise Edition; trial accounts, government and Virtual Private Snowflake are not supported.
- Marketplace: public listings, access types free, limited trial (1 to 90 days) and paid; listings can be private or organization too.
- Data Exchange: private hub run by an exchange admin, members are providers, consumers or both; not enabled by default.
- Listings can be cross region and cross cloud through auto-fulfillment.
Check yourself
Two companies want overlap analysis but neither may see the other's customer list. What fits?
A Snowflake Data Clean Room, where an approved template runs on both data offerings and only results are returned.
Who decides who can join a Data Exchange?
The Data Exchange Admin, an ACCOUNTADMIN in the hosting account, who adds members as providers, consumers or both.
How long can a limited trial Marketplace listing grant access?
From 1 to 90 days, after which the consumer can ask the provider for full access.
Topic 4 of 18 in Snowflake Architecture
Test yourself on Snowflake Architecture
The full Snowflake ARA-C01 question bank has 687 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.