By comparing 2 records in two BigQuery tables, is there a way to determine if they are the same or not?
If we are comparing 2 records (say a customer record from yesterday and today), is there a way to know if there was at least one change (one value for one of the attributes was changed) without having to compare the values for each attribute?
+3
FZF
source
to share
1 answer
No, you need to explicitly compare each column.
Note that you HASH()
might find it useful when doing bulk comparisons, but you still have to compare field by field to get the final answer.
+3
Jeremy Condit
source
to share