Diagram
A decision tree that branches on BigQuery analytics need and dataset size to pick BigQuery Data Transfer Service, Storage Transfer Service, or Transfer Appliance.
Scheduled Analytics Transfer with BigQuery Data Transfer Service
The three bulk-transfer options differ by source, destination, and trigger, so the choice depends on where data starts and where it must land:
| Transfer option | Source to destination | Choose when |
|---|---|---|
| Storage Transfer Service | S3, Blob, Data Lake, or on-premises files to Cloud Storage | Data is reachable online and the target is object storage |
| Transfer Appliance | On-premises data via shipped hardware to Google Cloud | Data exceeds 20 TB up to 1 petabyte and network transfer would disrupt operations |
| BigQuery Data Transfer Service | SaaS apps, Teradata, or Redshift to BigQuery | Analytics data needs scheduled, managed loading into BigQuery |
Domain 2 of 4
23 practice questions
Practice this DomainLast updated