Hello everyone - anybody know if this is possible?...
# community-support
j
Hello everyone - anybody know if this is possible? Trying to specify seperate envs using different connections in dbt profiles.yml I didn't see any flags in the docs to specify a name other than "elementary." Any help or alt approach would be appreciated.
Copy code
elementary-qa:
  outputs:
    default:
      type: snowflake
      account: XXXX.us-east-1
      user: XXXX
      private_key_passphrase: "{{ env_var('DBT_ENV_SECRET_KEY_PASSPHRASE') }}"  #gitleaks:ignore
      private_key_path: "{{env_var('DBT_ENV_SECRET_KEY_PATH')}}"  #gitleaks:ignore
      role: transformer
      warehouse: GENERAL_WH
      database: XXXX
      schema: elementary
      threads: 4

elementary-prod:
  outputs:
    default:
      type: snowflake
      account: XXXX.us-east-1
      user: XXXX
      private_key_passphrase: "{{ env_var('DBT_ENV_SECRET_KEY_PASSPHRASE') }}"  #gitleaks:ignore
      private_key_path: "{{env_var('DBT_ENV_SECRET_KEY_PATH')}}"  #gitleaks:ignore
      role: transformer
      warehouse: GENERAL_WH
      database: XXXX
      schema: elementary
      threads: 4
m
elementary:
target: qa
outputs:
qa:
type: snowflake
account: XXXX.us-east-1
user: XXXX
private_key_passphrase: "{{ env_var('DBT_ENV_SECRET_KEY_PASSPHRASE') }}"  #gitleaks:ignore
private_key_path: "{{env_var('DBT_ENV_SECRET_KEY_PATH')}}"  #gitleaks:ignore
role: transformer
warehouse: GENERAL_WH
database: XXXX
schema: elementary
threads: 4
prod:
type: snowflake
account: XXXX.us-east-1
user: XXXX
private_key_passphrase: "{{ env_var('DBT_ENV_SECRET_KEY_PASSPHRASE') }}"  #gitleaks:ignore
private_key_path: "{{env_var('DBT_ENV_SECRET_KEY_PATH')}}"  #gitleaks:ignore
role: transformer
warehouse: GENERAL_WH
database: XXXX
schema: elementary
threads: 4
on your execution of the cli add the option
Copy code
--profile-target
on the template I sent above I added target QA as the fallback profile in line 2 in case the argument for profile is not sent.
j
ok nice! thanks so much! I thought I had tried that flag - but maybe not
yup sure - enough. that worked!
Thanks @Michel Galle