2 — Databricks Workspace

Pre-class Checklist — 2 weeks before

TRAINER ONLY

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

Databricks Workspace (mhpdeworkshop_databricks)

Pre-provisioned — workspace already exists in resource group 1000_data_engineering_workshop; do not create a new one.

Item	Value
Workspace	mhpdeworkshop_databricks (ID 3359135813781456)
Resource group	1000_data_engineering_workshop (same as ADLS2)

• Workspace confirmed — open resource group → mhpdeworkshop_databricks → Launch workspace

• Workspace URL noted

• You are workspace admin — can open Admin settings → Identity and access

• Git credentials linked — Settings → Linked accounts → Git integration (GitHub PAT)

• Trainer IDs agreed — pattern 00_{firstname} (Credentials Sheet); 2026: 00_juewei + 00_alisa

• Lead trainer — Git folder + 00_setup.py with their trainer ATTENDEE_ID (e.g. "00_juewei") → schemas 00_juewei_* created

• Co-trainer — Git folder + 00_setup.py with their trainer ATTENDEE_ID (e.g. "00_alisa") → schemas 00_alisa_* created

• Both: Home → Create → Git folder — URL https://github.com/jinjuewei/MHPDataEngineerWorkshop.git, name MHP-DE-Workshop-2026, sparse databricks/notebooks

• Both trainers Git → Pull on MHP-DE-Workshop-2026 (branch main) — workspace does not auto-sync with GitHub

• After any new push to GitHub before class: Pull again on both trainer folders

• Groups created — workshop_trainer_2026 (lead + co-trainer) · workshop_trainees_2026 (all attendees)

• Entitlements on workshop_trainees_2026: Workspace access + Databricks SQL

• Both trainers shared folder to trainees — MHP-DE-Workshop-2026 → Share → workshop_trainees_2026 → Can Run (verify with test user)

• Users invited — each attendee accepted workspace invite email

• Unity Catalog mhpdeworkshop_databricks_2026 created (new for 2026; legacy mhpdeworkshop_databricks_2025 unchanged) — Catalog → Create catalog if missing

• Unity Catalog GRANTs on mhpdeworkshop_databricks_2026:

  GRANT USE CATALOG ON CATALOG mhpdeworkshop_databricks_2026 TO `workshop_trainees_2026`;
  GRANT CREATE SCHEMA ON CATALOG mhpdeworkshop_databricks_2026 TO `workshop_trainees_2026`;
  -- After 00_setup.py per attendee (lowercase schema names):
  GRANT USE SCHEMA ON SCHEMA mhpdeworkshop_databricks_2026.{attendee_id}_bronze TO `workshop_trainees_2026`;
  GRANT USE SCHEMA ON SCHEMA mhpdeworkshop_databricks_2026.{attendee_id}_silver TO `workshop_trainees_2026`;
  GRANT USE SCHEMA ON SCHEMA mhpdeworkshop_databricks_2026.{attendee_id}_gold TO `workshop_trainees_2026`;
  GRANT SELECT ON SCHEMA mhpdeworkshop_databricks_2026.{attendee_id}_gold TO `workshop_trainees_2026`;

• Cluster policy Workshop — max 1 worker, Standard_DS3_v2, 30 min auto-terminate; Can use for workshop_trainees_2026 + workshop_trainer_2026

• Clusters — pre-created de-workshop-{ATTENDEE_ID} or trainees self-create under Workshop policy; verify test trainee can create cluster

• Attendees briefed: open trainer shared folder + clone 00_setup.py to Home (Databricks setup)

• SQL Warehouse de-workshop-wh — Pro or Serverless (Module 6 Genie + ai_query(); also if dbt uses Databricks target) — 2X-Small, auto-suspend 5 min; workshop_trainees_2026 + workshop_trainer_2026 Can use

• Module 6 AI — Partner-powered AI On (account + workspace); trainer dry-run Assistant / ai_query() / Genie — see facilitator guide § Module rhythm

---

→ Next 3 — Snowflake (trainer) Needs SAS token from ADLS2 (page 1)