How to Create Cross-Database Joins in Tableau
Вставка
- Опубліковано 13 гру 2022
- Connect with us:
•Subscribe to the OneNumber Newsletter: onenumber.biz/newsletter
•Follow Ollie Linley on LinkedIn: / oliverlinley
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.
If you're unsure of how joins work in Tableau, then the best place to start is with the "Joins" section at the beginning of this free webinar ( • Joins, Unions and Blen... ) and then come back to this video - you'll get more out of it that way around!
Related Resources:
•How to Prepare (Structure) Data for Analysis in Tableau: onenumber.biz/blog-1/2022/5/2...
•Joins, Unions and Blends in Tableau: onenumber.biz/blog-1/2018/1/1...
•Tableau Join Calculations: onenumber.biz/blog-1/2022/8/1....
•How to Validate Join Results in Tableau Desktop: onenumber.biz/blog-1/2022/4/6...
•Tableau Relationships vs. Joins: onenumber.biz/blog-1/2021/12/...
Need help with your cross-database joins? Schedule an hour with Ollie! www.eventbrite.com/e/tableau-office-hours-with-ollie-linley-eastern-time-tickets-439769641837
Ready to master Tableau? Check out our lineup of upcoming classes! www.eventbrite.com/o/onenumber-15678294163
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.
You are welcome! Sorry to hear about the challenges but we're glad to hear you were able to sort it out.
Thank you! 😃
You're welcome!
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?
Hey! Yes, cross-database relationships are set up in a very similar way to cross-database joins, and that connection can be set to live!
@@onenumbertableau thanks for your answer
Can cross database joins be performed on different databases like SQL Server and redshift?
Absolutely! There are a few types of data sources which aren't eligible for cross-database joins but 90% are. Redshift and SQL Server should work together!
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?
Not with one-click unfortunately. You'll have to reconfigure the cross-database join. However, if the fields names stay the same between the two sources, the references in your Tableau worksheets shouldn't be affected after swapping out the tables.