QuestionQ89

VerifiedData Pipeline Orchestration

Your organization is analyzing regional sales metrics. Each regional sales team's data is kept in separate BigQuery tables and is updated monthly. You need to build a solution that identifies the three regions with the highest monthly sales for the next three months, and it must automatically deliver up-to-date results. What should you do?

Explanation

A materialized view is maintained from its base tables and is appropriate for serving refreshed derived results. A UNION consolidates rows from separate regional sales tables into one regional-sales result set; a CROSS JOIN would instead create a Cartesian product and corrupt the analysis. BigQuery supports RANK() as a window numbering function, allowing the consolidated data to be ranked by monthly sales when the materialized view is queried.

Learn more

Community Discussion

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