Big Data, Sql, Bigquery, Google Cloud Platform, Data.
are two independent things that cannot be grouped together. The nested format is complex. I might be used to working with it, and maybe you are too, but that is not the case for all your users. Take this into account; optimization is not always financial. A flattened, denormalized format is easier