Merge pull request #159 from get-select/remove_stg_warehouse_events_h… #124

	name: Main branch test package

	# triggers for the workflow
	on:
	workflow_dispatch:
	push:
	branches:
	- main

	env:
	# These are configured in GitHub secrets
	DBT_PROFILES_DIR: /home/runner/work/${{ github.event.repository.name }}/${{ github.event.repository.name }}/integration_test_project
	GITHUB_SHA_OVERRIDE: ${{ github.event.pull_request.head.sha }} # We need the commit hash of the pull request branch's head, the GITHUB_SHA env var is always the base branch in a pull_request_target trigger
	DBT_ENV_SECRET_SNOWFLAKE_TEST_ACCOUNT: ${{ secrets.SNOWFLAKE_TEST_ACCOUNT }}
	DBT_ENV_SECRET_SNOWFLAKE_TEST_USER: ${{ secrets.SNOWFLAKE_TEST_USER }}
	DBT_ENV_SECRET_SNOWFLAKE_TEST_PASSWORD: ${{ secrets.SNOWFLAKE_TEST_PASSWORD }}
	DBT_ENV_SECRET_SNOWFLAKE_TEST_ROLE: ${{ secrets.SNOWFLAKE_TEST_ROLE }}
	DBT_ENV_SECRET_SNOWFLAKE_TEST_DATABASE: ${{ secrets.SNOWFLAKE_TEST_DATABASE }}
	DBT_ENV_SECRET_SNOWFLAKE_TEST_WAREHOUSE: ${{ secrets.SNOWFLAKE_TEST_WAREHOUSE }}

	jobs:
	integration-snowflake:
	runs-on: ubuntu-latest

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

	- name: Install tox
	run: python3 -m pip install tox

	- name: Run Snowflake Integration Tests
	run: tox -e integration_snowflake

	- name: Run Snowflake Tests
	run: tox -e snowflake

	sqlfluff-lint-models:
	name: Lint dbt models using SQLFluff
	runs-on: ubuntu-latest

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

	- name: Install tox
	run: python3 -m pip install tox

	- name: Lint dbt models
	run: tox -e lint_all

Provide feedback