dbt_fivetran_log/integration_tests/ci/sample.profiles.yml at 63e5200fa65c2788f68d8fb77c863671fae0cb5d · fivetran/dbt_fivetran_log · 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

# HEY! This file is used in the dbt package integrations tests with Buildkite.
# You should __NEVER__ check credentials into version control. Thanks for reading :)

integration_tests:
  target: redshift
  outputs:
    redshift:
      type: redshift
      host: "{{ env_var('CI_REDSHIFT_DBT_HOST') }}"
      user: "{{ env_var('CI_REDSHIFT_DBT_USER') }}"
      pass: "{{ env_var('CI_REDSHIFT_DBT_PASS') }}"
      dbname: "{{ env_var('CI_REDSHIFT_DBT_DBNAME') }}"
      port: 5439
      schema: fivetran_platform_integration_tests
      threads: 8
    bigquery:
      type: bigquery
      method: service-account-json
      project: 'dbt-package-testing'
      schema: fivetran_platform_integration_tests
      threads: 8
      keyfile_json: "{{ env_var('GCLOUD_SERVICE_KEY') | as_native }}"
    snowflake:
      type: snowflake
      account: "{{ env_var('CI_SNOWFLAKE_DBT_ACCOUNT') }}"
      user: "{{ env_var('CI_SNOWFLAKE_DBT_USER') }}"
      password: "{{ env_var('CI_SNOWFLAKE_DBT_PASS') }}"
      role: "{{ env_var('CI_SNOWFLAKE_DBT_ROLE') }}"
      database: "{{ env_var('CI_SNOWFLAKE_DBT_DATABASE') }}"
      warehouse: "{{ env_var('CI_SNOWFLAKE_DBT_WAREHOUSE') }}"
      schema: fivetran_platform_integration_tests
      threads: 8
    postgres:
      type: postgres
      host: "{{ env_var('CI_POSTGRES_DBT_HOST') }}"
      user: "{{ env_var('CI_POSTGRES_DBT_USER') }}"
      pass: "{{ env_var('CI_POSTGRES_DBT_PASS') }}"
      dbname: "{{ env_var('CI_POSTGRES_DBT_DBNAME') }}"
      port: 5432
      schema: fivetran_platform_integration_tests
      threads: 8
    databricks:
      catalog: "{{ env_var('CI_DATABRICKS_DBT_CATALOG') }}"
      host: "{{ env_var('CI_DATABRICKS_DBT_HOST') }}"
      http_path: "{{ env_var('CI_DATABRICKS_DBT_HTTP_PATH') }}"
      schema: fivetran_platform_integration_tests
      threads: 1
      token: "{{ env_var('CI_DATABRICKS_DBT_TOKEN') }}"
      type: databricks
    databricks-sql:
      catalog: "{{ env_var('CI_DATABRICKS_DBT_CATALOG') }}"
      host: "{{ env_var('CI_DATABRICKS_DBT_HOST') }}"
      http_path: "{{ env_var('CI_DATABRICKS_SQL_DBT_HTTP_PATH') }}"
      schema: fivetran_platform_sqlw_tests
      threads: 1
      token: "{{ env_var('CI_DATABRICKS_SQL_DBT_TOKEN') }}"
      type: databricks
    sqlserver:
      type: sqlserver
      driver: 'ODBC Driver 18 for SQL Server'
      server: "{{ env_var('CI_SQLSERVER_DBT_SERVER') }}"
      port: 1433
      database: "{{ env_var('CI_SQLSERVER_DBT_DATABASE') }}"
      schema: fivetran_platform_integration_tests
      user: "{{ env_var('CI_SQLSERVER_DBT_USER') }}"
      password: "{{ env_var('CI_SQLSERVER_DBT_PASS') }}"
      threads: 8