QuestionQ136

VerifiedDesigning data processing systems

You have terabytes of customer behavioral data streaming daily from Google Analytics into BigQuery. Your customers’ information, including their preferences, is hosted in a Cloud SQL for MySQL database. Your CRM database runs on a Cloud SQL for PostgreSQL instance. The marketing team wants to use customer information from both databases and the customer behavioral data to create marketing campaigns for yearly active customers.

You need to ensure that the marketing team can run the campaigns more than 100 times per day on typical days and up to 300 times during sales. At the same time, you want to minimize the load on the Cloud SQL databases. What should you do?

Explanation

Datastream continuously replicates the required Cloud SQL MySQL and PostgreSQL tables into BigQuery using change data capture, so campaign queries can join replicated customer and CRM data with Google Analytics data entirely in BigQuery. This supports frequent analytical queries without repeatedly querying the operational Cloud SQL databases.

Learn more

Community Discussion

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