tools/legacy_sql_tranlsation_helper/sample_sql/sample2.sql (2 lines of code) (raw):

SELECT product, inventory, cast(null as string) as color, FROM `projectid.test.simple_table1` UNION ALL SELECT product, inventory, color, FROM `projectid.test.simple_table2`