dbt-checks.yml

name: CI

on:
  pull_request:
    types:
      - opened
      - synchronize
    branches:
      - main   

env:
    DBT_DEFAULT_TARGET: databricks
    DBT_PROFILES_DIR: ${{ github.workspace }}/integration_tests
    DBT_PROJECT_DIR: ${{ github.workspace }}/integration_tests
    DATABRICKS_TEST_CATALOG: ${{ vars.DATABRICKS_TEST_CATALOG }} 
    DATABRICKS_TEST_SCHEMA: ${{ vars.DATABRICKS_TEST_SCHEMA }} 
    DATABRICKS_TEST_HOST: ${{ secrets.DATABRICKS_TEST_HOST }} 
    DATABRICKS_TEST_HTTP_PATH: ${{ secrets.DATABRICKS_HTTP_PATH }} 
    DATABRICKS_TEST_TOKEN: ${{ secrets.DATABRICKS_TEST_TOKEN }}

    SNOWFLAKE_TEST_ACCOUNT: ${{ secrets.SNOWFLAKE_TEST_ACCOUNT }}
    SNOWFLAKE_TEST_USER: ${{ secrets.SNOWFLAKE_TEST_USER }}
    SNOWFLAKE_TEST_PASSWORD: ${{ secrets.SNOWFLAKE_TEST_PASSWORD }}
    SNOWFLAKE_TEST_ROLE: ${{ vars.SNOWFLAKE_TEST_ROLE }}
    SNOWFLAKE_TEST_DATABASE: ${{ vars.SNOWFLAKE_TEST_DATABASE }}
    SNOWFLAKE_TEST_WAREHOUSE: ${{ vars.SNOWFLAKE_TEST_WAREHOUSE }}
    SNOWFLAKE_TEST_SCHEMA: ${{ vars.SNOWFLAKE_TEST_SCHEMA }}


jobs:
  dbt-checks:
    runs-on: ubuntu-latest

    steps:
      - name: Checkout repository
        uses: actions/checkout@v2

      - name: Set up Python
        uses: actions/setup-python@v2
        with:
          python-version: '3.8'

      - name: Install dependencies
        run: |
          python -m pip install --upgrade pip
          pip install -r ${{ github.workspace }}/integration_tests/requirements.txt

      - name: Run dbt debug for Databricks
        run: dbt debug --target databricks
          
      - name: Run dbt debug for Snowflake
        run: dbt debug --target snowflake

      - name: dbt deps
        run: dbt deps

      - name: dbt compile
        run: dbt compile