You are migrating a table to BigQuery and are deciding on the data model. Your table stores information related to purchases made across several store locations and includes information like the time of the transaction, items purchased, the store ID, and the city and state in which the store is located. You frequently query this table to see how many of each item were sold over the past 30 days and to look at purchasing trends by state, city, and individual store. How would you model this table for the best query performance?
AWSandeep
Highly Voted 2 years, 10 months agoAtnafu
Highly Voted 2 years, 6 months agoSamuelTsch
Most Recent 8 months, 2 weeks agoMaxNRG
1 year, 6 months agoMaxNRG
1 year, 6 months agoMaxNRG
1 year, 6 months agotibuenoc
1 year, 7 months agoffggrre
1 year, 8 months agosylva1212
11 months, 1 week agoaureole
1 year, 9 months agoaureole
1 year, 9 months agovaga1
2 years, 1 month agoPrakzz
2 years, 6 months agozellck
2 years, 7 months agoTNT87
2 years, 10 months agoducc
2 years, 10 months ago