-
Notifications
You must be signed in to change notification settings - Fork 0
/
profiles.yml
54 lines (50 loc) · 1.52 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
48
49
50
51
52
53
54
dbt_models:
target: dev
outputs:
dev:
type: postgres
host: "{{ env_var('POSTGRES_HOST') }}"
user: "{{ env_var('POSTGRES_DEV_USER') }}"
password: "{{ env_var('POSTGRES_DEV_PW') }}"
port: 5432
dbname: prod
schema: dev
threads: 8
prod:
type: postgres
host: "{{ env_var('POSTGRES_HOST') }}"
user: "{{ env_var('POSTGRES_PROD_USER') }}"
password: "{{ env_var('POSTGRES_PROD_PW') }}"
port: 5432
dbname: prod
schema: analytics
threads: 8
ci:
type: postgres
host: "{{ env_var('POSTGRES_HOST') }}"
user: "{{ env_var('POSTGRES_PROD_USER') }}"
password: "{{ env_var('POSTGRES_PROD_PW') }}"
port: 5432
dbname: prod
schema: "{{ env_var('POSTGRES_CI_SCHEMA') }}"
threads: 8
dev_duckdb:
type: duckdb
attach:
- path: postgresql://{{ env_var('POSTGRES_PROD_USER') }}:{{ env_var('POSTGRES_PROD_PW') }}@{{ env_var('POSTGRES_HOST') }}:5432/prod
alias: postgres
type: postgres
prod_duckdb:
type: duckdb
extensions:
- httpfs
- parquet
secrets:
- type: s3
region: "{{ env_var('AWS_REGION') }}"
key_id: "{{ env_var('AWS_ACCESS_KEY_ID') }}"
secret: "{{ env_var('AWS_SECRET_ACCESS_KEY') }}"
attach:
- path: postgresql://{{ env_var('POSTGRES_PROD_USER') }}:{{ env_var('POSTGRES_PROD_PW') }}@{{ env_var('POSTGRES_HOST') }}:5432/prod
alias: postgres
type: postgres