expression Any valid query expression that returns a collection to combine with the collection All expressions must be of the same type or of a common base or derived type as expression. UNION ...

For the equivalent transformation (Append queries) in Dataflow Gen2, see A guide to Dataflow Gen2 for mapping data flow users. Union combines multiple data streams into one, with the SQL Union of ...