dbt Run #151

	name: dbt Run

	on:
	schedule:
	- cron: "0 8 * * *"

	jobs:
	run_dbt:
	name: Run dbt
	runs-on: ubuntu-latest
	permissions:
	id-token: write
	contents: write
	steps:
	- uses: actions/checkout@v3
	- name: Set up Python
	uses: actions/setup-python@v4
	with:
	python-version: '3.9'

	- name: Install dependencies
	run: \|
	python -m pip install --upgrade pip
	pip install -r requirements.txt

	- name: Install dbt dependencies
	run: cd levergreen_dbt && dbt deps

	- name: Run dbt models
	run: cd levergreen_dbt && dbt run
	env:
	PG_DATABASE: ${{ secrets.PG_DATABASE }}
	PG_HOST: ${{ secrets.PG_HOST }}
	PG_PASSWORD: ${{ secrets.PG_PASSWORD }}
	PG_USER: ${{ secrets.PG_USER }}

	- name: Test dbt models
	run: cd levergreen_dbt && dbt test
	env:
	PG_DATABASE: ${{ secrets.PG_DATABASE }}
	PG_HOST: ${{ secrets.PG_HOST }}
	PG_PASSWORD: ${{ secrets.PG_PASSWORD }}
	PG_USER: ${{ secrets.PG_USER }}

	- name: Check Freshness of dbt models
	run: cd levergreen_dbt && dbt source freshness
	env:
	PG_DATABASE: ${{ secrets.PG_DATABASE }}
	PG_HOST: ${{ secrets.PG_HOST }}
	PG_PASSWORD: ${{ secrets.PG_PASSWORD }}
	PG_USER: ${{ secrets.PG_USER }}

Provide feedback