Aggregating Multiple SCD-2 Attribute Timelines in BigQuery

Here’s another practical BigQuery SQL exercise 💡 Say you have an input SCD2-style table with [valid_from, valid_to) and key-value attributes. Now you want to determine which attributes were valid at the same time for a given grain (e.g. id). To do t...