Snapshots are great for capturing entire records that have changed, but every so often it's more useful to instead isolate the exact values that were updated (rather than the whole records).
In this office hours, Josh Andrews from OnPrem Solution Partners shares his approach for identifying changed key-value pairs on top of a snapshot. Hint: it involves some pretty complex dbt macros, but under the hood, everything's a select statement 😉
