Ability to Perform a Union

Is there any way to perform a Union in Sigma – I don’t see this as an option on the join page?

Hey Zachary!

Currently you are not able to perform a Union with Sigma’s UI but our team has this filed as a feature request! You can however use a Union through SQL Runner – check out this community post to help out.

Just wanted to past this SQL code for unions since I often search for it here and this is the first result.

select * from .<dataset_view_1>
UNION ALL
select * from .<dataset_view_2>
UNION ALL
select * from .<dataset_view_3>
;