valbonne_models_run #61

	name: valbonne_models_run

	on:
	workflow_dispatch:
	schedule:
	- cron: '0 5 * * *'

	env:
	DBNAME: ${{ secrets.valbonne_DBNAME_PROD }}
	HOST: ${{ secrets.HOST }}
	PASSWORD: ${{ secrets.PASSWORD }}
	PORT: ${{ secrets.PORT }}
	TARGET_SCHEMA: ${{ secrets.SCHEMA_PROD }}
	USER: ${{ secrets.USER }}
	PARTICIPATION_HOST_NAME: ${{ secrets.VALBONNE_PARTICIPATION_HOST_NAME }}
	WORKING_DIRECTORY: ./projects/valbonne


	jobs:
	valbonne_models_run:
	name: valbonne_models_run
	runs-on: ubuntu-latest
	defaults:
	run:
	working-directory: ${{ env.WORKING_DIRECTORY }}

	steps:
	- name: Check out
	uses: actions/checkout@master

	- name: Setup Python
	uses: actions/setup-python@v5
	with:
	python-version: "3.12.x"
	cache: 'pip'

	- name: Install dependencies
	run: \|
	pip install -r requirements.txt
	dbt deps --target prod

	- name: Run dbt models
	run: dbt run --target prod

	- name: Test dbt models
	run: dbt test --target prod

Provide feedback