How Can I Ensure the Schema Names Match in My Database and Destination?

Introduction

If the database connector name in your destination is not to your liking, find out how schema names in your destination can match what is in your BI tool.

Recommendation

One of Fivetran's core behaviors when loading data in the destination from a database is to prepend the schema name with the name of the connector. This is done to avoid table name collisions between connectors in your destination.

For example, suppose you have a database with 2 schemas: schema_a and schema_b. Both schemas are connected using one database connector: prefix. This will show up in your destination as prefix_schema_a and prefix_schema_b.

Once the schemas are in your destination, you can create views to rename the schemas to your liking. These views can then be connected to your BI Tool, thereby your downstream process remains unchanged.

Considerations

For some BI Tools, you can change the schema name in the underlying SQL code to Fivetran's naming convention.