QuestionQ91

VerifiedIngesting and processing the data

You are integrating a legacy, on-premises MySQL database with a new Google Cloud data warehouse. The database holds historical customer loyalty data that must be extracted each day and loaded into BigQuery. You want a secure, managed integration solution that supports incremental loads. What should you do?

Explanation

BigQuery Data Transfer Service provides a managed MySQL connector for MySQL instances hosted on premises and can run recurring scheduled transfers into BigQuery. Its incremental-transfer mode loads only data changed since the prior transfer, with append or upsert write modes.

Learn more

Community Discussion

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