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
• Classroom logistics
• Credentials & materials
• Environment verification
  • Databricks Workspace
  • Snowflake Snowsight
  • dbt
• Next step

---

Before the room opens (T-30 min)

ImportantChecklist first

Complete Morning of — platform verification (T-60) in the pre-class checklist, then work through Classroom logistics below. The role split table is for the last 30 minutes only.

Task	Owner
Classroom logistics checklist	Lead + Co-trainer
Run environment verification on trainer accounts	Co-trainer
Photo / save blank whiteboard space for Story sketch	Lead

Animation fallback if MP4 missing: animation fallback scripts.

---

Classroom logistics

Room setup and printed materials (not tracked in the technical pre-class checklist):

• Projector / second screen tested; training site visible on display
• Laptop charged; HDMI / USB-C adapters packed
• Credentials cards at trainer desk (contents) — distribute ATTENDEE_ID at Module 1; no ADLS2 key on paper
• Printed handouts at seats if used: Architecture Decision Matrix (Module 7)
• Trainer copies: Whiteboard Prompts, Open Discussion Guide
• Google Form URLs — QR or short links tested from phone
• Sign-in URL ready for slide: …/sign-in.html?cohort=YYYYMMDD-slug (Trainee management)
• Check-in fallback runbook bookmarked if using Google Form backup

---

Credentials & materials

When to hand out each credential: Credential Distribution Schedule. Card field list: § Credentials Sheet. Physical prep: Classroom logistics above.

---

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:
   • Trainees self-create clusters under the Workshop policy (de-workshop-{attendee_id}) — trainer does not bulk-create roster clusters; see pre-class checklist § Databricks
   • Trainer dry-run clusters (de-workshop-00_*) are Terminated (not Error) if still present
   • Create compute (as test trainee or admin checking policy): form loads; runtime dropdown shows 16.4 LTS / 15.4 LTS (or 16.4 LTS ML when checking Module 9 policy)
3. Git folder — Both trainers Git → Pull on MHP-DE-Workshop-2026 (branch main). Home → MHP-DE-Workshop-2026 — confirm 6 notebooks under databricks/notebooks/: 00_setup.py, _workshop_bootstrap.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 ALL PRIVILEGES for workshop_trainees_2026 and workshop_trainer_2026 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)

Checks on your trial only — attendees create own accounts in Module 3 (trainer cannot pre-verify attendee Snowflake).

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 02_account_setup.sql).
4. SQL files — Navigate to Projects → Workspaces. Create a test SQL File → run SELECT CURRENT_VERSION() → confirm the result appears.
5. Databases — Navigate to Data → Databases → DE_MASTERCLASS. Confirm your own schemas (TR_01_JUEWEI_SQL_BRONZE, _SQL_SILVER, _SQL_GOLD, plus _SP_*, _DBT, _DBT_GOLD) exist (replace with your trainer ID, e.g. tr_01_juewei).
6. External Stage — Run LIST @TR_01_JUEWEI_SQL_BRONZE.nyc_taxi_trips_stage (your trainer ID + _SQL_BRONZE schema) to verify the ADLS2 SAS token works and Parquet files are listed.

dbt (Docker / Codespaces)

Trainees should have completed Trainee pre-work before arrival (site URL, GitHub invite + fork, Codespace, Snowflake trial). ATTENDEE_ID via My Workshop on training day; .env before Module 4 — Exercise: dbt § Configure .env. Same-day additions: Trainee management — Add row, fill name, email, and GitHub fields, Save, then send GitHub collaborator invite before they fork. Emergency no-GitHub: § Emergency fallback only.

1. Codespaces — Open a Codespace from the fork → run dbt --version in the terminal → confirm dbt-core 1.11.8, dbt-databricks 1.12+, dbt-snowflake 1.11.5+ (pins in fork pyproject.toml).
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