How to Confirm the Database Name of Tables in Snowflake When Using the feature "Cross-database joins for Snowflake" Starting in Tableau 2023.1

Published: 12 Oct 2023
Last Modified Date: 12 Oct 2023

Question

Starting in 2023.1, "Cross-database joins for Snowflake" was released.

When using this new feature, is there any way to confirm the database name of the Snowflake tables in a data connection window?

For example, when we create a table relation with tables from different databases, we notice it only shows the table name without the database name. In the below example, BATTERS1 and CALCS are from different databases and it is not possible to see what database each table belongs to.
User-added image

Environment

Tableau 2023.1 and later
Snowflake

Answer

Option 1

1. On the Datasource editing window in Tableau Desktop / Tableau Server / Tableau Cloud, right-click your table and click "Convert to Custom SQL".
User-added image

2. From the "Convert to Custom SQL" window, you will see the database name in the FROM part of the custom SQL as demonstrated below.
User-added image

Option 2

1. On the Datasource editing window in Tableau Desktop / Tableau Server / Tableau Cloud, right-click your table and click "Reset Table Name".
User-added image