DBT-GA4/profiles.yml at main · Ftmarruda/DBT-GA4 · 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
# profiles.yml
# information for our DBT runs on BigQuery
# https://docs.getdbt.com/reference/warehouse-profiles/bigquery-profile

# TODO: add a test for integration test environment
# TODO: use different credentials for dev and prod
my_project:
  outputs:

    dev:
      type: bigquery
      project: <your-project-id>
      location: EU
      method: service-account
      keyfile: /config/credentials.json
      priority: interactive
      fixed_retries: 1
      threads: 1
      timeout_seconds: 300

    prod:
      type: bigquery
      project: <your-project-id>
      location: EU
      method: service-account
      keyfile: /config/credentials.json
      priority: interactive
      fixed_retries: 1
      threads: 1
      timeout_seconds: 300

  target: "{{ env_var('DBT_EXEC_PROFILE') }}"