Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
our date ranges. All we need to do next is perform some cleaning to remove the magic values -1 and “”: Image by author. We perform one final query to compute the price_with_promotion_included and one final unnest since we want the final results to be flat (shop_id and article_id are repeated at