Associate Data Practitioner

By Google · Question Mode

QuestionQ19

Data Pipeline Orchestration

Your team uses the Google Ads platform for metric visualization. You want to export the data to BigQuery for more granular insights. You must run a one-time transfer of historical data and automatically refresh the data each day. You want a low-code, serverless solution that requires minimal maintenance. What should you do?

Explanation

BigQuery Data Transfer Service has a Google Ads connector that loads Google Ads data into BigQuery, supports daily scheduled transfers, and allows backfill runs to retrieve historical data outside the normal refresh window. It provides the required managed, low-code automation without operating Cloud Composer, Dataflow, or a separate storage pipeline.

Learn more

Community Discussion

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