Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.sqlbuild.com/llms.txt

Use this file to discover all available pages before exploring further.

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
  settings:
    memory_limit: 4GB

​
Attaching additional databases

connection:
  database: my_project.duckdb
  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