run_unit_tests_on_pr.yml

name: Run Unit Tests on Pull Request

# on: [pull_request_target,workflow_dispatch]
on:
  push:
    branches:
      - 'feature/add_dbt_unit_tests'
env:
  BIGQUERY_PROJECT: ${{ secrets.BIGQUERY_PROJECT }}
  BIGQUERY_PROPERTY_ID: ${{ secrets.BIGQUERY_PROPERTY_ID }}
  BIGQUERY_DATASET: ${{ secrets.BIGQUERY_DATASET }}
  BIGQUERY_KEYFILE: ./unit_tests/dbt-service-account.json

jobs:
  pytest_run_all:
    name: Pytest Run All
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./unit_tests
    steps:
      - name: Check out
        uses: actions/checkout@v3
        with:
          ref: ${{ github.event.pull_request.head.sha }}

      - uses: actions/setup-python@v1
        with:
          python-version: "3.11.x"

      - name: Authenticate using service account
        run: 'echo "$KEYFILE" > ./dbt-service-account.json'
        shell: bash
        env:
          KEYFILE: ${{secrets.GCP_BIGQUERY_USER_KEYFILE}}

      - name: Install dependencies
        run: |
          pip install dbt-core
          pip install dbt-bigquery
          pip install pytest
      
      - name: Run tests
        run: python -m pytest .

  run_dbt_unit_tests:
    name: Run dbt Unit Tests
    runs-on: ubuntu-latest
    steps:
      - name: Check out
        uses: actions/checkout@v3
        with:
          ref: ${{ github.event.pull_request.head.sha }}

      - uses: actions/setup-python@v1
        with:
          python-version: "3.11.x"

      - name: Authenticate using service account
        run: 'echo "$KEYFILE" > ./unit_tests/dbt-service-account.json'
        shell: bash
        env:
          KEYFILE: ${{ secrets.GCP_BIGQUERY_USER_KEYFILE }}

      - name: Install dbt
        run: |
          pip install dbt-core
          pip install dbt-bigquery
          dbt deps

      - name: Run dbt unit tests
        run: dbt test -s test_type:unit