Snowflake Data Clean Room tutorials, samples, and videos¶
Tutorials¶
Here are tutorials to try out using Snowflake Data Clean Rooms when you’re just getting started:
Basic UI tutorial, single account: Demonstrates a simple overlap analysis and consumer activation, using a single Snowflake account. Single account testing supports most, but not all clean room features. To test the full functionality of a clean room, must use multiple Snowflake accounts.
Basic UI tutorial, two accounts: Demonstrates a simple overlap analysis and provider activation using two Snowflake accounts.
Basic API tutorial, single account: Demonstrates using the API to create and run a custom template using a single Snowflake account.
Sample notebooks and worksheets¶
Many of the use case topics include full running samples of Snowflake Data Clean Rooms as downloadable notebooks or worksheets. You need a Snowflake account with the clean rooms API environment installed to run any of these samples, and you must be able to use the SAMOOHA_APP_ROLE role.
Internal testing clean room: Jupyter notebook demonstrating how to use a single account to act as both provider and consumer for testing purposes.
Consumer-run analysis: Code for running a basic consumer analysis clean room using separate provider and consumer accounts.
Provider-run analysis: Jupyter notebook showing how a provider can run an analysis in a clean room.
Consumer-run consumer activation: Code for activating analysis results to the consumer’s own Snowflake account, with setup and activation for both consumer and provider.
Consumer-run provider activation: Code for activating analysis results to the provider’s Snowflake account, with setup and activation for both consumer and provider.
Provider-run provider activation: Code for provider-run analysis with provider activation.
Consumer-defined templates: Code for creating, submitting, and managing consumer-written templates in a clean room.
Provider-defined templates: Code for creating, managing, and using provider-created templates in a clean room.
Consumer-written UDFs: Code for uploading and using custom Python functions in a clean room.
Provider-written UDFs: Code for uploading and using provider-uploaded custom Python functions in a clean room.
UDF from stage: Jupyter notebook demonstrating how to load user-defined functions from a Snowflake stage.
Snowpark UDFs: Code for creating and using Snowpark-based user-defined functions in clean rooms.
Consumer-written UDF run by the provider: A UDF uploaded by the consumer can be run by the provider.
Snowpark Container Services Integration: Jupyter notebooks for integrating Snowpark Container Services in clean rooms.
Audience Overlap & Segmentation: Jupyter notebook demonstrating the Audience Overlap & Segmentation template.
Sample templates¶
Snowflake Data Clean Rooms provides a few sample templates that you can download as Snowflake worksheets and implement or customize using the clean rooms API:
- Inventory forecasting template:
This template helps publishers and advertisers forecast ad inventory availability within a secure data clean room. Learn more and download the worksheet.
- Last touch attribution template:
This template provides a comprehensive Last Touch Attribution analysis that allows businesses to measure the effectiveness of their marketing channels. Learn more and download the worksheet.
- Audience lookalike modeling template:
This template empowers you to discover and target new, high-value customers who mirror your most profitable existing ones. Learn more and download the worksheet.
Videos¶
Our solutions engineers have created the following videos to demonstrate clean room usage. Watch them individually, or subscribe to our playlist (link removed).
- Native App Installation (https://youtu.be/FC4Ug95vepM?si=3TnuZDhOhl02V3LD):
How to install the Snowflake Data Clean Room environment in your account.
- Freeform SQL (https://youtu.be/847XBdAiam8?si=a9bAEmi8l566Qlbt):
How to make free-form SQL queries in Snowflake Data Clean Rooms.
- Editing A Clean Room (https://youtu.be/xMXrSiPBjrU?si=hBUO_1pi4d2hWyDr):
How to configure a clean room in the API or UI.
- Cross-Cloud Auto-Fulfillment (https://youtu.be/8BO2GwlZpJQ?si=mLQsLlq_GoAIS496):
How to enable Cross-Cloud Auto-Fulfillment in your clean rooms.