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 Quick Sight. 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 Quick Sight you can use the custom SQL to use “UNION ALL”
Option 2: Can you considering Union operation outside Quick Sight 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