Özer Cem KELAHMETKELAHMET
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

Last updated Nov 18, 2026
Type to search.
    ↑↓ navigate↵ open