column_aware_ci.yml

name: Column Aware CI

on:
  workflow_dispatch:
  pull_request:
    branches:
      - main
    types:
      - opened
      - reopened
      - synchronize
      - ready_for_review

jobs:
  trigger-dbt-ci-job:
    if: github.event.pull_request.draft == false
    runs-on: ubuntu-latest
    env:
      DBT_CLOUD_SERVICE_TOKEN: ${{ secrets.DBT_CLOUD_SERVICE_TOKEN }}
      DBT_CLOUD_API_KEY: ${{ secrets.DBT_CLOUD_API_KEY }}
      DBT_CLOUD_ACCOUNT_ID: ${{ secrets.DBT_CLOUD_ACCOUNT_ID }}
      DBT_CLOUD_PROJECT_ID: ${{ secrets.DBT_CLOUD_PROJECT_ID }}
      DBT_CLOUD_PROJECT_NAME: "Main"
      DBT_CLOUD_ACCOUNT_NAME: "Doug Sandbox"
      DBT_CLOUD_JOB_ID: 567183
      DBT_CLOUD_HOST: cloud.getdbt.com
      GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
      
    steps:
    - uses: actions/checkout@v3
    - uses: actions/setup-python@v4
      with:
        python-version: "3.11"
    - uses: yezz123/setup-uv@v4
    - name: Install packages
      run: |
        pip install dbt dbtc pyyaml sqlglot
      env:
        UV_SYSTEM_PYTHON: 1

    - name: Trigger DBT Cloud Job
      run: |
        mkdir ~/.dbt/
        uv run scripts/create_profile.py > ~/.dbt/dbt_cloud.yml
        uv run scripts/column_aware_ci.py