ci.yml

# **what?**
# Run tests for dbt-external-tables against supported adapters

# **why?**
# To ensure that dbt-external-tables works as expected with all supported adapters

# **when?**
# On every PR, and every push to main and when manually triggered

name: Package Integration Tests

on:
    push:
        branches:
            - main
    pull_request:
    workflow_dispatch:

# setting as env vars because the reusable workflow doesn't understand the secrets context
env:
    REDSHIFT_HOST: ${{ secrets.REDSHIFT_TEST_HOST }}
    REDSHIFT_USER: ${{ secrets.REDSHIFT_TEST_USER }}
    REDSHIFT_PORT: ${{ secrets.REDSHIFT_TEST_PORT }}
    REDSHIFT_DATABASE: ${{ secrets.REDSHIFT_TEST_DBNAME }}
    SNOWFLAKE_USER: ${{ secrets.SNOWFLAKE_TEST_USER }}
    SNOWFLAKE_WAREHOUSE: ${{ secrets.SNOWFLAKE_TEST_WHNAME }}
    SNOWFLAKE_ROLE: ${{ secrets.SNOWFLAKE_TEST_ROLE }}
    SNOWFLAKE_DATABASE: ${{ secrets.SNOWFLAKE_TEST_DBNAME }}

jobs:
  run-tests:
      uses: dbt-labs/dbt-package-testing/.github/workflows/run_tox.yml@v1
      with:
        # redshift
        REDSHIFT_HOST: ${{ env.REDSHIFT_TEST_HOST }}
        REDSHIFT_USER: ${{ env.REDSHIFT_TEST_USER }}
        REDSHIFT_PORT: ${{ env.REDSHIFT_TEST_PORT }}
        REDSHIFT_DATABASE: ${{ env.REDSHIFT_TEST_DBNAME }}
        REDSHIFT_SCHEMA: "integration_tests_redshift_${{ github.run_number }}"
         # snowflake
        SNOWFLAKE_USER: ${{ env.SNOWFLAKE_TEST_USER }}
        SNOWFLAKE_WAREHOUSE: ${{ env.SNOWFLAKE_TEST_WHNAME }}
        SNOWFLAKE_ROLE: ${{ env.SNOWFLAKE_TEST_ROLE }}
        SNOWFLAKE_DATABASE: ${{ env.SNOWFLAKE_TEST_DBNAME }}
        SNOWFLAKE_SCHEMA: "integration_tests_snowflake_${{ github.run_number }}"
      secrets:
        DBT_ENV_SECRET_REDSHIFT_PASS: ${{ secrets.REDSHIFT_TEST_PASS }}
        SNOWFLAKE_ACCOUNT: ${{ secrets.SNOWFLAKE_TEST_ACCOUNT }}
        DBT_ENV_SECRET_SNOWFLAKE_PASS: ${{ secrets.SNOWFLAKE_TEST_PASS }}