dbt PostgreSQL Connect

dbt PostgreSQL setup in minutes

Use dbt PostgreSQL with the Matatika platform in minutes.

Automate dbt PostgreSQL from a single space with no code

Overview: dbt PostgreSQL is a data transformation tool for PostgreSQL databases.

Description: dbt PostgreSQL is a popular open-source data transformation tool that allows users to transform data in their PostgreSQL databases. It provides a simple and intuitive way to build data pipelines, allowing users to easily transform, test, and deploy their data models. With dbt PostgreSQL, users can write SQL code to transform their data, and then use the tool to test and deploy those transformations. The tool also provides a range of features to help users manage their data pipelines, including version control, documentation, and automated testing. Overall, dbt PostgreSQL is a powerful tool for anyone looking to transform their data in a PostgreSQL database.

Settings

Skip Pre-invoke

Whether to skip pre-invoke checks before connecting to the dbt PostgreSQL API.

dbt Profile type

The type of dbt profile being used to connect to the PostgreSQL API.

Projects Directory

The directory where dbt projects are stored.

Profiles Directory

The directory where dbt profiles are stored.

Host

The hostname or IP address of the PostgreSQL server.

User

The username used to connect to the PostgreSQL server.

Password

The password used to connect to the PostgreSQL server.

Port

The port number used to connect to the PostgreSQL server.

Database

The name of the PostgreSQL database to connect to.

Schema

The name of the PostgreSQL schema to use.

Keep Alives Idle

The number of seconds to wait before sending a keep-alive message to the PostgreSQL server.

Search Path

The search path to use when querying the PostgreSQL database.

Role

The PostgreSQL role to use when connecting to the database.

SSL Mode

The SSL mode to use when connecting to the PostgreSQL server.


View source code

dbt PostgreSQL with your data warehouse

Use dbt PostgreSQL with your data warehouse or ours.

Interested in learning more?

Get in touch