DuckDB runtime
Fast single-node analysis with in-process DuckDB: quickstart, how-tos, the full API reference and examples.
Chapters
- IntroductionThe Groundzero DuckDB runtime runs your Python code next to the DuckDB analytics engine. It is the fastest way to join, filter and aggregate data that fits on one…
- OverviewA Groundzero runtime is a software environment plus a compute size. When you run a dataset, job or notebook, Groundzero starts the runtime you selected with the…
- QuickstartThis section takes you from nothing to a working job, dataset and notebook. You need a Groundzero site with at least one connection to a data source. The examples use an…
- How-to guidesduckSession() is the single entry point. It returns a DuckSession: a DuckDB connection plus every connector method (readS3File, executeJdbc, readGzLakehouse and so on).
- API referenceThis reference documents the helper library available inside the DuckDB runtime. Everything below is importable in jobs, datasets and notebooks without installing…
- Installed packagesPackages without a version install at their latest release when the runtime is built. To read the exact version in your session, run pip show <name> in a notebook.
- Limits and troubleshootingCompute (CPU and memory) comes from the compute sizes defined for your site. A job has no maximum duration. A schedule that has an end time stops the run at that time.
- Examples galleryThe examples use fictional data for a retail company, Acme Retail. Connection names (sales_s3, orders_pg, lakehouse_main, ...) are placeholders for your own.