ClickHouseWorkshops

选一个系列,
开始动手实践。

这里汇集了不同系列的 ClickHouse 实战课程:既有 90 分钟的分析速成,也有一整天的数仓迁移。只要开通免费的 ClickHouse Cloud 试用,就能亲手完成每一项练习。

系列 025 项实训

迁移系列

保留工作负载,更换底层引擎。

把现有数仓工作负载迁移到 ClickHouse,逐步完成 schema 设计、数据导入、管道改造和性能测试。所有基础设施都由你亲手创建,并在结束后自行清理。

6 小时高级
Snowflake 迁移
迁移工作负载,用数据验证收益。

在 6 小时的实战中,先搭建一套接近生产环境的 Snowflake 工作负载,再制定迁移方案,把 5000 万行数据迁入 ClickHouse Cloud,在 MergeTree 系列引擎上重建 dbt 管道,并对七条查询进行完整的性能对比。

SnowflakedbtTerraformMergeTree
查看实训 →
4 hoursAdvanced
Databricks Migration with MigrationRoom
Let the agent move it. Prove where it belongs.

A 4-hour hands-on lab: use MigrationRoom's AI-assisted workflow to move a Databricks TPC-H workload, prove Unity Catalog and a second REST catalog can stay zero-copy, and build a measured ClickHouse-native hot path.

DatabricksMigrationRoomUnity CatalogMergeTree
查看实训 →
4–6 小时高级
Elasticsearch 可观测性迁移
双写验证,确认一致,再完成切换。

把由 Elasticsearch、Kibana、Filebeat 和 Elastic APM 组成的生产型可观测性栈迁移到 ClickHouse Cloud、OpenTelemetry 和 HyperDX。完成 schema 设计、实时一致性验证和受控切换。

ElasticsearchOpenTelemetryClickStack迁移
查看实训 →
4–6 hoursAdvanced
RDS Postgres to ClickHouse Managed Postgres
Same SQL, new stack.

Move a live e-commerce workload off AWS RDS Postgres onto ClickHouse Managed Postgres with a minute of write downtime, stream the analytical copy into ClickHouse with ClickPipes, and route the dashboard's queries to it without changing a line of SQL.

PostgresManaged PostgresClickPipesMigration
查看实训 →
3 hoursIntermediate
BigQuery to ClickHouse
The dashboard BigQuery cannot serve.

Three hours: export a BigQuery public dataset, query it in place from object storage, then take the schema BigQuery hands you and beat it three times over -- on compressed bytes, on rows read for a lookup, and on a per-minute conversion funnel no sort key can rescue.

BigQueryClickPipesMaterialized ViewsMigration
查看实训 →
ZH