Big Data, Sql, Bigquery, Google Cloud Platform, Data.
granularity of the receipt details. Preview of denormalized basket design (Image from author) While querying data is made easier with this table schema, it contains redundant data. Here, the header data is repeated for each of its lines. This adds redundancy and a risk of inconsistency. Moreover,