Meltano

I want to replicate our backend database to Snowflake. We have several country-specific schemas (`us` , `gb` , `fr` ) and other miscellaneous schemas.

I want to replicate all country schemas to Snowflake as-is (`us` -&gt; `us` , `gb` -&gt; `gb`) but all other schemas should go to `misc` . How can I achieve this?

I don’t want to hardcode all streams (aka all tables) of my Postgres backend DB.

I use <https://hub.meltano.com/loaders/target-snowflake--transferwise/>

```default_target_schema: ${MELTANO_EXTRACT__LOAD_SCHEMA}```

default_target_schema is set in snowflake target config and load_schema is set in the postgres extractor/tap config.

I think you are going to have to setup multiple extractors for the same database to do this... but there might be a fancy way to do it with <https://hub.meltano.com/mappers/meltano-map-transformer|map transformer>

I'd second the use of <https://hub.meltano.com/loaders/target-snowflake--transferwise/#default_target_schema-setting|default_target_schema>, used together with <https://hub.meltano.com/loaders/target-snowflake--transferwise/#schema_mapping-setting|schema_mapping> (better <https://hub.meltano.com/loaders/target-postgres--transferwise/#schema_mapping-setting|documented for target-postgres>)
```schema_mapping:
  us:
    target_schema: us
  gb:
    target_schema: gb
  fr:
    target_schema: gb
default_target_schema: misc```

Right on <@U06BX9QQ4A3>! Haven't used that functionality yet - looks useful. I will also take a look.

Thanks everyone :pray: I’ll try this!
I wish this existed with Meltano’s variant!

There's actually a feature requests for that: <https://github.com/MeltanoLabs/target-postgres/issues/163>