DuckDB Destination
Prerequisites
- A self-hosted Landed instance (DuckDB is a local/embedded database)
- Write access to the file system where the DuckDB file will live
Overview
DuckDB is an embedded analytical database -- ideal for local development, testing, or self-hosted setups where you don't need a separate database server. Data is stored in a single file on disk.
Configure in Landed
| Field | Value |
|---|---|
| File Path | Absolute path to the DuckDB file (e.g., /data/landed.duckdb) |
Use :memory: for an in-memory database (data is lost when the process stops).
Notes
- The DuckDB file will be created automatically if it doesn't exist
- Ensure the Landed process has read/write permissions on the directory
- DuckDB supports concurrent reads but only one writer at a time
- Not recommended for production workloads with multiple concurrent syncs
- Good for: local development, small teams, data exploration, prototyping