Hi, I’m trying to work out how to solve a few problems with growing datasets that being able to UNION the datasets would probably solve but as that’s not available I’m looking for alternative approaches. We have a few SPICE datasets which are based on Athena tables. They are used to back daily a…

Hi @nlp - One analysis supports multiple datasets. A visual within the analysis can map to only one dataset though. So, one option that you have here is to have different visuals in your analysis for different datasets that you have. Another option is to preprocess your data using AWS Glue to apply…

Alternate strategies to dataset UNION

Q&A

vignessh.b November 4, 2025, 2:57am 4

@nlp (cc: @awsvig ) Have you tried the new data preparation experience in Quick Sight that was recently launched? It now provides Pivot, Unpivot, Append (Union All), Aggregate (ListAgg, ListAgg Distinct) and many more features in data preparation through a visual interface.

Topic		Replies	Views
Please add UNION for datasets Q&A feature-request	2	189	August 2, 2023
Mutiple datasets Q&A feature-request , dataset , calculations , Business-Intelligence-Engineer	2	128	December 29, 2023
Choosing Dataset directly in the dashboard Q&A feature-request , dashboard , Business-Intelligence-Engineer	8	636	January 24, 2024
Datasets and union Q&A data-source , dataset , Business-Intelligence-Engineer	2	1376	October 29, 2025
UNION ALL two or more datasets, native solution required Q&A developer , feature-request , qls-spice-schedule-api	2	112	January 21, 2025

Alternate strategies to dataset UNION

Related topics