Document how to set target-postgres and target-snowflake schema to something other than extractor namespace
Mathieu Hinderyckx wrote on Slack:
The fact that the ’namespace` is the target schema to be used is also a bit weird to me. I expect this to be part of the target configuration and not to be in the tap. It should be possible to choose where the data is being written at the side of the target, the tap isn’t concerned with that?
I responded:
As far as using the namespace for the schema, this made sense in the use cases we've been using Meltano in ourselves, when the L stage was always followed by a T stage that would essentially pull the different namespace schemas together into a new
analytics
schema, but it's definitely counter to expectations (and undesirable) in a generic ELT tool.You can override the
schema
value that is passed totarget-postgres
by setting theMELTANO_LOAD_SCHEMA
environment variable, but I don't think that's even documented right now.Do you think it would be acceptable to keep the current default behavior if it's actually documented and easy for people to figure out how to override the schema?