Analytics Engineering, Bigquery, Sql, Data Engineering, Editors Pick.
missed the fact that the date ranges could be discontinuous. To fix this, the first step we must achieve is to transform our “history”, which is made of date ranges (from start_date to end_date), into an event timeline, made only of events (just one event_date), without losing any information.