@kapa.ai I am trying to separate the elementary models into a specific schema. I created a profile elementary specifying the schema, in addition to my classic project profile (used in our ci/cd). I run

dbt run -s elementary --profile elementary

to create the elementary tables/views in its dedicated schema. But when i run my models and tests, elementary tries to write the metadata in the schema of the project using the project profile. How to handle this?

profile_project:
  target: pre_prod
  outputs:
    pre_prod:
      account: ***
      user: ***
      type: snowflake
      database: DBT_PREPROD
      schema: DBT
      role: ***
      warehouse: ***
      authenticator: ***
      threads: 8

elementary:
  target: default
  outputs:
    default:
      account: ***
      user: ***
      type: snowflake
      database: DBT_PREPROD
      schema: DBT_ELEMENTARY
      role: ***
      warehouse: ***
      authenticator: ***
      threads: 8

A message from kapa.ai