DuckDB Transformation
Run SQL in DuckDB, an in-process analytical database, inside Keboola. Start here, then jump to the how-to, reference, or the explanation of when to use it.
A DuckDB transformation runs your SQL in DuckDB — a fast, in-process analytical database — while Keboola maps data to and from Storage. It is a cost-effective backend for small-to-medium analytics.
This page is split by what you need:
- How do I run a DuckDB transformation? — create, configure, and run one end to end, with a worked example and troubleshooting.
- DuckDB transformation reference — configuration settings, backend sizes, versions, sync actions, block orchestration, Parquet, type inference, case sensitivity, and SQL extensions.
- When should I use a DuckDB transformation? — what it is, why DuckDB, and DuckDB vs. Snowflake.
Migrating from Snowflake? See the Snowflake to DuckDB migration guide. New to transformations? Start with Transformations and the Getting Started tutorial.