Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
“end-events”: Circled in green are the newly added end-events. Image by author. Bringing everything back together, we get a query in two parts: Part 1: Retrieving the “start_datetime” of the next event. Image by author. Part 2: Adding the end-event and merging the two timelines. We do both in one