DuckDB in Action

Dive into DuckDB and start processing gigabytes of data with ease-all with no data warehouse.

DuckDB is a cutting-edge SQL database that makes it incredibly easy to analyze big data sets right from your laptop. In DuckDB in Action you'll learn everything you need to know to get the most out of this awesome tool, keep your data secure on prem, and save you hundreds on your cloud bill. From data ingestion to advanced data pipelines, you'll learn everything you need to get the most out of DuckDB-all through hands-on examples.

Open up DuckDB in Action and learn how to:



Read and process data from CSV, JSON and Parquet sources both locally and remote
Write analytical SQL queries, including aggregations, common table expressions, window functions, special types of joins, and pivot tables
Use DuckDB from Python, both with SQL and its "Relational"-API, interacting with databases but also data frames
Prepare, ingest and query large datasets
Build cloud data pipelines
Extend DuckDB with custom functionality


Pragmatic and comprehensive, DuckDB in Action introduces the DuckDB database and shows you how to use it to solve common data workflow problems. You won't need to read through pages of documentation-you'll learn as you work. Get to grips with DuckDB's unique SQL dialect, learning to seamlessly load, prepare, and analyze data using SQL queries. Extend DuckDB with both Python and built-in tools such as MotherDuck, and gain practical insights into building robust and automated data pipelines. About the technology DuckDB makes data analytics fast and fun! You don't need to set up a Spark or run a cloud data warehouse just to process a few hundred gigabytes of data. DuckDB is easily embeddable in any data analytics application, runs on a laptop, and processes data from almost any source, including JSON, CSV, Parquet, SQLite and Postgres.