Skip to main content
DuckDB is included as a core dependency. No extra installation needed.

​
Connection config

adapter = "duckdb"

[connection]
database = "my_project.duckdb"
FieldDescription
databasePath to the DuckDB database file. Use :memory: for in-memory databases.
extensionsList of DuckDB extensions to install and load on connect.
settingsKey-value pairs passed as SET statements on connect.
attachList of additional databases to attach.

​
Extensions and settings

[connection]
database = "my_project.duckdb"
extensions = ["httpfs", "parquet"]

[connection.settings]
memory_limit = "4GB"

​
Attaching additional databases

[connection]
database = "my_project.duckdb"

[[connection.attach]]
path = "external_data.duckdb"
alias = "external"
read_only = true

​
Table promotion mode

DuckDB defaults to staged promotion: tables are materialized into a staging table, audited, then swapped into the target. This is configurable in settings: 
[settings]
table_promotion_mode = "staged"