generated from dbt-labs/jaffle-shop-template
-
Notifications
You must be signed in to change notification settings - Fork 68
66 lines (58 loc) · 2.47 KB
/
metrics_ci.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
name: Metrics Validation
on:
push:
branches:
- main # Change this to the branch you want to trigger the action on
pull_request:
branches:
- main # Change this to the branch you want to trigger the action on
jobs:
setup-dbt-cloud-profile:
runs-on: ubuntu-latest
steps:
- name: Checkout code
uses: actions/checkout@v2
- name: Set up Python
uses: actions/setup-python@v2
with:
python-version: '3.9.16'
- name: Install dbt
run: |
pip install dbt
- name: Set up dbt Cloud profile
run: |
mkdir -p ~/.dbt
echo 'outputs:' > ~/.dbt/profiles.yml
echo ' dev:' >> ~/.dbt/profiles.yml
echo ' account: kw27752' >> ~/.dbt/profiles.yml
echo ' database: ANALYTICS' >> ~/.dbt/profiles.yml
echo ' password: ${{ secrets.DBT_CLOUD_TOKEN_NAME }}' >> ~/.dbt/profiles.yml
echo ' role: TRANSFORMER' >> ~/.dbt/profiles.yml
echo ' schema: dbt_gh_ci' >> ~/.dbt/profiles.yml
echo ' threads: 8' >> ~/.dbt/profiles.yml
echo ' type: snowflake' >> ~/.dbt/profiles.yml
echo ' user: DBT_SEMANTIC_LAYER_TEST' >> ~/.dbt/profiles.yml
echo ' warehouse: ANALYTICS' >> ~/.dbt/profiles.yml
echo 'target: dev' >> ~/.dbt/profiles.yml
- name: Set up dbt Cloud config
run: |
mkdir -p ~/.dbt
echo 'version: "1"' > ~/.dbt/dbt_cloud.yml
echo 'context:' >> ~/.dbt/dbt_cloud.yml
echo ' active-host: "cloud.getdbt.com"' >> ~/.dbt/dbt_cloud.yml
echo ' active-project: "263759"' >> ~/.dbt/dbt_cloud.yml
echo 'projects:' >> ~/.dbt/dbt_cloud.yml
echo ' - project-name: "Semantic Layer Demo"' >> ~/.dbt/dbt_cloud.yml
echo ' project-id: "263759"' >> ~/.dbt/dbt_cloud.yml
echo ' account-name: "Community DX Sandbox"' >> ~/.dbt/dbt_cloud.yml
echo ' account-id: "78663"' >> ~/.dbt/dbt_cloud.yml
echo ' account-host: "cloud.getdbt.com"' >> ~/.dbt/dbt_cloud.yml
echo ' token-name: ${{ secrets.DBT_CLOUD_TOKEN_NAME }}' >> ~/.dbt/dbt_cloud.yml
echo ' token-value: ${{ secrets.DBT_CLOUD_TOKEN_VALUE }}' >> ~/.dbt/dbt_cloud.yml
- name: Verify dbt Cloud profile
run: |
cat ~/.dbt/profiles.yml
cat ~/.dbt/dbt_cloud.yml
- name: Run Modified Models
run: |
dbt run -s state:modified