ci.yml

name: dbt Cloud CI
on:
  pull_request:
    branches:
      - main
      - staging
jobs:
  run_snowflake:
    name: dbt Cloud PR CI Snowflake
    runs-on: macos-latest

    env:
      DBT_ACCOUNT_ID: 188483
      DBT_PROJECT_ID: 283328
      DBT_PR_JOB_ID: 552843
      DBT_API_KEY: ${{ secrets.DBT_CLOUD_API_KEY }}
      DBT_JOB_CAUSE: "GitHub Actions Request"
      DBT_JOB_BRANCH: ${{ github.head_ref }}
      DBT_JOB_SCHEMA_OVERRIDE: dbt_jsdx__pr_${{ github.head_ref}}

    steps:
      - uses: "actions/checkout@v4"
      - uses: "actions/setup-python@v5"
        with:
          python-version: "3.12"
      - name: Install uv
        run: python3 -m pip install uv
      - name: Install deps
        run: uv pip install -r requirements.txt --system
      - name: Run dbt Cloud job
        run: python3 .github/workflows/scripts/dbt_cloud_run_job.py

  run_bigquery:
    name: dbt Cloud PR CI BigQuery
    runs-on: macos-latest

    env:
      DBT_ACCOUNT_ID: 188483
      DBT_PROJECT_ID: 275557
      DBT_PR_JOB_ID: 561096
      DBT_API_KEY: ${{ secrets.DBT_CLOUD_API_KEY }}
      DBT_JOB_CAUSE: "GitHub Actions Request"
      DBT_JOB_BRANCH: ${{ github.head_ref }}
      DBT_JOB_SCHEMA_OVERRIDE: dbt_jsdx__pr_${{ github.head_ref}}

    steps:
      - uses: "actions/checkout@v4"
      - uses: "actions/setup-python@v5"
        with:
          python-version: "3.12"
      - name: Install uv
        run: python3 -m pip install uv
      - name: Install deps
        run: uv pip install -r requirements.txt --system
      - name: Run dbt Cloud job
        run: python3 .github/workflows/scripts/dbt_cloud_run_job.py

  run_postgres:
    name: dbt Cloud PR CI Postgres
    runs-on: macos-latest

    env:
      DBT_ACCOUNT_ID: 188483
      DBT_PROJECT_ID: 288405
      DBT_PR_JOB_ID: 577887
      DBT_API_KEY: ${{ secrets.DBT_CLOUD_API_KEY }}
      DBT_JOB_CAUSE: "GitHub Actions Request"
      DBT_JOB_BRANCH: ${{ github.head_ref }}
      DBT_JOB_SCHEMA_OVERRIDE: dbt_jsdx__pr_${{ github.head_ref}}

    steps:
      - uses: "actions/checkout@v4"
      - uses: "actions/setup-python@v5"
        with:
          python-version: "3.12"
      - name: Install uv
        run: python3 -m pip install uv
      - name: Install deps
        run: uv pip install -r requirements.txt --system
      - name: Run dbt Cloud job
        run: python3 .github/workflows/scripts/dbt_cloud_run_job.py