AI engineering glossary · Data engineering
What is duckDB?
DuckDB: An open-source analytical database that runs inside the calling process, like SQLite for analytics, using columnar storage and vectorised execution. It can query Parquet and CSV files directly on a laptop.
DuckDB: an example
In Python, duckdb.sql("SELECT city, SUM(amt) FROM 'sales.parquet' GROUP BY city") runs without any server.
Related terms
More Data engineering terms
Where you learn it
DuckDB is part of the AI Engineering Program, which teaches it with notes, a hands-on lab and an exam. The first lesson is free.