Configuration

Configure DuckDB execution settings in OndatraSQL. Control memory limits, parallelism, and disk spill behavior for your SQL data pipeline runtime.

OndatraSQL uses DuckDB's secrets manager for external credentials. Configure access to cloud storage, databases, and APIs for your data pipeline.

Load optional DuckDB extensions in OndatraSQL. Add cloud storage access, external database connectors, geospatial functions, and more to your pipeline.

Configure the DuckLake catalog in OndatraSQL. The only required config file. Tells the runtime where to store metadata and Parquet data files.

OndatraSQL loads reusable SQL macros from the config/macros/ directory. Define DuckDB functions for validation, helpers, and masking in your pipeline.

OndatraSQL loads runtime variables from the config/variables/ directory. Define pipeline configuration as SQL across constant, global, and per-model scopes.

Query external databases directly in OndatraSQL via DuckDB's attach mechanism. Connect PostgreSQL, MySQL, and other sources for use in SQL models.