🚀SQLMesh Bot 🚀 #13
Workflow file for this run
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| name: SQLMesh Bot | |
| run-name: 🚀SQLMesh Bot 🚀 | |
| on: | |
| pull_request: | |
| types: | |
| - synchronize | |
| - opened | |
| - closed | |
| # The latest commit is the one that will be used to create the PR environment and deploy to production | |
| concurrency: | |
| group: ${{ github.workflow }}-${{ github.head_ref || github.ref_name }} | |
| cancel-in-progress: true | |
| jobs: | |
| sqlmesh: | |
| name: SQLMesh Actions Workflow | |
| runs-on: ubuntu-latest | |
| permissions: | |
| # Required to access code in PR | |
| contents: write | |
| # Required to post comments | |
| issues: write | |
| # Required to update check runs | |
| checks: write | |
| # Required to merge | |
| pull-requests: write | |
| env: | |
| SQLMESH__GATEWAYS__SNOWFLAKE__CONNECTION__USER: ${{ secrets.SQLMESH__GATEWAYS__SNOWFLAKE__CONNECTION__USER }} | |
| SQLMESH__GATEWAYS__SNOWFLAKE__CONNECTION__PASSWORD: ${{ secrets.SQLMESH__GATEWAYS__SNOWFLAKE__CONNECTION__PASSWORD }} | |
| steps: | |
| - name: Setup Python | |
| uses: actions/setup-python@v4 | |
| - name: Checkout PR branch | |
| uses: actions/checkout@v4 | |
| # Add if statement so we don't checkout merged PR but instead main branch | |
| if: github.event.pull_request.merged == false | |
| with: | |
| ref: refs/pull/${{ github.event.issue.pull_request && github.event.issue.number || github.event.pull_request.number }}/merge | |
| - name: Checkout main branch | |
| # Add if statement so we use main when merged | |
| if: github.event.pull_request.merged == true | |
| uses: actions/checkout@v4 | |
| with: | |
| ref: main | |
| - name: Install SQLMesh + Dependencies | |
| run: pip install -r requirements.txt | |
| shell: bash | |
| - name: Run CI/CD Bot | |
| # Add if statement so we don't run-all on merged PR | |
| if: github.event.pull_request.merged == false | |
| run: | | |
| sqlmesh_cicd -p ${{ github.workspace }}/transform github --token ${{ secrets.GITHUB_TOKEN }} run-all | |
| - name: Deploy to Production | |
| # `main` should be the name of your branch that represents production | |
| if: github.event.pull_request.merged == true && github.event.pull_request.base.ref == 'main' | |
| run: | | |
| sqlmesh_cicd -p ${{ github.workspace }}/transform github --token ${{ secrets.GITHUB_TOKEN }} deploy-production |