profiles.yml

# Note that only one of these targets is required
# setup IAM roles: https://docs.getdbt.com/docs/profile-bigquery#section-required-permissions

jaffle_shop:
  # use the below for oauth authenticated dbt runs
  target: dev
  outputs:
    dev:
      type: bigquery
      method: service-account # for production runs: https://docs.getdbt.com/docs/profile-bigquery#section-service-account-file-authentication
      project: "{{ env_var('PROJECT_ID', 'dbt-demo-386220') }}" # parameterize project for dbt runs based on environment variable with default project
      dataset: dbt_sung # You can also use "schema" here
      threads: 24 # https://docs.getdbt.com/docs/configure-your-profile#section-understanding-threads
      keyfile: "{{ env_var('GOOGLE_APPLICATION_CREDENTIALS', 'service_account.json') }}"
      timeout_seconds: 300
      location: US # Optional, one of US or EU
      priority: interactive # interactive or batch