# dbt-labs/dbt-redshift architecture

> Architecture diagram of the GitHub repository dbt-labs/dbt-redshift, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2025-06-27). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/dbt-labs/dbt-redshift
- Repository: https://github.com/dbt-labs/dbt-redshift

## Overview

##### Project type and purpose
- This is a plugin-style adapter library (“dbt-redshift”) for the core dbt (data build tool) framework.
- Its purpose is to implement the adapter interface so that dbt projects can compile, execute, and manage models on Amazon Redshift.

##### File structure
- Top-level “dbt/adapters/redshift” folder: the Python implementation of the adapter, including connection logic, relation objects, and SQL compilation.
- “dbt/include/redshift”: SQL macros and materializations that dbt injects when generating queries for Redshift.
- “docker/”: Dockerfiles for building containerized environments for development/testing.
- “scripts/”: helper shell scripts for environment setup and packaging.
- “tests/”: pytest-based suites—unit tests, boundary tests, functional adapter tests—organized by scope.
- CI/CD files under “.github/workflows” orchestrate linting, testing, and release.

##### README for additional insights
- Confirms this repo is the Redshift adapter within the larger dbt-adapters monorepo.

## Diagram (Mermaid)

```mermaid
flowchart TB
    %% External component
    dbtCore["dbt Core Engine"]:::external

    %% Adapter Library
    subgraph "Redshift Adapter Library"
        direction TB
        RA["dbt/adapters/redshift/"]:::code
        Auth["auth_providers.py"]:::code
        Conn["connections.py"]:::code
        Impl["impl.py"]:::code
        Rel["relation.py"]:::code
        RelCfg["relation_configs/"]:::code
        Util["utility.py"]:::code

        subgraph "Relation Configs"
            direction TB
            Base["base.py"]:::code
            Dist["dist.py"]:::code
            MatView["materialized_view.py"]:::code
            Policies["policies.py"]:::code
            Sort["sort.py"]:::code
        end

        RA --> Auth
        RA --> Conn
        RA --> Impl
        RA --> Rel
        RA --> RelCfg
        RA --> Util
        RelCfg --> Base
        RelCfg --> Dist
        RelCfg --> MatView
        RelCfg --> Policies
        RelCfg --> Sort
    end

    %% SQL Macros
    subgraph "SQL Macros & Materializations"
        direction TB
        SIM["dbt/include/redshift/"]:::code
        Macros["macros/"]:::code
    end

    %% Redshift Cluster
    RedshiftDB["Amazon Redshift Cluster"]:::db

    %% Development & Test Harness
    subgraph "Dev & Test Harness"
        direction TB
        Docker["docker/"]:::infra
        Pytest["tests/"]:::infra
    end

    %% CI/CD Pipeline
    CI["GitHub Actions CI/CD"]:::infra

    %% Packaging & Release
    subgraph "Packaging & Release"
        direction TB
        Scripts["scripts/"]:::infra
        Hatch["hatch.toml / pyproject.toml"]:::infra
    end

    %% Relationships
    dbtCore -->|"loads plugin"| RA
    RA -->|"uses macros at compile time"| SIM
    RA -->|"executes SQL on"| RedshiftDB
    RedshiftDB -->|"returns results & metadata"| dbtCore

    Pytest -->|"tests adapter in"| Docker
    Pytest -->|"exercises"| RA

    CI -->|"runs tests in"| Docker
    CI -->|"runs Pytest suites"| Pytest
    CI -->|"invokes"| Scripts

    Scripts -->|"packages adapter / builds Docker"| Hatch

    %% Click Events
    click RA "https://github.com/dbt-labs/dbt-redshift/tree/main/dbt/adapters/redshift/"
    click Auth "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/auth_providers.py"
    click Conn "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/connections.py"
    click Impl "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/impl.py"
    click Rel "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation.py"
    click RelCfg "https://github.com/dbt-labs/dbt-redshift/tree/main/dbt/adapters/redshift/relation_configs/"
    click Base "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation_configs/base.py"
    click Dist "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation_configs/dist.py"
    click MatView "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation_configs/materialized_view.py"
    click Policies "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation_configs/policies.py"
    click Sort "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/relation_configs/sort.py"
    click Util "https://github.com/dbt-labs/dbt-redshift/blob/main/dbt/adapters/redshift/utility.py"
    click SIM "https://github.com/dbt-labs/dbt-redshift/tree/main/dbt/include/redshift/"
    click Macros "https://github.com/dbt-labs/dbt-redshift/tree/main/dbt/include/redshift/macros/"
    click Docker "https://github.com/dbt-labs/dbt-redshift/tree/main/docker/"
    click Pytest "https://github.com/dbt-labs/dbt-redshift/tree/main/tests/"
    click CI "https://github.com/dbt-labs/dbt-redshift/tree/main/.github/workflows/"
    click Scripts "https://github.com/dbt-labs/dbt-redshift/tree/main/scripts/"

    %% Styles
    classDef code fill:#cce5ff,stroke:#004085
    classDef db fill:#d4edda,stroke:#155724
    classDef infra fill:#fff3cd,stroke:#856404
    classDef external fill:none,stroke:#999,stroke-dasharray: 5 5
```
