Question

How can I write multiple sources of data to the same schema in my destination?

Environment

All connectors

Answer

Approach 1: Create multiple destinations in Fivetran

1. Create a new destination for every source of data you require to write to the same schema; ensure this destination uses the same warehouse credentials each time
2. Create a connector in each destination with the same schema name

Approach 2: Combine schemas post-load

1. Use a single destination
2. Create connectors with unique schema names
3. 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.

Considerations

The comparison between the approaches is:

• Approach 1: the burden of management
• Approach 2: latency to land data within a single schema

Your understanding of the effect on your business should determine which approach is best for you.