Database Naming Conventionslink
Updated 13 days ago
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.
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\_b. Both schemas are connected using one database connector:
prefix. This will show up in your destination as
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.
For some BI Tools, you can change the schema name in the underlying SQL code to Fivetran's naming convention.