We have the same tables in 3 AWS environments and want to UNION them into a single table in our analyses. I have 3 identical SPICE datasets. It should not be hard to create a UNION of SPICE tables that are internal to QuickSight. This has to be a common request.
Hi,
Thanks for bringing up this request. UNION operation between SPICE datasets is currently not available. As an alternate approach can you please consider following options:
Option1: can you consider Union operation in custom SQL. If the datasets are coming from the same datasource in QuickSight you can use the custom SQL to use “UNION ALL”
Option 2: Can you considering Union operation outside QuickSight in data preparation stage as Union view in database or as part of ETL logic.
I will tag this as a feature request. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service.
Regards,
Anwar Ali