Skip to content
Run DuckDB models on a nightly schedule

Run DuckDB models on a nightly schedule #13

Sign in to view logs

Run DuckDB models on a nightly schedule

Run DuckDB models on a nightly schedule #13

Workflow file for this run

.github/workflows/run_duckdb_models.yml at da9901a
name: Run DuckDB models on a nightly schedule
on:
schedule:
- cron: 0 3 * * *
workflow_dispatch: null
env:
DBT_PROFILES_DIR: ./
jobs:
run:
runs-on: ubuntu-latest
steps:
- name: checkout
uses: actions/checkout@v4
- uses: actions/setup-python@v5
with:
python-version: '3.12'
- name: Install requirements
run: pip install -q -r requirements.txt
- name: dbt deps
run: dbt deps
- name: dbt run
run: dbt run --select duckdb --target prod_duckdb
env:
AWS_ACCESS_KEY_ID: ${{ secrets.AWS_ACCESS_KEY_ID }}
AWS_SECRET_ACCESS_KEY: ${{ secrets.AWS_SECRET_ACCESS_KEY }}
AWS_REGION: eu-central-1
MOTHERDUCK_TOKEN: ${{ secrets.MOTHERDUCK_TOKEN }}