Using dlt to move data from DuckDB to ClickHouse®

Recorded: March 16 @ 08:00 am PDT
Presenters: Joshua Lee & Elvis Kahoro

Watch this webinar for a hands-on technical session as we walk through building a data pipeline locally with DuckDB and seamlessly promoting it to a production data warehouse like ClickHouse with Altinity. With over 10,000 sources and a code-first OSS Python SDK, dlt (data load tool), is the tool of choice for builders (+ their agents)!

In this live demo, Elvis, a Developer Advocate at dltHub, and Josh, an Open Source Advocate at Altinity, will demonstrate how to:

• Ingest data from APIs and legacy databases using dlt
• Run and validate pipelines locally with DuckDB
• Promote your pipeline to ClickHouse with minimal changes
• Explore your loaded data with a Marimo notebook
• Run transformations and enforce data quality checks

If you’re building analytics, observability, or AI workloads on ClickHouse and want a clean path from local dev to production, this session will show you exactly how to do it yourself.