How do you store events on the same order that are happening at different points in time? E.g. order received, order ready for shipment , order shipped and order delivered could be days apart. Going back to update the same record and add another element to the array doesn’t seem right and more like an anti pattern
Run through session at the end was amazing, thanks!
how to study json funcitons to use json data with big query? #googlecloudplatform
How do you store events on the same order that are happening at different points in time? E.g. order received, order ready for shipment , order shipped and order delivered could be days apart. Going back to update the same record and add another element to the array doesn’t seem right and more like an anti pattern
This should be 2 step process
You should first copy data to change log table with all states and another final table where records will be upserted
Nested record
Simple and sweet presentation. Good job 👍👍
not bad...
good presentation...