QuestionQ88

VerifiedData Pipeline Orchestration

An organization’s ecommerce website gathers user-activity logs through a Pub/Sub topic. Its leadership team needs a dashboard containing aggregated user-engagement metrics. You must create a solution that converts the user-activity logs into aggregated metrics while making sure the raw data remains easy to query. What should you do?

Explanation

A Pub/Sub BigQuery subscription writes incoming messages directly to a BigQuery table, so the raw activity logs remain available for SQL queries. A BigQuery materialized view stores precomputed results of a SQL query and is appropriate for repeatedly queried aggregate metrics such as dashboard engagement measures; it is updated as its base table changes.

Learn more

Community Discussion

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