Union two or more datasets from different datasources

Question & Answer
, ,
1

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?

2

Hi,

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.

regards,
Naveed Ali

1 Like
3

Thanks @Naveed . Can we also request to QuickSight team to add Union as feature request down the line.

Regards - Sanjeeb

1 Like
4

@Kristin
Hi,

Can you please add the UNION keyword feature in your QS dev team upcoming releases ?

Regards,
Naveed Ali

2 Likes
5