dbt_run_operation_reorg #1179
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
name: dbt_run_operation_reorg | |
run-name: dbt_run_operation_reorg | |
on: | |
workflow_dispatch: | |
schedule: | |
# Runs at minute 40 every 8 hours (see https://crontab.guru) | |
- cron: '40 */8 * * *' | |
env: | |
DBT_PROFILES_DIR: ./ | |
ACCOUNT: "${{ vars.ACCOUNT }}" | |
ROLE: "${{ vars.ROLE }}" | |
USER: "${{ vars.USER }}" | |
PASSWORD: "${{ secrets.PASSWORD }}" | |
REGION: "${{ vars.REGION }}" | |
DATABASE: "${{ vars.DATABASE }}" | |
WAREHOUSE: "${{ vars.WAREHOUSE }}" | |
SCHEMA: "${{ vars.SCHEMA }}" | |
concurrency: | |
group: ${{ github.workflow }} | |
jobs: | |
run_dbt_jobs: | |
runs-on: ubuntu-latest | |
environment: | |
name: workflow_prod | |
steps: | |
- uses: actions/checkout@v3 | |
- uses: actions/setup-python@v4 | |
with: | |
python-version: "3.10" | |
cache: "pip" | |
- name: install dependencies | |
run: | | |
pip install -r requirements.txt | |
dbt deps | |
- name: List reorg models | |
id: list_models | |
run: | | |
reorg_model_list=$(dbt list --select "gnosis_models,tag:reorg" --resource-type model --output name | grep '__' | awk -F'.' '{print $NF}' | tr '\n' ',' | sed 's/,$//') | |
echo "model_list=$reorg_model_list" >> $GITHUB_OUTPUT | |
- name: Execute block_reorg macro | |
run: | | |
dbt run-operation fsc_utils.block_reorg --args "{reorg_model_list: '${{ steps.list_models.outputs.model_list }}', hours: '12'}" && awk '/SQL status/ {print; next} /DELETE FROM/{getline; print} /\/\* {/ {print}' logs/dbt.log | |
- name: Execute decoded_logs_cleanup macro | |
run: | | |
dbt run-operation decoded_logs_cleanup |