Overview Quickstart dbt Compatibility The Style Guide profiles.yml sources.yml Configuration Supported Databases

REDSHIFT

Amazon's cloud data warehouse based on PostgreSQL. Designed for petabyte-scale analytics with familiar SQL syntax.

DVT SUPPORT

✓ FEDERATION SOURCE

read in federation models

✓ FEDERATION TARGET

materialize federation results

✓ DEFAULT TARGET

run full dbt projects against it

✓ SEED TARGET

dvt seed --target loads here

DVT supports Redshiftbecause both dbt and Sling do: dbt drives standard materializations when it's your default target, Sling moves data in and out during federation. Connectivity for both layers is checked with dvt debug --all.

PREREQUISITES

Driver: redshift-connector — installed automatically by:

dvt sync

CONFIGURATION FIELDS

FIELD	TYPE	REQUIRED	DEFAULT	DESCRIPTION
type	string	yes	—	Must be `redshift`
host	string	yes	—	Redshift cluster endpoint
port	integer	no	5439	Cluster port
user	string	yes	—	Database user
password	string	yes	—	Database password
dbname	string	yes	—	Database name
schema	string	no	public	Default schema
threads	integer	no	4	Number of parallel threads

PROFILES.YML EXAMPLE

my_project:
  target: rs_dev
  outputs:
    rs_dev:
      type: redshift
      host: my-cluster.abc123.us-east-1.redshift.amazonaws.com
      port: 5439
      user: admin
      password: "{{ env_var('RS_PASSWORD') }}"
      dbname: analytics
      schema: public

SOURCES.YML EXAMPLE

sources:
  - name: aws_warehouse
    meta:
      connection: rs_dev
    schema: raw
    tables:
      - name: clickstream
      - name: transactions

DBT ADAPTER FEATURES

When Redshift is your default target, every standard dbt model runs through the official dbt adapter — all of its documented capabilities apply unchanged:

MATERIALIZATIONS

INCREMENTAL STRATEGIES

NOTABLE CONFIGS

▸sort keys
▸dist keys
▸backup tables

Official dbt Redshift adapter docs ↗

FEDERATION INCREMENTAL STRATEGIES

Strategies available when this engine is the target of a f_incremental model:

✓ Append✓ Delete+Insert✓ Merge