Hello all, I have a basic best practise question: I have many sources and want to import them into one postgresql database. I want to import every source into a different database schema. As far as i understand I configure the loader and the schema in one project. I can define more extractor taps in one project but I can only define one target schema. What is the best practise here - change the schema on the fly before the run happens or create an extra project for every source?

https://docs.meltano.com/concepts/plugins/#load_schema-extra is what you're after I think 🙂

create a new tap configuration for each source, you can use inheritance if there is a common base. and use the load_schema key to define the target schema.

You can use the name of the tap to define your target schema too. Set

default_target_schema

to

MELTANO_EXTRACTOR_NAMESPACE

in your target

Cool thanks a lot