analytics:
  target: dev
  outputs:
    dev:
      account: CCNTDMK-SUNO
      database: "{{ env_var('SNOWFLAKE_DB') }}"
      type: snowflake
      user: "{{ env_var('DBT_USER') }}"
      role: DBT_DEV_ROLE
      private_key_path: "{{ env_var('DBT_SNOWFLAKE_PRIVATE_KEY_PATH') }}"
      schema: "prod"
      threads: 4
      warehouse: "{{ env_var('DBT_DEV_WH', 'DBT_DEV_MEDIUM') }}"
    stg:
      account: CCNTDMK-SUNO
      database: "suno_stg"
      type: snowflake
      user: "{{ env_var('DBT_USER') }}"
      private_key: "{{ env_var('DBT_SNOWFLAKE_PRIVATE_KEY') }}"
      role: DBT_DEV_ROLE
      threads: 4
      warehouse: DBT_DEV_WH
      schema: "prod"
    prod:
      account: CCNTDMK-SUNO
      database: suno_prod
      type: snowflake
      user: "{{ env_var('DBT_USER') }}"
      private_key: "{{ env_var('DBT_SNOWFLAKE_PRIVATE_KEY') }}"
      role: DBT_DEV_ROLE
      schema: "prod"
      threads: 4
      warehouse: DBT_DEV_WH
    prod_local: # for local compiling with prod database
      account: CCNTDMK-SUNO
      database: suno_prod
      type: snowflake
      user: "{{ env_var('DBT_USER') }}"
      private_key_path: "{{ env_var('DBT_SNOWFLAKE_PRIVATE_KEY_PATH') }}"
      role: DBT_DEV_ROLE
      schema: "prod"
      threads: 4
      warehouse: DBT_DEV_MEDIUM