A data analytics team needs to ingest reporting data on a recurring daily schedule from SaaS platforms, including Salesforce and Google Ads, directly into BigQuery for analysis. The team has the following requirements: The solution must be fully managed and serverless. Data movement must occur automatically on a regular, predefined schedule. The setup should require no coding or custom pipeline development. Which Google Cloud service should the team use?

BigQuery Data Transfer Service: ### **What BigQuery Data Transfer Service is:** **BigQuery Data Transfer Service (DTS)** is a fully managed service that automates data movement from software-as-a-service (SaaS) applications, third-party cloud storage, and external databases directly into **BigQuery** on a scheduled basis. ### **How it meets the requirements:** - **Pre-built SaaS connectors (✓):** Native support for applications such as **Salesforce**, **Google Ads**, **Google Analytics 4**, and **Campaign Manager** without custom code. - **Automated scheduling (✓):** Supports automated, recurring execution (e.g., daily runs) and provides automated backfills to recover from data gaps. - **No-code configuration (✓):** Analytics teams can configure transfers entirely via the Google Cloud console, `bq` command-line tool, or API without building data pipelines. - **Direct BigQuery destination (✓):** Loads data directly into target BigQuery datasets and automatically maps source schemas to BigQuery data types. ### **Key advantages:** - **Zero pipeline maintenance:** Google manages the underlying compute, retries, and data ingestion infrastructure. - **Out-of-the-box backfill support:** Easily trigger backfill runs to back-populate historical data periods. - **Native monitoring and notifications:** Integrated with Cloud Monitoring, email alerts, and Pub/Sub notifications for transfer status tracking. - **SLO coverage:** Google Cloud provides Data Delivery Service Level Objectives (SLOs) for transfers from supported internal Google sources. ### **Why this is optimal:** BigQuery Data Transfer Service is purpose-built for loading SaaS and external source data directly into BigQuery on a managed schedule. Unlike Dataflow or Cloud Data Fusion, it eliminates the need to author code, build transformation graphs, or manage execution clusters.