课程: Using Snowflake with Tableau
今天就开通帐号，24,700 门业界名师课程任您挑！
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…
随堂练习，边学边练
下载课堂讲义。学练结合，紧跟进度，轻松巩固知识。
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程