Skip to content

Dqi mart updates

Dqi mart updates #339

name: dbt_v1.6.3_snowflake_build_full_claims
on:
workflow_dispatch:
pull_request:
branches:
- main
env:
DBT_TUVA_SNOWFLAKE_ACCOUNT: ${{ secrets.DBT_TUVA_SNOWFLAKE_ACCOUNT }}
DBT_TUVA_CI_DATABASE: ${{ secrets.DBT_TUVA_CI_DATABASE }}
DBT_SNOWFLAKE_CI_PASSWORD: ${{ secrets.DBT_SNOWFLAKE_CI_PASSWORD }}
DBT_SNOWFLAKE_CI_ROLE: ${{ secrets.DBT_SNOWFLAKE_CI_ROLE }}
DBT_SNOWFLAKE_CI_SCHEMA: ${{ secrets.DBT_SNOWFLAKE_CI_SCHEMA }}
DBT_SNOWFLAKE_CI_USER: ${{ secrets.DBT_SNOWFLAKE_CI_USER }}
DBT_SNOWFLAKE_CI_WAREHOUSE: ${{ secrets.DBT_SNOWFLAKE_CI_WAREHOUSE }}
jobs:
clinical_and_claims_enabled:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v2
- name: dbt-deps
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt deps --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-debug
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt debug --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-build
uses: mwhitaker/[email protected]
with:
dbt_command: 'dbt build --full-refresh --profiles-dir ./profiles/snowflake --vars {"input_database":"dev_ci_testing","input_schema":"input_layer","clinical_enabled":true,"claims_enabled":true}'
dbt_project_folder: "ci_testing"
- name: Get the result
if: ${{ always() }}
run: echo "${{ steps.dbt-build.outputs.result }}"
shell: bash
claims_enabled:
runs-on: ubuntu-latest
needs: clinical_and_claims_enabled
steps:
- uses: actions/checkout@v2
- name: dbt-deps
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt deps --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-debug
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt debug --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-build
uses: mwhitaker/[email protected]
with:
dbt_command: 'dbt run --profiles-dir ./profiles/snowflake --vars {"input_database":"dev_ci_testing","input_schema":"input_layer","claims_enabled":true}'
dbt_project_folder: "ci_testing"
- name: Get the result
if: ${{ always() }}
run: echo "${{ steps.dbt-build.outputs.result }}"
shell: bash
clinical_enabled:
runs-on: ubuntu-latest
needs: claims_enabled
steps:
- uses: actions/checkout@v2
- name: dbt-deps
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt deps --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-debug
uses: mwhitaker/[email protected]
with:
dbt_command: "dbt debug --profiles-dir ./profiles/snowflake"
dbt_project_folder: "ci_testing"
- name: dbt-build
uses: mwhitaker/[email protected]
with:
dbt_command: 'dbt run --profiles-dir ./profiles/snowflake --vars {"input_database":"dev_ci_testing","input_schema":"input_layer","clinical_enabled":true}'
dbt_project_folder: "ci_testing"
- name: Get the result
if: ${{ always() }}
run: echo "${{ steps.dbt-build.outputs.result }}"
shell: bash