Backfill Salesforce History into SCD2 with dbt: Turning Field Logs into Real Dimensions

If you’ve ever tried to backfill a Slowly Changing Dimension Type 2 (SCD2) from a Salesforce History table, you already know: