Database Naming Conventionslink

Updated 13 days ago

Introductionlink

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.

Recommendationlink

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.

Considerationslink

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