-
Notifications
You must be signed in to change notification settings - Fork 0
74 lines (61 loc) · 1.95 KB
/
python-app.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
name: dbt_orchestration
on:
push:
branches:
- main
schedule:
- cron: "0 0 * * *"
env:
DBT_PROFILES_DIR: ./
DBT_GOOGLE_PROJECT: ${{ vars.DBT_GOOGLE_PROJECT }}
DBT_GOOGLE_BIGQUERY_DATASET: ${{ vars.DBT_GOOGLE_BIGQUERY_DATASET }}
DBT_GOOGLE_BIGQUERY_KEYFILE: ../dbt_transformation/.gcloud/dbt-service-account.json
jobs:
dbt_orchestration:
name: dbt_orchestration
runs-on: ubuntu-latest
steps:
- name: Check out
uses: actions/checkout@v3
- uses: actions/setup-python@v3
with:
python-version: "3.11.8"
- name: Authenticate using service account
run: |
mkdir -p ./dbt_transformation/.gcloud/
echo "$KEYFILE_CONTENTS" > ./dbt_transformation/.gcloud/dbt-service-account.json
shell: bash
env:
KEYFILE_CONTENTS: ${{ secrets.DBT_GOOGLE_BIGQUERY_KEYFILE }}
- name: Install python dependencies
run: |
python -m pip install --upgrade pip
if [ -f requirements.txt ]; then pip install -r requirements.txt; fi
- name: Debugging Output
run: |
ls -al ./dbt_transformation/.gcloud/
cat ./dbt_transformation/.gcloud/dbt-service-account.json
- name: Run dbt debug
working-directory: ./dbt_transformation
run: |
dbt debug
- name: Install dbt dependencies
working-directory: ./dbt_transformation
run: |
dbt deps
- name: Run dbt seed
working-directory: ./dbt_transformation
run: |
dbt seed --target dev
- name: Test dbt model
working-directory: ./dbt_transformation
run: |
dbt test --target dev
- name: Run dbt model
working-directory: ./dbt_transformation
run: |
dbt run --target dev
- name: Generate dbt documentation
working-directory: ./dbt_transformation
run: |
dbt docs generate --target dev