How Can I Ensure Consistent Connection Schema Names Across Environments?

Question

How can I configure database connection so production and development environments use the same schema-naming format?

Environment

All database connectors

Answer

To ensure all environments use the same schema-naming format, choose the same destination schema naming convention when creating each connection:

• Fivetran naming: Creates destination schemas using connection_name_source_schema_name.source_table_name.
• Source naming: Creates destination schemas using source_schema_name.source_table_name.

You can’t change this setting after connection creation. If a connection uses the wrong naming format, delete and add it again with the correct Destination schema names option. For more information, see:

• Adding a New Connection
• Deleting a Connection