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 intoBigQueryon a scheduled, managed basis. Your analytics team can lay the foundation for aBigQuery 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 automaticallyloads data into BigQuery on a regular basis. You can alsoinitiate data backfills to recover from any outages or gaps. Youcannot use the BigQuery Data Transfer Service to transfer data out ofBigQuery.

In addition to loading data into BigQuery,BigQuery Data Transfer Service is used for two BigQuery operations:dataset copies andscheduled queries.

Note: Subscribe to theBigQuery DTS announcements group to receive announcements related to the BigQuery Data Transfer Service.

Supported data sources

The BigQuery Data Transfer Service supports loading data from the following data sources:

Supported regions

Like BigQuery, the BigQuery Data Transfer Service is amulti-regional resource, with many additional single regions available.

A BigQuery dataset's locality is specified when youcreate a destination dataset to store the datatransferred by the BigQuery Data Transfer Service. When you set up a transfer, thetransfer configuration itself is set to the same location as the destinationdataset. The BigQuery Data Transfer Service processes and stages data in the samelocation as the destination dataset.

The data you want to transfer to BigQuery can also have a region. In mostcases, the region where your data is stored and the location ofthe destination dataset in BigQuery are irrelevant. In other kinds oftransfers, the dataset and the source data must becolocated in thesame region, or a compatible region.

For detailed information about transfers and region compatibility forBigQuery Data Transfer Service, seeDataset locations and transfers.For supported regions for BigQuery, seeDataset locations.

Pricing

For information on BigQuery Data Transfer Service pricing, see thePricing page.

Once data is transferred to BigQuery, standardBigQuerystorage andquery pricing applies.

Quotas

For information on BigQuery Data Transfer Service quotas, see theQuotas and limits page.

What's next

To learn how to create a transfer, see the documentation for yourdata source.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-03-05 UTC.