Stay organized with collections Save and categorize content based on your preferences.
What is BigQuery Data Transfer Service?The BigQuery Data Transfer Service automates data movement into BigQuery on a scheduled, managed basis. Your analytics team can lay the foundation for a BigQuery data warehouse without writing a single line of code.
You can access the BigQuery Data Transfer Service using the:
After you configure a data transfer, the BigQuery Data Transfer Service automatically loads data into BigQuery on a regular basis. You can also initiate data backfills to recover from any outages or gaps. You cannot use the BigQuery Data Transfer Service to transfer data out of BigQuery.
In addition to loading data into BigQuery, BigQuery Data Transfer Service is used for two BigQuery operations: dataset copies and scheduled queries.
Note: Subscribe to the BigQuery DTS announcements group to receive announcements related to the BigQuery Data Transfer Service. Supported data sourcesThe BigQuery Data Transfer Service supports loading data from the following data sources:
Like BigQuery, the BigQuery Data Transfer Service is a multi-regional resource, with many additional single regions available.
A BigQuery dataset's locality is specified when you create a destination dataset to store the data transferred by the BigQuery Data Transfer Service. When you set up a transfer, the transfer configuration itself is set to the same location as the destination dataset. The BigQuery Data Transfer Service processes and stages data in the same location as the destination dataset.
The data you want to transfer to BigQuery can also have a region. In most cases, the region where your data is stored and the location of the destination dataset in BigQuery are irrelevant. In other kinds of transfers, the dataset and the source data must be colocated in the same region, or a compatible region.
For detailed information about transfers and region compatibility for BigQuery Data Transfer Service, see Dataset locations and transfers. For supported regions for BigQuery, see Dataset locations.
Using reservation slots with data transfersJobs triggered by the BigQuery Data Transfer Service only use reservation slots if the project, folder, or organization is assigned to a reservation with any of the following job types:
QUERYPIPELINEJobs that copy datasets don't use reservation slots.
PricingFor information on BigQuery Data Transfer Service pricing, see the Pricing page.
Once data is transferred to BigQuery, standard BigQuery storage and query pricing applies.
QuotasFor information on BigQuery Data Transfer Service quotas, see the Quotas and limits page.
What's nextTo learn how to create a transfer, see the documentation for your data source.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-07-16 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-16 UTC."],[[["The BigQuery Data Transfer Service automates the scheduled movement of data into BigQuery, allowing analytics teams to establish a data warehouse without coding."],["Data can be loaded into BigQuery from a variety of sources including Amazon S3, Azure Blob Storage, Google Ads, Facebook Ads, and more."],["The service supports data transfers into BigQuery, as well as BigQuery operations such as dataset copies and scheduled queries."],["The BigQuery Data Transfer Service operates as a multi-regional resource, and the data transfer configuration and processing occur in the same location as the destination dataset."],["BigQuery Data Transfer Service has its pricing, quotas and limits, and when data is transferred to BigQuery, standard storage and query pricing apply."]]],[]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4