Snowflake MigrationClickHouse Workshops

Instructor track

Timing, talk tracks, common failures, and reset steps for facilitators.

This track is the facilitator's companion to the Learner track. Every learner module has a matching notes page here with its own Timing, Talk track, Common failures, and Reset steps sections. Read this landing page first for the room-level picture, then open each module's notes as you reach it.

Run of show

#Learner lessonBudgetNotes
00Setup~30 minPre-work — ideally done before the session, not the morning of
01Source environment~45 minStarts the trip producer, which must keep running through module 05
02Plan and design~90 minWorksheet-driven; almost none of it is unattended, so do not plan a break inside it
03Provision and migrate~60 minOf which 40–50 min is an unattended data transfer — the key scheduling fact for this module
04Rebuild the dbt pipeline~30 minThe only real dead air is the second dbt run, roughly 8–12 min
05Benchmark and cutover~45 minThe cutover step measures the gap the producer's continuous run created; both clouds are torn down at the end
06Evaluation~60 minSelf-administered and open-book; facilitators are typically not present for the writing itself

These budgets total about 6 hours. Confirm each against a timed dry run before committing to a published agenda.

Shared-resource checklist

Confirm each of these before the session starts:

  • Two cloud accounts, and who pays — a Snowflake trial account and a ClickHouse Cloud trial account, one pair per partner. Confirm ahead of time whose card (if any) is on file for each, and that both trials have the credits the run of show above assumes.
  • Module 00 is pre-work. It is ideally completed before the session, not the morning of — a partner who arrives having skipped it costs roughly 30 minutes of live session time to recover, at the expense of module 01's slot.
  • Module 01's producer must stay running through module 05. It writes live trip rows into Snowflake starting in module 01, and module 05's cutover step measures the exact gap between stopping writes to Snowflake and resuming them on ClickHouse. If it stops early, there is nothing left for that step to measure.
  • Module 03 has a 40–50 minute unattended data transfer. Build the agenda's one real break, or a live Q&A on partners' migration-plan.md decisions, around this window rather than anywhere else in the module.
  • The assessment answer key is not on this site. It lives outside this repository, is gitignored, and is distributed to facilitators by the ClickHouse Solutions Architect out of band. Do not reproduce any answer here — this site is public.

Per-module notes

On this page