Add new loader extra `target_schema` to use as default dbt `source_schema` instead of loader `schema`
Part of untangling the mess described in #2208 (comment 388529270):
The inconsistent
namespace
s are an unfortunate consequence of the different roles thatnamespace
has come to play in Meltano over time, and the different directions they pull us in:
- extractor
namespace
: default value fordbt
'ssource_schema
setting, through point 3'sschema
setting:
The loader target_schema
extra of target-postgres
would be set to $PG_SCHEMA
by default.
This will enable us to change the default value of the dbt source_schema
setting from $MELTANO_LOAD_SCHEMA
to $MELTANO_LOAD__TARGET_SCHEMA
.