3 — Snowflake (Trainer)

Pre-class Checklist — 2 weeks before

Snowflake (Trainer’s own account)

Uses the ADLS2 SAS token from ADLS2 storage. Attendees create their own trial accounts during Module 3.

Trainer Snowflake trial account created
- Where: signup.snowflake.com → The AI Data Cloud (not Cortex Code CLI)
- Configure: Azure · region West Europe · edition Enterprise (fixed at signup — cannot change later)
- Verify: Snowsight home loads; browser URL contains west-europe.azure (e.g. https://app.snowflake.com/west-europe.azure/el30551/#/homepage)
- Doc: Getting started with Snowflake
02_account_setup.sql executed
- Where: Snowsight → Projects → Workspaces → + Add New → SQL File → paste/run snowflake/sql/setup/02_account_setup.sql from repo (or open from Git workspace)
- Configure: Replace trainer attendee_id in the script (e.g. tr_01_juewei)
- Verify: Creates database DE_MASTERCLASS, warehouse DE_WORKSHOP_WH, role DE_WORKSHOP_ROLE, personal schemas (TR_01_JUEWEI_SQL_BRONZE, _SQL_SILVER, _SQL_GOLD, plus _SP_*, _NB_*, _DBT, _DBT_GOLD, _DBT_STREAMING; use your trainer ID)
- Doc: Workspaces
reference/storage_integration.sql reviewed (read-only — production pattern; trials use SAS in 04_external_stage.sql)
- Where: Read snowflake/sql/setup/reference/storage_integration.sql in repo — do not run on trial accounts
- Note: Workshop labs use ADLS2 SAS token in 04_external_stage.sql, not a storage integration object
- Doc: External stages for Azure
04_external_stage.sql executed
- Where: Workspaces SQL file → run snowflake/sql/setup/04_external_stage.sql
- Configure: Paste fresh ADLS2 SAS token from page 1 where script expects it
- Verify: File formats and external stages created in trainer bronze schema
- Doc: CREATE STAGE (Azure)
Verify LIST @TR_01_JUEWEI_SQL_BRONZE.nyc_taxi_trips_stage returns Parquet files
- Where: Workspaces SQL file → USE ROLE DE_WORKSHOP_ROLE; → LIST @TR_01_JUEWEI_SQL_BRONZE.nyc_taxi_trips_stage; (replace TR_01_JUEWEI with your trainer ID)
- Verify: yellow_tripdata_*.parquet from ADLS2 raw/trips/ appears
- Doc: LIST command
05_cortex_access.sql executed on trainer trial
- Where: Workspaces SQL file → run snowflake/sql/setup/05_cortex_access.sql
- Verify: SHOW GRANTS TO ROLE DE_WORKSHOP_ROLE includes Cortex / ML privileges (Modules 6 and 9)
- Doc: Snowflake Cortex overview
Remind attendees to run 05_cortex_access.sql on their trials before Module 6
- Where: Module 6 facilitator script — attendees run on their own Snowsight (trainer has no access)
- Doc: Snowflake setup guide
(Optional) Snowflake CLI (snow) installed locally
- Where: Local machine → install Snowflake CLI (pre-installed in Codespaces/Dev Container as snow)
- Doc: Snowflake CLI

Next 4 — Aiven Kafka Module 8 — or skip to 6 — Materials if not running streaming