How to Create Cross-Database Joins in Tableau

Connect with us:

Description:
A huge benefit of using joins in Tableau is that we can combine data from multiple tables into a single table for analysis. When those tables are in different databases, it can be a little tricky to work out where to start. If you know how to join tables within the same database, that's great! Cross-database joins only take a few more steps to execute, and I'll walk you through them in today's video.

Related Resources:

[ivyclark]

Thank you for this! I wasn't able to make Tableau join datasources, and you pointed me in the right direction! Wish the UI would be improved as I kept using the topmost button and not getting the outcome I wanted.

[f]

Can cross database joins be performed on different databases like SQL Server and redshift?

[confusingmaverick]

Great video.. when we do cross data source join, can we use relationship instead of join? Also can i set live connection when i do cross database join/relationship?

[Seth.Chatterley]

If I want to create a connection using a text file as a proof of concept, can I go in later and change the connection source to a Snowflake table later?