Sample Worksheets and Videos

Tutorials

Here are tutorials to try out using Snowflake Data Clean Rooms when you’re just getting started:

Video tutorials

The DCR team has created the following videos to walk you through the collaboration resources and how to manage collaborations:

  • Register Data Offerings (link removed) This tutorial walks through creating sample datasets, defining data offering specifications, and leveraging standardized schemas to streamline collaboration. Discover how to use join keys, metadata columns, and category types to prepare your data for secure, governed analysis across multiple parties.

  • Register Templates (link removed) Learn how to build templates that enable secure multi-party data collaboration, from simple overlap analysis to complex three-party joins with aggregations to unlock advanced measurement use cases across multiple organizations while maintaining governance and control.

  • Manage Collaborations (link removed) Learn how to manage secure data collaborations using Snowflake Data Clean Rooms across one, two, and three-party scenarios.

Sample 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.

Tip

To upload SQL worksheets and notebooks, see Create and work with files and folders.

Sample single-account collaboration:

Demonstrates a simple collaboration with only a single user account. The example worksheet creates a collaboration with two data offerings and two templates, and runs each template.

Advanced single-account collaboration:

Demonstrates the use of RBAC roles to limit access, and custom registries, in a single account. The example worksheet creates a collaboration with four roles: one that can create a collaboration; one that can register templates; and two that can run analyses.

Basic two-party example:

Demonstrates a two-party collaboration that creates templates and data offerings. Requires two accounts.

Free-form query example:

Demonstrates how to implement and run free-form SQL queries in a collaboration. Requires two accounts.

For more examples, including inventory forecasting and last touch attribution, see the Use cases section.