generated from dbt-labs/jaffle-shop
/
profiles.yml
47 lines (45 loc) · 1.38 KB
/
profiles.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
duckdb:
outputs:
dev:
type: duckdb
path: ./jaffle_shop.duckdb
database: jaffle_shop
schema: analytics
threads: 4
target: dev
snowflake:
target: dev
outputs:
dev:
type: snowflake
account: "{{ env_var('SNOWFLAKE_SANDBOX_ACCOUNT') }}"
user: "{{ env_var('SNOWFLAKE_SANDBOX_USER') }}"
password: "{{ env_var('SNOWFLAKE_SANDBOX_PASSWORD') }}"
role: "{{ env_var('SNOWFLAKE_SANDBOX_ROLE') }}"
database: "{{ env_var('SNOWFLAKE_SANDBOX_DB') }}"
warehouse: "{{ env_var('SNOWFLAKE_SANDBOX_WH') }}"
schema: "{{ env_var('SNOWFLAKE_SANDBOX_SCHEMA') }}"
threads: 8
prod:
type: snowflake
account: "{{ env_var('SNOWFLAKE_SANDBOX_ACCOUNT') }}"
user: "{{ env_var('SNOWFLAKE_SANDBOX_USER') }}"
password: "{{ env_var('SNOWFLAKE_SANDBOX_PASSWORD') }}"
role: "{{ env_var('SNOWFLAKE_SANDBOX_ROLE') }}"
database: "{{ env_var('SNOWFLAKE_SANDBOX_DB') }}"
warehouse: "{{ env_var('SNOWFLAKE_SANDBOX_WH') }}"
schema: "{{ env_var('SNOWFLAKE_SANDBOX_SCHEMA') }}"
threads: 8
postgres:
target: dev
outputs:
dev:
type: postgres
host: "{{ env_var('DX_SANDBOX_POSTGRES_HOST') }}"
port: 5432
user: winnie
role: transformer
password: "{{ env_var('DX_SANDBOX_POSTGRES_PASSWORD') }}"
database: jaffle_shop
schema: dbt_winnie
threads: 1