sqlmesh/examples/sushi_dbt/profiles.yml at 50cb8c7830478a4de12d0c809a1f63550fa3cc7b · SQLMesh/sqlmesh · GitHub

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
81
sushi:
  outputs:
    in_memory:
      type: duckdb
      schema: sushi
    postgres:
      type: postgres
      host: "host"
      user: "user"
      password: "password"
      dbname: "dbname"
      port: 5432
      schema: sushi
    duckdb:
      type: duckdb
      path: 'local.duckdb'
      schema: sushi
    snowflake:
      account: "{{ env_var('SNOWFLAKE_ACCOUNT') }}"
      database: sushi
      password: "{{ env_var('SNOWFLAKE_PASSWORD') }}"
      role: "{{ env_var('SNOWFLAKE_ROLE') }}"
      schema: sushi
      threads: 1
      type: snowflake
      user: "{{ env_var('SNOWFLAKE_USER') }}"
      warehouse: "{{ env_var('SNOWFLAKE_WAREHOUSE') }}"
    bigquery:
      type: bigquery
      method: service-account
      project: "{{ env_var('BQ_PROJECT') }}"
      dataset: "{{ env_var('BQ_SCHEMA') }}"
      threads: 1
      keyfile: "{{ env_var('BQ_KEYFILE') }}"
      location: "{{ env_var('BQ_LOCATION') }}"
    redshift:
      host: "{{ env_var('REDSHIFT_HOST') }}"
      user: "{{ env_var('REDSHIFT_USER') }}"
      password: "{{ env_var('REDSHIFT_PASSWORD') }}"
      port: "{{ env_var('REDSHIFT_PORT') }}"
      dbname: "{{ env_var('REDSHIFT_DBNAME') }}"
      schema: sushi
      threads: 1
      type: redshift
    sqlserver:
      host: "{{ env_var('SQLSERVER_HOST') }}"
      user: "{{ env_var('SQLSERVER_USER') }}"
      password: "{{ env_var('SQLSERVER_PASSWORD') }}"
      database: "{{ env_var('SQLSERVER_DATABASE') }}"
      driver: "{{ env_var('SQLSERVER_DRIVER') }}"
      authentication: sql
      schema: sushi
      threads: 1
      type: sqlserver
    trino:
      type: trino
      method: none
      http_scheme: http
      user: "{{ env_var('TRINO_USER') }}"
      host: "{{ env_var('TRINO_HOST') }}"
      database: "{{ env_var('TRINO_DATABASE') }}"
      schema: sushi
      threads: 1
    clickhouse:
      type: clickhouse
      host: "{{ env_var('CLICKHOUSE_HOST') }}"
      port: 8123
      user: "{{ env_var('CLICKHOUSE_USER') }}"
      password: "{{ env_var('CLICKHOUSE_PASSWORD') }}"
      schema: sushi
      threads: 1
    clickhouse_cluster:
      type: clickhouse
      host: "{{ env_var('CLICKHOUSE_HOST') }}"
      port: 8123
      user: "{{ env_var('CLICKHOUSE_USER') }}"
      password: "{{ env_var('CLICKHOUSE_PASSWORD') }}"
      cluster: "{{ env_var('CLICKHOUSE_CLUSTER') }}"
      schema: sushi
      threads: 1
  target: in_memory