Glossary · Big data
What is DuckDB? Definition and meaning
An embedded, columnar SQL engine that runs analytical queries inside your application or notebook.
Definition
DuckDB: An embedded, columnar SQL engine that runs analytical queries inside your application or notebook.
In short: The SQLite of analytics.
When it is used
Local analytics, data engineering and querying Parquet and CSV files.
Where it fits
DuckDB belongs to Query engines and warehouses in the Big data topic. These are the other terms in the same group:
- Polars: A Rust-based DataFrame library with lazy query optimisation and parallel execution on Arrow memory.
- BigQuery: Google Cloud's fully managed, serverless data warehouse with separated storage and compute.
- Amazon Redshift: A managed, massively parallel columnar data warehouse on AWS with provisioned and serverless options.
Learn more
The full guide to DuckDB explains how it works, when to use it and how it compares with the alternatives, with examples. The glossary lists every term on the site from A to Z.
Previous term: DSPy · Next term: Dueling DQN