Snowflake Data Clean Room tutorials and samples¶
Tutorials¶
Here are some tutorials to explore 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.
Notebooks and workbooks¶
Many of the use case topics include downloadable notebooks or workbooks to try full running samples of Snowflake Data Clean Rooms. You will 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 workbooks 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 workbook.
- 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 workbook.
- 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 workbook.