dbt_run_scheduled_core #5941

	name: dbt_run_scheduled_core
	run-name: dbt_run_scheduled_core

	on:
	workflow_dispatch:
	schedule:
	# Runs "every 55 mins" (see https://crontab.guru)
	- cron: "55 * * * *"

	env:
	USE_VARS: "${{ vars.USE_VARS }}"
	DBT_PROFILES_DIR: "${{ vars.DBT_PROFILES_DIR }}"
	DBT_VERSION: "${{ vars.DBT_VERSION }}"
	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:
	dbt:
	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: Run DBT Jobs
	run: \|
	dbt run-operation dispatch_github_workflow --args "{'repo_name': 'streamline-snowflake', 'workflow_name': 'dbt_run_near_external_table_update', 'gb_id': '${{ secrets.GB_ID}}'}";
	dbt seed;
	dbt run -s tag:scheduled_core --vars "{ 'RECEIPT_MAP_LOOKBACK_HOURS': 1.25}";
	- name: Store logs
	uses: actions/upload-artifact@v3
	with:
	name: dbt-logs
	path: \|
	logs
	target

Provide feedback