-
Notifications
You must be signed in to change notification settings - Fork 0
/
profiles.yml.jinja
80 lines (80 loc) · 2.22 KB
/
profiles.yml.jinja
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
75
76
77
78
79
80
{% if data_warehouse == "snowflake" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse | lower }}
account: {{ account_env_var | lower }}
authenticator: externalbrowser
user: {{ username | lower }}
warehouse: {{ warehouse | lower }}
database: {{ database | lower}}
schema: {{ schema | lower }}
threads: {{ thread_count}}
{%- endif -%}
{% if data_warehouse == "bigquery" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse }}
method: oauth
project: {{ database | lower }}
dataset: {{ schema | lower }}
threads: {{ thread_count }}
{%- endif -%}
{% if data_warehouse == "redshift" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse | lower }}
method: iam
iam_profile: {{ iam_profile | lower }}
region: {{ region | lower }}
cluster_id: {{ cluster_id | lower }}
host: {{ host | lower }}
port: {{ port | lower }}
user: {{ username | lower }}
database: {{ database | lower }}
schema: {{ schema | lower }}
threads: {{ thread_count }}
{%- endif -%}
{% if data_warehouse == "duckdb" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse }}
path: {{ duckdb_file_path | lower }}
database: {{ database | lower }}
schema: {{ schema | lower }}
threads: {{ thread_count }}
{%- endif -%}
{% if data_warehouse == "postgres" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse | lower }}
host: {{ host | lower }}
port: {{ port | lower }}
user: {{ username | lower }}
password: "" # Add a password here if needed
database: {{ database | lower }}
schema: {{ schema | lower }}
threads: {{ thread_count }}
{%- endif -%}
{% if data_warehouse == "databricks" %}
{{ profile_name }}:
target: dev
outputs:
dev:
type: {{ data_warehouse | lower }}
{% if using_unity_catalog -%}catalog: {{ catalog | lower }}{%- endif %}
host: {{ host | lower }}
http_path: {{ http_path | lower }}
token: # Your Personal Access Token here
schema: {{ schema | lower }}
threads: {{ thread_count }}
{%- endif -%}