dbt Redshift setup in minutes

Automate dbt Redshift from a single space with no code

dbt Redshift is a data transformation tool for analysts and engineers.

dbt Redshift allows users to transform and model data in their Redshift data warehouse using SQL and Jinja, making it easier to manage and maintain data pipelines. It provides a modular and version-controlled approach to data transformation, allowing teams to collaborate and iterate on data models. With dbt Redshift, users can create and manage complex data transformations, automate data pipelines, and ensure data accuracy and consistency.

Settings

Skip Pre-invoke

Whether to skip pre-invoke checks

dbt Profile type

The type of dbt profile being used

Project Directory

The directory where the dbt project is located

Profiles Directory

The directory where the dbt profiles are located

Authentication Method

The method used for authentication

Cluster ID

The ID of the Redshift cluster

Host

The hostname or IP address of the Redshift cluster

Password

The password for the Redshift cluster

User

The username for the Redshift cluster

Port

The port number for the Redshift cluster

Database

The name of the Redshift database

Schema

The name of the Redshift schema

IAM Profile

The name of the AWS IAM profile to use for authentication

IAM Duration Seconds

The duration of the AWS IAM session in seconds

Autocreate

Whether to automatically create the Redshift schema if it does not exist

Databse Groups

The database groups to use for the Redshift cluster

Keep Alives Idle

The number of seconds to wait before sending a keep-alive message

Search Path

The search path to use for the Redshift cluster

SSL Mode

The SSL mode to use for the Redshift cluster

RA3 Node

The type of RA3 node to use for the Redshift cluster