dbt_test.yml

name: Test DBT package

on:
  push:
    branches: [ "main", "develop" ]

permissions:
  contents: read

defaults:
  run:
    working-directory: integration_tests

jobs:
  test-duckdb:
    name: Test on DuckDB
    runs-on: ubuntu-latest
    strategy:
      matrix:
        python-version: ["3.9", "3.10", "3.11"]

    env:
      DBT_TARGET: duckdb

    steps:
    - uses: actions/checkout@v4
    - name: Set up Python ${{ matrix.python-version }}
      uses: actions/setup-python@v4
      with:
        python-version: ${{ matrix.python-version }}

    - name: pip install
      run: pip install dbt-core duckdb dbt-${DBT_TARGET}

    - name: Install DBT deps
      run: dbt deps --target ${DBT_TARGET}
      
    - name: load test data
      run: dbt seed --target ${DBT_TARGET}

    - name: Create seed tests
      run: bash tests/create_seeds_tests_yml.sh

    - name: dbt test
      run: dbt test --target ${DBT_TARGET}

  test-postgres:
    name: Test on Postgres
    runs-on: ubuntu-latest
    container:
      image: python:3.11

    services:
      postgres:
        image: postgres
        env:
          POSTGRES_PASSWORD: postgres

    env:
      DBT_TARGET: postgres

    steps:
    - uses: actions/checkout@v4

    - name: pip install
      run: pip install dbt-core dbt-${DBT_TARGET}

    - name: Install DBT deps
      run: dbt deps --target ${DBT_TARGET}
      
    - name: load test data
      run: dbt seed --target ${DBT_TARGET}

    - name: Create seed tests
      run: bash tests/create_seeds_tests_yml.sh

    - name: dbt test
      run: dbt test --target ${DBT_TARGET}

  test-snowflake:
    name: Test on Snowflake
    runs-on: ubuntu-latest
    container:
      image: python:3.11

    env:
      SNOWFLAKE_PASSWORD: ${{ secrets.SNOWFLAKE_PASSWORD }}
      DBT_TARGET: snowflake

    steps:
    - uses: actions/checkout@v4

    - name: pip install
      run: pip install dbt-core dbt-${DBT_TARGET}

    - name: Install DBT deps
      run: dbt deps --target ${DBT_TARGET}
      
    - name: load test data
      run: dbt seed --target ${DBT_TARGET}

    - name: Create seed tests
      run: bash tests/create_seeds_tests_yml.sh

    - name: dbt test
      run: dbt test --target ${DBT_TARGET}

  test-redshift:
    name: Test on RedShift
    runs-on: ubuntu-latest
    container:
      image: python:3.11

    env:
      SNOWFLAKE_PASSWORD: ${{ secrets.REDSHIFT_PASSWORD }}
      DBT_TARGET: redshift

    steps:
    - uses: actions/checkout@v4

    - name: pip install
      run: pip install dbt-core dbt-${DBT_TARGET}

    - name: Install DBT deps
      run: dbt deps --target ${DBT_TARGET}
      
    - name: load test data
      run: dbt seed --target ${DBT_TARGET}

    - name: Create seed tests
      run: bash tests/create_seeds_tests_yml.sh

    - name: dbt test
      run: dbt test --target ${DBT_TARGET}