Professional Data Engineer

By Google · Question Mode

QuestionQ55

Storing the data

You are designing BigQuery tables for high volumes of clickstream event data. Your data analyst team will most often query specific event-date ranges and filter on the user ID UUID. You want to optimize the table structure for query cost and performance. What should you do?

Explanation

Partitioning on the event date allows BigQuery to prune nonmatching date partitions, reducing bytes scanned for date-range queries. Clustering the data within each date partition by user ID lets BigQuery prune blocks for UUID filters, improving performance and reducing query cost.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!