Overview Quickstart CLI Commands .sql Models .py Models profiles.yml sources.yml Execution Paths

REDSHIFT

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

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
    connection: rs_dev
    schema: raw
    tables:
      - name: clickstream
      - name: transactions

INCREMENTAL STRATEGIES

✓ Append✓ Delete+Insert✓ Merge