medium10 pts · first answer countsdata-modellingwarehouse-design
Clustering a partitioned table
A BigQuery events table is partitioned by event_date. Most queries also filter by customer_id within a few days. What should you add?
Discussion 0
Join free to post in the discussion.
Related questions
- Primary key for order linesData Engineer
- Modelling doctors and patientsData Engineer
- Several phones in one columnData Engineer
- Several unique columnsData Engineer
- Picking the natural keyData Engineer
- Reading crow's foot notationData Engineer
- The model with indexes and typesData Engineer
- Why denormalise a reporting tableData Engineer