2 — Before the Room Opens

Facilitator Guide — T-30 min

TRAINER ONLY

Day-of navigation (follow in order on delivery day):

Index → 2 Room prep → 3 Schedule & roles → 4 Module rhythm → 5 Module 7 runbook → 6 Classroom fixes → 7 Close & after

Before class: Platform dependency order (sidebar · links into checklist)

On this page

Before the room opens (T-30 min)

ImportantChecklist first

Tick every box in Morning of Workshop (T-60 min) in the pre-class checklist. The table below is only the lead vs co-trainer split for the last 30 minutes — not a second checklist.

Task Owner
Test projector / second screen for animations Lead
Open training site: production or quarto preview workshop-2026-v2/ port 4201 Co-trainer
Run environment verification below on trainer accounts Co-trainer
Photo / save blank whiteboard space for Story sketch Lead
Place credentials cards and printed materials on seats Co-trainer
Confirm Google Form URLs open (QR / short links) Co-trainer

Animation fallback if MP4 missing: Read animation beat from voiceover scripts while showing module story callout on screen.

Credentials & materials

Prepare and distribute per the pre-class checklist — do not maintain a second copy here:

Need Checklist section
What to print and prepare (1 week before) 6 — Materials & credentials
When to hand out each credential Credential Distribution Schedule
Attendee ID card contents § Credentials Sheet
ImportantSnowflake is self-service

Unlike Databricks (trainer-managed workspace), each attendee creates their own Snowflake trial account. This means:

  • Attendees are ACCOUNTADMIN on their own accounts
  • They run 00_account_setup.sql themselves during Module 3 — this creates the database (DE_MASTERCLASS), warehouse (DE_WORKSHOP_WH), role (DE_WORKSHOP_ROLE), and personal schemas
  • The trainer cannot pre-verify attendee Snowflake accounts — only the trainer’s own account can be verified beforehand
  • dbt connects to Snowflake using the attendee’s own credentials (username/password + DE_WORKSHOP_ROLE)

Environment verification

Run these checks on the trainer’s environments before attendees arrive. Attendees verify their own accounts during Modules 2–4. Each step maps to a checkbox in Morning of Workshop.

Databricks Workspace

  1. Login — Open the workspace URL (e.g., https://<workspace>.azuredatabricks.net). Confirm you land on the landing page with the left sidebar visible (Workspace, Catalog, Compute, SQL Editor, AI/ML, Genie, Jobs & Pipelines icons).
  2. Compute — Click Compute in the left sidebar. Verify:
    • Clusters exist per attendee (de-workshop-{attendee_id}) or trainees can self-create under the Workshop policy — see pre-class checklist § Databricks
    • Clusters are in Terminated state (ready for attendees to start) — if any show Error, investigate before class
    • Click Create compute to verify the form loads (Runtime dropdown shows 15.4 LTS ML, Node type available)
  3. Git folder — Both trainers Git → Pull on MHP-DE-Workshop-2026 (branch main). Home → MHP-DE-Workshop-2026 — confirm 5 notebooks: 00_setup.py, 01_bronze_ingestion.py, 02_silver_cleaning.py, 03_gold_kpis.py, 04_ai_features.py. Share shows workshop_trainees_2026 Can Run.
  4. Unity Catalog — Click Catalog icon → verify catalog mhpdeworkshop_databricks_2026 is accessible. Confirm GRANT statements from pre-class checklist § Databricks were applied.
  5. SQL Editor — Click SQL Editor icon → + New query → run SELECT 1 AS test → confirm results appear.
  6. Secrets (if Module 8) — Verify the workshop-scope scope exists: databricks secrets list --scope workshop-scope or check via Databricks CLI.

Snowflake Snowsight (trainer’s own account)

These checks run on the trainer’s own Snowflake trial account to verify the UI paths work correctly. Attendees create their own accounts during Module 3.

  1. Login — Open your Snowsight URL. Confirm the left sidebar shows: Projects, Data, Compute, Admin sections.
  2. Warehouse — At the top-right, verify DE_WORKSHOP_WH warehouse exists and is selectable. If suspended, click to resume and confirm it shows Started within ~10 seconds.
  3. Role — Verify DE_WORKSHOP_ROLE is available in the role selector dropdown (created by 00_account_setup.sql).
  4. Worksheets — Navigate to Projects → Worksheets. Create a test worksheet → run SELECT CURRENT_VERSION() → confirm the result appears.
  5. Databases — Navigate to Data → Databases → DE_MASTERCLASS. Confirm your own schemas (00_trainer_BRONZE, _SILVER, _GOLD) exist.
  6. External Stage — Run LIST @00_trainer_BRONZE.nyc_taxi_trips_stage (your trainer ID) to verify the SAS token works and Parquet files are listed.

dbt (Docker / Codespaces)

  1. Codespaces — Open a Codespace from the fork → run dbt --version in the terminal → confirm Core 1.8.x with adapters snowflake and databricks.
  2. Docker — Pull the workshop image: docker pull ghcr.io/mhp-data-engineer/workshop-dbt:2026 → run docker run --rm ghcr.io/mhp-data-engineer/workshop-dbt:2026 dbt --version.
  3. Connection test — Inside the environment: cd dbt_project && dbt debug --target snowflake → confirm All checks passed!.

Next 3 — Schedule & roles Main-day agenda and trainer responsibilities