Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
when we use the window function last_value(… ignore nulls). Arguably, this is a code smell, but we will keep it for the sake of simplicity in this article. Once this is done, we will simply merge the two timelines with a UNION like this: Schematical representation of unioning two timelines. Image