Incremental approach not working for non default destination schema

Help
, , ,
1

The problem I’m having

I am using dbt core and snowflake as my destination database. I have multiple schemas in the destination. Say schema1 is my default schema as per the profile.yml for dbt. When I create a model as incremental using the is_incremental() macro for schema1, it works fine behaves as expected. But when I create the same for a different destination schema schema2 (not my default schema in profile.yml) it doesn’t work.

models:
ccp:
exploring:
+materialized: view
+schema: testing
+enabled: false
schema1:
+materialized: incremental
+schema: schema1
schema2:
+materialized: incremental
+schema: schema2

packages:

  • package: dbt-labs/dbt_utils
    version: 1.1.1

Is this expected ? I cannot avoid having multiple schema’s in the destination. Please help.