How to handle duplicated table names across schemas

Often when we connect to different schemas in a database, we will have tables, for numerous reasons, with the same name sitting in different schemas.

When we register a data source, by default, we name the table only, so if you have not specified a schema in the database connection statement, at face value it would appear that duplicated tables are showing.

To address this, we add the following detail either in the datasource connection wizard or the datasource connection sql statement

schema_prepended_table "true"

This will add the schema name, to the table name. In the below screen shot example, tpch and tpch1 are the schemas captured, and have been prepended to the table name.