Union all between datasets

I have a datasets named as smapleData is being used in different Dashboard.
now I want to create a new datasets using the smapleData and want to union all with a second datasets.

Is there any way to do it while creating new datasets using union all rather than Join condition.

No; using 'union all 'sql function is not possible through joining datasets in QuickSight. If the datasets are coming from the same datasource in QuickSight you can use the custom SQL to use ‘UNION ALL’. But otherwise, it is not (yet) possible as far as I know. And I used QS quite extensively already.


Does anyone know why this is ?