3 — Snowflake (Trainer)

Pre-class Checklist — 2 weeks before

TRAINER ONLY

<span class="trainer-phase-label">2 weeks before</span>
<span class="trainer-step-indicator">Step <strong>3</strong> of 9</span>

Snowflake (Trainer’s own account)

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

• Trainer’s own Snowflake trial account created at signup.snowflake.com
• Cloud provider: Azure, Region: West Europe
• 00_account_setup.sql executed — creates:
  • Database: DE_MASTERCLASS
  • Warehouse: DE_WORKSHOP_WH
  • Role: DE_WORKSHOP_ROLE
  • Personal schemas (e.g. 00_JUEWEI_BRONZE/SILVER/GOLD — uppercase from trainer ATTENDEE_ID)
• 01_storage_integration.sql reviewed — Option B (SAS token) used for trial accounts, no action needed
• 02_external_stage.sql executed — creates file formats and External Stages with SAS token
• Verify LIST @00_JUEWEI_BRONZE.nyc_taxi_trips_stage (your trainer ID) returns Parquet files
• (Optional) Install Snowflake CLI or SnowSQL for scripting

---

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