Snowflake Data Clean Room tutorials, samples, and videos

教程

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

  • 基本 UI 教程，单个账户：使用单个 Snowflake 账户演示简单的重叠分析和使用者激活。单账户测试支持大多数（但不是全部）Clean Room 功能。要测试 Clean Room 的全部功能，必须使用多个 Snowflake 账户。

  • 基本 UI 教程，两个账户：使用两个 Snowflake 账户演示简单的重叠分析和提供商激活。

  • 基本 API 教程，单个账户：演示如何使用 API 通过单个 Snowflake 账户创建和运行自定义模板。

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.

小技巧

  • To upload a notebook, follow the instructions for uploading a notebook.

  • To upload a worksheet:

    1. Open the workspaces panel: In the navigation menu, select Projects » Workspaces.

    2. Upload the SQL worksheet: In the workspace menu, select + Add new » Upload Files.

List of sample files

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.

语言: 中文