DuckDB - Oxy

A duckdb database entry can be added by specifying type: duckdb in your project’s config.yml. There are two ways to point it at your data.

A directory of files

Set dataset to the directory where your data files (CSV, Parquet, …) are stored. Oxygen runs SET file_search_path = '<dataset>' before every query, so you can query files by name.

databases:
  - name: local
    type: duckdb
    dataset: .db/

Directory sources are read-only.

A DuckDB database file

Set path to a .db file:

databases:
  - name: analytics
    type: duckdb
    path: data/analytics.db

Use a file database when you need to write to it — for example, as the output of modeling.