Is there a way to create one-to-many relationships between tables in Tableau? See the attached sample tables structure of my SQL database. Can we connect the tables with Foreign Keys in Tableau or have to connect using Union? Also, once tables are connected in Tableau - can we view the data model in Tableau to see the relationships between tables?
You can do all of this. Tableau will ask you to specify the join clause for each join, so you have complete flexibility over how you perform your joins.