Data Modeling Best Practices for Amazon Quick Sight Multi-Dataset Relationships

Data Modeling Best Practices for Amazon Quick Sight Multi-Dataset Relationships

Data Modeling Best Practices for Amazon Quick Sight Multi-Dataset Relationships

Original URL: https://aws.amazon.com/blogs/machine-learning/data-modeling-best-practices-for-amazon-quick-sight-multi-dataset-relationships/

Article Written: July 7, 2026

Added: August 2, 2026

Type: product

Summary

The article discusses the introduction of Multi-Dataset Relationships in Amazon Quick Sight, allowing users to define logical relationships between datasets and perform runtime joins at query time. This approach reduces upfront data preparation, preserves native granularity, and simplifies governance. It also enables independent refresh schedules and row-level security during runtime joins. The article outlines best practices for designing multi-dataset models, including starting with a star schema and managing granularity deliberately.

Technologies Referenced