Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
go which is why we are unioning 4 sub-tables together. Note that we also used a magic value “” for the promotion_id. Image by author. Step 3: Filling in the Blanks + Replacing Magic Values Now that this is done, the previous query from step 3 gives us a result that looks almost like the one we