Data modeling best practices for Amazon Quick Sight multi-dataset relationships

2026-07-07 · Source: Artificial Intelligence · Field: Technology & Digital — Data Science & Analytics, Cloud Computing & & IT Infrastructure · Depth: Intermediate, medium

Summary

Amazon Quick Sight has introduced Multi-Dataset Relationships, a new capability enabling users to define logical connections between datasets and execute runtime joins during analysis. This feature eliminates the previous requirement of pre-joining all tables into wide, denormalized datasets, which often led to upfront data modeling decisions, measure duplication, and dataset sprawl. The new paradigm offers several advantages, including reduced upfront data preparation, preservation of native data granularity, enhanced reuse across analytical scenarios, simplified governance, independent data refresh schedules, and consistent row-level security enforcement. It operates through two layers: a physical layer within individual datasets for merging same-grain tables, and a logical layer within a Quick Sight Topic for relating distinct datasets. Best practices emphasize starting with a star schema, designing datasets as logical entities, using clean join keys, managing granularity, and enriching metadata for improved natural language query accuracy. A decision framework guides users on when to apply multi-dataset relationships versus traditional pre-joined approaches.

Key takeaway

For Analytics Engineers or Data Analysts building complex BI solutions in Amazon Quick Sight, the new Multi-Dataset Relationships feature fundamentally shifts data modeling. You should now prioritize creating distinct logical datasets and defining relationships within Topics, rather than pre-joining everything. This approach reduces upfront preparation, preserves data granularity, and significantly improves flexibility for diverse analytical use cases and natural language exploration. Consider adopting this for scenarios involving multiple fact tables, many-to-many relationships, or role-playing dimensions to streamline your data architecture.

Key insights

Amazon Quick Sight's Multi-Dataset Relationships enable dynamic data integration at query time, reducing upfront preparation and enhancing analytical flexibility.

Principles

• Model data once, preserving native granularity across datasets.
• Start with a star schema to minimize join complexity and maximize query performance.
• Enrich metadata with descriptions and synonyms for accurate AI and natural language queries.

Method

Create individual datasets as logical entities, define a Topic as the semantic model container, specify relationships between datasets, then analyze or use Q&A for runtime joins.

In practice

• Implement role-playing dimensions by creating separate datasets for each role.
• Use for multi-fact scenarios like cross-process analytics (e.g., Sales vs. Returns).
• Add field descriptions and synonyms to improve natural language interface accuracy.

Topics

• Amazon Quick Sight
• Data Modeling
• Multi-Dataset Relationships
• Dimensional Modeling
• Semantic Layer
• Runtime Joins

Best for: Data Analyst, Analytics Engineer, Data Engineer

Related on AIssential

• AI-powered BI with Snowflake and Amazon Quick — Centralizing business logic via semantic views at the data layer ensures consistent data interpretation across AI and BI tools.
• Ch 12 - Stringing Together the Building Blocks — This final chapter of Part 2 emphasizes the synthesis of individual data modeling "building blocks" into a coherent system, using a martial arts analogy to illustrate how isolated techniques become powerful when combined.
• Announcing Together AI and Adaption Partnership — Optimizing training data before fine-tuning open models significantly enhances model quality and development speed.
• Relationships: Tying It Together — Data relationships are essential for coherent data ecosystems, expressed differently across various modeling paradigms to meet specific goals.
• From data lake to AI-ready analytics: Introducing new data source with S3 Tables in Amazon Quick — Amazon Quick now directly queries Apache Iceberg tables in S3, enabling near real-time, AI-powered analytics on data lakes.
• DataBooks: Markdown as Semantic Infrastructure — DataBooks use Markdown's advanced features to create self-describing, portable semantic artifacts for small-scale graph data.

Open in AIssential →

Editorial summary, takeaway, and curation by AIssential. Original article published by Artificial Intelligence.