DuckDB

Scratch Data connects both to local DuckDB instances and MotherDuck.

In-Memory

To use an in-memory DuckDB store, set the following config:

databases:
  - type: duckdb
    api_keys:
      - test_api_key
    settings:
      in_memory: true

Local File

To connect to a local DuckDB file, set the following config:

databases:
  - type: duckdb
    api_keys:
      - test_api_key
    settings:
      file: "./db.duckdb"

MotherDuck

To connect to a remote MotherDuck instance, set the following config:

databases:
  - type: duckdb
    api_keys:
      - test_api_key
    settings:
        token: "eyJh..."
        database: "database_name"