06 Evaluation

Starting point

Modules 01 through 05 are complete: module 01's Snowflake environment ran all seven queries, module 02's migration plan has every worksheet filled in with every checkbox checked, and modules 03 through 05 migrated 50 million rows to ClickHouse, verified parity, benchmarked all seven queries, rebuilt the BI layer, and cut over the write path. Module 05 tore down both cloud environments before finishing, and this module does not need either one back — only two files that survived that teardown: workshop_public/snowflake_migration_lab/02-plan-and-design/migration-plan.md and workshop_public/snowflake_migration_lab/03-migrate-to-clickhouse/scripts/benchmark_results_<timestamp>.csv. Budget about 60 minutes.

Why

The badge is not credit for having run the scripts — module 05 already proved the migration itself works. It certifies that you can explain and defend the decisions behind it: why this engine, why this sort key, why this benchmark result, so you can reapply the same reasoning against a real customer's workload instead of just this lab's. That is why the open questions weight reasoning depth over recall — an answer that arrives at a different but defensible conclusion is worth more here than a correctly recited command.

Step 1 — Copy the assessment

The blank template lives at workshop_public/snowflake_migration_lab/04-evaluation/assessment.md.

cd "$(git rev-parse --show-toplevel)/workshop_public/snowflake_migration_lab/04-evaluation"
cp assessment.md assessment_<your_name>.md

Work in the copy, not the template. assessment_*.md is gitignored — anything you write into your copy stays on your machine and is never committed to the repository.

Step 2 — Answer the questions

This is open-book: your own migration-plan.md, your benchmark results, and every module of this playbook are all fair game while you answer. The open questions in particular reward depth of reasoning over recall, so it is worth having those two files open next to the assessment as you work.

• 20 multiple-choice questions. Write your letter choice — A, B, C, or D — on the **Your answer:** line under each question.
• 4 open questions, each with several sub-questions. Aim for 3-6 sentences per sub-question — draw on the reasoning you wrote down in migration-plan.md and on what your own benchmark numbers showed.
• Submission checklist, at the bottom of the file. Fill it in before you send anything — it is the record that both attachments are present and every question has an answer.

Questions draw on knowledge from across all three parts of the lab, not just the module you most recently finished.

Step 3 — Submit

Email the completed file, assessment_<your_name>.md, along with the two required attachments to your ClickHouse Solutions Architect:

• workshop_public/snowflake_migration_lab/02-plan-and-design/migration-plan.md
• workshop_public/snowflake_migration_lab/03-migrate-to-clickhouse/scripts/benchmark_results_<timestamp>.csv

How to verify you are done

Before sending the email, confirm:

• The submission checklist at the bottom of your assessment_<your_name>.md is filled in and every box is checked.
• All 20 multiple-choice questions have a letter on the **Your answer:** line.
• All 4 open questions are answered, with every sub-question addressed.
• Both attachments — migration-plan.md and your benchmark_results_*.csv — are attached to the email, not just referenced.

The scoring breakdown, so you know how the 60 minutes you just spent is weighted:

Pass threshold: 80 / 100. Multiple-choice questions carry no partial credit — 4 points or 0 per question. Your Solutions Architect scores each open question from 0 to 5.

End state

Your Solutions Architect reviews the submission and replies within 5 business days:

The badge certifies that you can confidently guide a customer through a Snowflake to ClickHouse migration: profiling the workload, making correct engine and schema decisions, executing the migration, and validating the result. That is the workshop.