Amazon Quick supports multi-dataset analytical capabiity
Amazon QuickSight introduces multi-dataset topics, allowing users to model relationships across multiple datasets without pre-joining data, simplifying dashboard creation and natural-language queries.
Amazon QuickSight now supports multi-dataset topics, enabling users to define relationships across multiple datasets within a single topic. Previously, answering cross-dataset questions required manual joins during data preparation, consuming additional SPICE capacity and necessitating dataset rebuilds for different use cases. The new feature eliminates these steps by allowing QuickSight to perform joins at runtime, streamlining the process for both dashboard creation and natural-language queries.
For dashboard building, multi-dataset topics serve as reusable relational data models. Users can add multiple datasets, define their relationships once, and QuickSight automatically generates the necessary joins when visuals are created. This reduces redundancy, as a single semantic model can be reused across all visuals in a dashboard, ensuring consistency and efficiency in data representation.
Natural-language analytics also benefits from this feature, as users can direct a chat agent to query a topic directly. The agent interprets the relationships defined in the topic and performs runtime joins across datasets to answer questions, eliminating the need for pre-joined tables or additional data preparation steps.
Multi-dataset topics maintain existing dataset permissions and support row-level and column-level security, ensuring governance is preserved across all cross-dataset visuals and queries. The feature is now generally available in all AWS Regions where Amazon QuickSight is offered.