From the course: Using Snowflake with Tableau
Join today to access over 25,300 courses taught by industry experts.
A note on referential integrity
From the course: Using Snowflake with Tableau
A note on referential integrity
- Referential integrity is a key principle in relational database design that ensures relationships between tables are maintained correctly. It enforces the idea that foreign keys in one table must correspond to primary keys in another. For example, if you have an Orders table that references a Customers table, like we just saw, each customer ID in the Orders table must exist in the Customers table. In Tableau, referential integrity impacts how data relationships between tables are interpreted during the query-building process. For context, Tableau writes SQL in the background, which is why it has a query-building progress. Now, Tableau's primarily used as a visualization tool and it doesn't enforce referential integrity itself. Instead, it relies on the underlying data source, in this case, Snowflake, to do that. When setting up relationships in Tableau, particularly in the data model, you define relationships between tables or data sources. Tableau allows you to assume referential…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.