Skip to content

tours_models_run

tours_models_run #11

name: tours_models_run
on:
workflow_dispatch:
schedule:
- cron: '0 8 * * *'
env:
DBNAME: ${{ secrets.TOURS_DBNAME_PROD }}
HOST: ${{ secrets.HOST }}
PASSWORD: ${{ secrets.PASSWORD }}
PORT: ${{ secrets.PORT }}
TARGET_SCHEMA: ${{ secrets.SCHEMA_PROD }}
USER: ${{ secrets.USER }}
PARTICIPATION_HOST_NAME: ${{ secrets.TOURS_PARTICIPATION_HOST_NAME }}
WORKING_DIRECTORY: ./projects/tours
jobs:
tours_models_run:
name: tours_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