Reference
Standing guides for the engines, dbt adapters, and dashboards — read alongside any module.
These pages are not a track you work through in order. Each one is a standing guide, meant to be opened alongside whichever learner module needs it — most are referenced directly from the module that first needs them.
Before you migrate
Snowflake vs ClickHouse
Where the two engines differ in storage, compute, and SQL dialect — and which Snowflake idioms have no direct ClickHouse equivalent.
MergeTree engines
Choosing an engine from the MergeTree family, and designing an ORDER BY key that earns its keep.
Worked example: a completed plan
A filled-in migration plan for the NYC taxi workload, to compare against your own once you have written it.
dbt
dbt on Snowflake
How the source Medallion pipeline is built: sources, staging views, incremental MERGE models, snapshots, and tests.
dbt on ClickHouse
Configuring dbt-clickhouse: the delete_insert incremental strategy, ReplacingMergeTree models, and refreshable materialized views.
Operate and visualize
ClickHouse operations
Running the target service: querying, monitoring merges and parts, dictionaries, and the operational habits that differ from Snowflake.
Superset on Snowflake
Building the three source-side operational dashboards: connection, datasets, charts, and assembly.
Superset on ClickHouse
Rebuilding the dashboards against ClickHouse: seven datasets exercising uniqHLL12, quantileTDigest, sampling, window functions, and dictGet, then 18 charts across four dashboards.