pre_commit.yml

name: pre-commit-dbt
on:
  workflow_dispatch:
  pull_request:
    branches:
      - main

jobs:
  pre_commit_dbt:
    runs-on: ubuntu-latest

    steps:
      - name: checkout
        uses: actions/checkout@v3

      - uses: actions/setup-python@v3
        with:
          python-version: "3.9.x"
  
      - id: file_changes
        uses: trilom/file-changes-action@v1.2.4
        with:
          output: ' '

      - name: Install pre-commit
        run: python -m pip install "dbt-snowflake<1.7.0" pre-commit

      - name: Run pre-commit model checks
        env:
          SF_ACCOUNT: ${{ secrets.SF_ACCOUNT }}
          SF_USER: ${{ secrets.SF_USER }}
          SF_PASSWORD: ${{ secrets.SF_PASSWORD }}
        run: |
          mkdir ~/.dbt/
          ./.scripts/create_profile.py > ~/.dbt/profiles.yml
          pre-commit run --files ${{ steps.file_changes.outputs.files}}