Add new extractor extra `preferred_schema` to use as default loader `schema` instead of namespace
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 for theschema
setting when used with loadertarget-postgres
ortarget-snowflake
, implying thatnamespace
s should be unique among extractors
The extractor preferred_schema
extra would be set to $MELTANO_EXTRACTOR_NAMESPACE
by default.
This will enable us to change the default value of the target-postgres
and target-snowflake
schema
setting from $MELTANO_EXTRACTOR_NAMESPACE
to $MELTANO_EXTRACT__PREFERRED_SCHEMA
.