How Can I Have More Than One Connector Writing to the Same Schema?
Question
How can I write multiple sources of data to the same schema in my destination?
Environment
All connectors
Answer
The best option is to combine schemas post-load:
- Use a single destination.
- Create connectors with unique schema names.
- Transform data post-load using a command that best fits your use case or requirements.
Context
Fivetran enforces a unique schema name within a single destination.