6 — Materials & Credentials

Pre-class Checklist — 1 week before

1 Week Before — Materials & Credentials

Prepare a printed card or digital document for each attendee containing:

ATTENDEE_ID assigned (e.g. de_01_alice, de_02_bob)
- Where: Trainee management roster or spreadsheet — assign before Module 1
- Configure: Pattern de_{nn}_{firstname}; trainers use tr_{NN}_{firstname}
Databricks workspace URL on card (or confirm invite sent)
- Where: From page 2 workspace URL field
- Configure: Attendees paste into .env as DATABRICKS_HOST
Trainer notebook paths on credentials card
- Where: Databricks → Workspace → Users → <lead-trainer-email> → MHP-DE-Workshop-2026
- Configure: List lead + co-trainer emails so trainees know whose shared folder to open
ADLS2 storage account access key (verbal distribution only)
- Where: Generated on page 1 — never print in Git or email body
- Configure: Distribute verbally in Module 2
ADLS2 SAS token for Snowflake external stage
- Where: From page 1 — check expiry before printing cards
- Configure: Paste into attendee 04_external_stage.sql in Module 3
(Module 8) Aiven Service URI and SSL certificate contents
- Where: From page 4 — facilitator-managed via Databricks secrets; card optional for debugging

1–2 weeks before email sent
- Where: Your mail client — template on Trainee pre-work § Email templates
- Configure: Include mhp-data-engineer-2026.pages.dev, workshop token, roster email for sign-in, Prerequisites, fork/Codespace steps, Snowflake trial reminder
- Doc: Trainee pre-work
Day-before reminder scheduled
- Where: Day before checklist + Trainee pre-work § verification

TRAINER_API_SECRET set in Cloudflare Pages
- Where: Cloudflare Dashboard → Workers & Pages → mhp-data-engineer-2026 → Settings → Environment variables
- Configure: Add TRAINER_API_SECRET (production) — enables roster API / portal sync
- Doc: Cloudflare Pages environment variables
Roster entered in Trainee management
- Where: Training site → Trainee management (trainer login)
- Configure: Each row: unique email (Workshop Access sign-in) + GitHub username or email (fork invites)
- Verify: Saves to D1 when cloud sync enabled
GitHub collaborator invites sent
- Where: GitHub → MHPDataEngineerWorkshop → Settings → Collaborators → Add people
- Configure: Role Read — one invite per trainee GitHub account
- Doc: Trainee pre-work § GitHub fork access
Cohort settings saved in portal
- Where: Trainee management → cohort settings panel
- Configure: Site URL, ADLS2 key/SAS (secure fields), Databricks URL, Aiven URI as available
Copy portal link sent in pre-class email
- Where: Trainee management → Copy portal link → format …/trainee-portal.html?cohort=YYYYMMDD-slug
Unlock delivery credentials on training morning
- Where: Trainee management → Unlock credentials (or auto-unlock on delivery date if configured)

Trainer checklist:

Pre-class comms mention .env is Module 4 only — link Exercise: dbt § Configure .env
- Where: Email + site Prerequisites page
- Configure: Include cp .env.template .env step and variable list
Credentials card states Snowflake is each attendee’s own trial
- Where: Printed card / portal — no shared Snowflake password

Tell attendees (Module 1 slide or email):

Open Exercise: dbt § Configure .env (trainees do this before Module 4, not pre-class)
In Codespace terminal: cp .env.template .env
Fill ATTENDEE_ID, Snowflake trial vars, Databricks vars before Modules 2/4
Run bash .devcontainer/setup-environment.sh or restart Codespace

GitHub repo up to date on main
- Where: GitHub → MHPDataEngineerWorkshop → branch main — merge open PRs
Production site live
- Where: Cloudflare Pages · Vercel mirror
- Verify: CI deploy succeeded on latest main push (GitHub Actions)
Test training website
- Where: Open production URL → sign in with workshop token → browse modules, setup guides, exercises
.env.template and dbt_project/profiles.yml.example defaults correct
- Where: Repo root files — confirm DE_MASTERCLASS, DE_WORKSHOP_ROLE, catalog mhpdeworkshop_databricks_2026