Merges the rows from two subqueries into one result. Duplicates are dropped unless you add ALL.
Also called UNION ALL.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains UNION in context, with comparison tables and the common traps.
Terms in this definition
- Architecture Definition Document
A key deliverable bringing together the main architecture artifacts across the four domains for every relevant state: baseline, transition and target. It sets out, in qualitative terms, what the architect intends.
- ALL
A DAX function that ignores any filters and gives back every row of a table or every value of the named columns. Used within CALCULATE, it works as a modifier that clears filters, although REMOVEFILTERS states that intent more clearly where it is available.
Related terms
- EU Data Boundary
A pledge by Microsoft to store and process EU customer data, Copilot traffic included, inside the European Union. Search queries that Copilot generates and passes to Bing are an exception.
- Explicit flow
A flow you declare on its own, apart from the target. A streaming table can then take data from multiple sources with no
UNION, and adding another source needs no full refresh. - GROUPING SETS
Lets one
GROUP BYquery return results for several different groupings at once, giving the same output as stitching individual aggregations together withUNION ALL.CUBEandROLLUPare convenient shorthands built on it. - Recursive CTE
A CTE that refers to itself, joining an anchor part to a recursive part with UNION ALL; T-SQL's usual tool for walking hierarchies. Depth is capped by MAXRECURSION, which is 100 unless changed.