I read that UNION operator is still not available withing QuickSight.
I have a case to union the result of more than 10 datasources from different DBs. The only resolution I found is to use FULL join and use COALESCE: UNION two datasets together instead of JOIN?
Is there a better way to do that, or is there more intelligent solution, please?
Datasets joins on a SPICE, right now it’s a good approach until you have a Data Warehouse :).
No union feature available in dataset right now.
Thanks @Naveed . Can we also request to QuickSight team to add Union as feature request down the line.
Regards - Sanjeeb
Can you please add the UNION keyword feature in your QS dev team upcoming releases ?