BigQuery Tips: Nested and Repeated Fields and How GOJEK Builds Data Warehouses (Cloud Next '19)

[@puneetbhatia2326]

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

[@dokwme1211]

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

[@vsivam]

Nested record

[@pulkitdikshit6148]

how to study json funcitons to use json data with big query? #googlecloudplatform

[@Pirake123]

Run through session at the end was amazing, thanks!

[@rajkishormahanada6223]

Simple and sweet presentation. Good job 👍👍

[@tahsinature]

not bad... good presentation...