ci-check.yml

name: ci check

on:
  pull_request:

# Automatically cancel any previous runs of this workflow
concurrency:
  group: ${{ github.workflow }}-${{ github.ref }}
  cancel-in-progress: true

jobs:
  ci-checks:
    runs-on: ubuntu-latest
    defaults:
      run:
        working-directory: ./integration_tests
    env:
      SNOWFLAKE_ACCOUNT: ${{ secrets.SNOWFLAKE_ACCOUNT }}
      SNOWFLAKE_USER_CI: ${{ secrets.SNOWFLAKE_CI_USER }}
      SNOWFLAKE_PASSWORD_CI: ${{ secrets.SNOWFLAKE_CI_USER_PASSWORD }}
      SNOWFLAKE_DATABASE_CI: ${{ secrets.SNOWFLAKE_CI_DATABASE }}
      SNOWFLAKE_ROLE_CI: ${{ secrets.SNOWFLAKE_CI_ROLE }}
      SNOWFLAKE_WAREHOUSE_CI: ${{ secrets.SNOWFLAKE_CI_WAREHOUSE }}
      SNOWFLAKE_SCHEMA_CI: DBT_CI_${{github.event.number}}_${{ github.actor }} # Creates a unique schema for each PR
    steps:
      - name: Checkout branch
        id: checkout-branch
        uses: actions/checkout@v3

      - name: Install Poetry
        id: install-poetry
        run: |
          pipx install poetry

      - name: setup-python
        id: setup-python
        uses: actions/setup-python@v4
        with:
          python-version: "3.10"
          cache: 'poetry' # Auto cache based on poetry.lock

      - name: Install python deps
        id: install-python-deps
        run: |
          poetry install

      - name: Install dbt deps
        id: install-dbt-deps
        run: |
          poetry run dbt deps

      - name: Check dbt compiles and CI Profiles work
        id: check-dbt-compiles-and-ci-profiles-work
        run: |
          poetry run dbt compile --target snowflake-ci
          poetry run dbt debug --target snowflake-ci

      - name: dbt build on Snowflake
        id: dbt-build-snowflake
        run: |
          potery run dbt build --full-refresh --target snowflake-ci