dbt DuckDB Connect

dbt DuckDB setup in minutes

Use dbt DuckDB with the Matatika platform in minutes.

Automate data from dbt DuckDB with no code

DuckDB is an open-source analytical SQL database management system.

DuckDB is a high-performance analytical SQL database management system designed to handle complex queries and data-intensive workloads. It is optimized for read-heavy workloads and can handle large datasets with ease. DuckDB is designed to be easy to use and can be integrated with popular data science tools like Python and R. It also supports standard SQL syntax and has a wide range of built-in functions for data manipulation and analysis. DuckDB is open-source and can be used for free by anyone.

Settings

Skip Pre-invoke

Skips the pre-invoke hook when connecting to the dbt DuckDB API.

dbt Profile type

Specifies the type of dbt profile to use when connecting to the dbt DuckDB API.

Projects Directory

Specifies the directory where dbt projects are located.

Profiles Directory

Specifies the directory where dbt profiles are located.

Path

Specifies the path to the dbt project to connect to.

Schema

Specifies the schema to use when connecting to the dbt DuckDB API.


View source code

dbt DuckDB with your data warehouse

Use dbt DuckDB with your data warehouse or ours.

Interested in learning more?

Get in touch