Why you should use UNION DISTINCT sparingly

Let's help BigQuery do less unneeded work! If you're UNIONING two sources known to have distinct values (and they don't have duplicates), go for UNION ALL instead of UNION DISTINCT (UNION for some other sql dialects) to avoid redundant de-duplication...