🧃 SQLMesh Bot 🧃 #15
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 | |
# Required if using comments to issue commands to the bot | |
issue_comment: | |
types: | |
- created | |
# Required if using required approvers to automate deployments | |
# pull_request_review: | |
# types: | |
# - edited | |
# - submitted | |
# - dismissed | |
# 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 | |
steps: | |
- name: Setup Python | |
uses: actions/setup-python@v4 | |
- name: Checkout PR branch | |
uses: actions/checkout@v4 | |
with: | |
ref: refs/pull/${{ github.event.issue.pull_request && github.event.issue.number || github.event.pull_request.number }}/merge | |
- name: Install SQLMesh + Dependencies | |
run: pip install -r requirements.txt | |
shell: bash | |
- name: Run CI/CD Bot | |
run: | | |
sqlmesh_cicd -p ${{ github.workspace }} github --token ${{ secrets.GITHUB_TOKEN }} run-all | |
env: # TODO: update your GitHub secrets to include SQLMESH_STATE_HOST, SQLMESH_STATE_USERNAME, SQLMESH_STATE_PASSWORD | |
SQLMESH_STATE_HOST: ${{ secrets.SQLMESH_STATE_HOST }} | |
SQLMESH_STATE_USERNAME: ${{ secrets.SQLMESH_STATE_USERNAME }} | |
SQLMESH_STATE_PASSWORD: ${{ secrets.SQLMESH_STATE_PASSWORD }} | |
GOOGLE_CREDENTIALS: ${{ secrets.GOOGLE_CREDENTIALS }} |