6 — Classroom Fixes

Facilitator Guide — troubleshooting

TRAINER ONLY

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

Index2 Room prep3 Schedule & roles4 Module rhythm5 Module 7 runbook6 Classroom fixes7 Close & after

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


On this page


General & timing

Situation Response
Pair stuck on Bronze ingest Point to checkpoint data / co-trainer pairs in
Reflection runs long 5-min timer; capture 3 bullets max on whiteboard
Running late in Module 2–4 Cut discussion to 5 min — never cut lab

Module 2 — Databricks

Situation Response
Attendee cannot find notebooks in Databricks Guide to trainer’s shared Git folder: Workspace → Users → {trainer email} → MHP-DE-Workshop-2026; attendee clones 00_setup.py to Home per Databricks setup
Attendee’s Databricks cluster won’t start Check Compute page for error message; try Restart; if stuck >5 min, assign a buddy cluster
Databricks “Cannot see catalog” error Unity Catalog GRANT was not applied — re-run the GRANT statements from pre-class checklist § Databricks; or grant from Catalog → Permissions UI
Databricks CLI 403 Forbidden PAT may be expired or lack admin scope — generate a new token: Settings → User Settings → Access Tokens; ensure workspace has admin consent for CLI apps

Module 3 — Snowflake

Situation Response
Snowflake trial signup fails Suggest using a different email; check spam folder for verification email; trial creation can take 5–10 min
Snowflake 00_account_setup.sql fails Check attendee is using ACCOUNTADMIN role (default for trial); confirm SET attendee_id = '...' was run first
Snowflake DE_WORKSHOP_ROLE not found The role is created by 00_account_setup.sql — re-run the script; or manually: CREATE ROLE DE_WORKSHOP_ROLE;
Snowflake External Stage cannot list files SAS token may be expired or have extra spaces; re-copy from trainer handout; verify stage URL matches mhpdeworkshopsa.blob.core.windows.net
Snowflake warehouse shows “Suspended” Click warehouse name at top-right → click Resume; wait ~10 seconds for Started status
Snowflake worksheet shows “No results” Check session variable: SELECT $attendee_id; — if null, re-run the SET statement at the top

Module 4 — dbt

Situation Response
“dbt replaces Snowflake” Draw platform box; dbt inside as transform layer
dbt debug fails with connection error Check profiles.yml — confirm database: DE_MASTERCLASS, role: DE_WORKSHOP_ROLE, and correct Snowflake account/user/password

Module 7 — Discussion

Situation Response
Vendor debate in Module 7 “We’re advising Marcus, not picking a winner for MHP.”

Module 8 — Streaming

Situation Response
Module 8: workshop-scope secrets scope missing Trainer must create scope before class (see pre-class checklist § Databricks secrets); or guide attendee: databricks secrets create-scope --scope workshop-scope

Module 9 — ML

Situation Response
Databricks Experiments page is empty The experiment appears after the first mlflow.start_run() call — run the training notebook first
ML.FORECAST returns error in Snowflake Verify GOLD_TRIPS_BY_HOUR table exists and has PICKUP_HOUR_TS timestamp column; check Cortex role

Power BI

Situation Response
Power BI cannot connect to Snowflake Verify warehouse is Started; check server URL matches <account>.snowflakecomputing.com; use DirectQuery mode

Next 7 — Close & after End-of-day script and post-class tasks