Github

DuckDB

Connect to a DuckDB database

Setup

The following credentials keys are accepted:

  • instance (required) -> The local file path of the database file

  • schema (optional) -> The default schema to use.

  • duckdb_version (optional) -> The CLI version of DuckDB to use. You can also specify the env. variable DUCKDB_VERSION.

  • read_only (optional) -> Whether to open the connection in readonly mode. Accepts true or false. Default is false.

  • interactive (optional) -> Whether to communicate to the DuckDB CLI via interactive mode instead of reopening the connection each time. Accepts true or false. Default is false.

Here is an example of setting a connection named DUCKDB:

export DUCKDB='duckdb:///path/to/file.db?schema=public'
PreviousClickhouseNextMotherDuck

Last updated