BigQuery Data Transfer Service は、あらかじめ設定されたスケジュールに基づいて BigQuery へのデータの移行を自動化するマネージド サービスです。そのため、アナリティクス チームが BigQuery データ ウェアハウス基盤を構築する際にコードの作成はまったく必要ありません。
BigQuery Data Transfer Service には、以下を使用してアクセスできます。
データ転送を設定すると、BigQuery Data Transfer Service によりデータが定期的かつ自動的に BigQuery に読み込まれます。また、データのバックフィルを開始して、停止またはギャップから回復することもできます。BigQuery Data Transfer Service を使用して BigQuery からデータを転送することはできません。
BigQuery Data Transfer Service は、BigQuery へのデータの読み込みに加えて、データセットのコピーとスケジュールされたクエリの 2 つの BigQuery オペレーションでも使用されます。
サポートされるデータソース
BigQuery Data Transfer Service では、次のデータソースからのデータの読み込みがサポートされています。
BigQuery と同様に、BigQuery Data Transfer Service はマルチリージョン リソースで、多くのシングル リージョンを追加で使用できます。
BigQuery データセットのロケーションは、BigQuery Data Transfer Service によって転送されるデータを格納するための宛先データセットを作成する際に指定されます。転送を設定すると、転送構成自体は宛先データセットと同じロケーションに設定されます。BigQuery Data Transfer Service では、宛先のデータセットと同じロケーションにあるデータが処理され、ステージングされます。
[[["わかりやすい","easyToUnderstand","thumb-up"],["問題の解決に役立った","solvedMyProblem","thumb-up"],["その他","otherUp","thumb-up"]],[["わかりにくい","hardToUnderstand","thumb-down"],["情報またはサンプルコードが不正確","incorrectInformationOrSampleCode","thumb-down"],["必要な情報 / サンプルがない","missingTheInformationSamplesINeed","thumb-down"],["翻訳に関する問題","translationIssue","thumb-down"],["その他","otherDown","thumb-down"]],["最終更新日 2025-08-17 UTC。"],[[["\u003cp\u003eThe BigQuery Data Transfer Service automates the scheduled movement of data into BigQuery, allowing analytics teams to establish a data warehouse without coding.\u003c/p\u003e\n"],["\u003cp\u003eData can be loaded into BigQuery from a variety of sources including Amazon S3, Azure Blob Storage, Google Ads, Facebook Ads, and more.\u003c/p\u003e\n"],["\u003cp\u003eThe service supports data transfers into BigQuery, as well as BigQuery operations such as dataset copies and scheduled queries.\u003c/p\u003e\n"],["\u003cp\u003eThe 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.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery Data Transfer Service has its pricing, quotas and limits, and when data is transferred to BigQuery, standard storage and query pricing apply.\u003c/p\u003e\n"]]],[],null,["# What is BigQuery Data Transfer Service?\n=======================================\n\nThe BigQuery Data Transfer Service automates data movement into [BigQuery](/bigquery/docs/introduction)\non a scheduled, managed basis. Your analytics team can lay the foundation for a\nBigQuery data warehouse without writing a single line of code.\n\nYou can access the BigQuery Data Transfer Service using the:\n\n- [Google Cloud console](/bigquery/docs/bigquery-web-ui)\n- [bq command-line tool](/bigquery/docs/reference/bq-cli-reference)\n- [BigQuery Data Transfer Service API](/bigquery-transfer/docs/reference/datatransfer/rest)\n\nAfter you configure a data transfer, the BigQuery Data Transfer Service automatically\nloads data into BigQuery on a regular basis. You can also\ninitiate data backfills to recover from any outages or gaps. You\ncannot use the BigQuery Data Transfer Service to transfer data out of\nBigQuery.\n\nIn addition to loading data into BigQuery,\nBigQuery Data Transfer Service is used for two BigQuery operations:\n[dataset copies](/bigquery/docs/copying-datasets) and\n[scheduled queries](/bigquery/docs/scheduling-queries).\n| **Note:** Subscribe to the [BigQuery DTS announcements group](https://groups.google.com/g/bigquery-dts-announcements) to receive announcements related to the BigQuery Data Transfer Service.\n\nSupported data sources\n----------------------\n\nThe BigQuery Data Transfer Service supports loading data from the following data sources:\n\n- [Amazon S3](/bigquery/docs/s3-transfer)\n- [Amazon Redshift](/bigquery/docs/migration/redshift)\n- [Azure Blob Storage](/bigquery/docs/blob-storage-transfer)\n- [Campaign Manager](/bigquery/docs/doubleclick-campaign-transfer)\n- [Cloud Storage](/bigquery/docs/cloud-storage-transfer)\n- [Comparison Shopping Service (CSS) Center](/bigquery/docs/css-center-transfer-schedule-transfers) ([Preview](/products#product-launch-stages))\n- [Display \\& Video 360](/bigquery/docs/display-video-transfer)\n- [Facebook Ads](/bigquery/docs/facebook-ads-transfer) ([Preview](/products#product-launch-stages))\n- [Google Ad Manager](/bigquery/docs/doubleclick-publisher-transfer)\n- [Google Ads](/bigquery/docs/google-ads-transfer)\n- [Google Analytics 4](/bigquery/docs/google-analytics-4-transfer) ([Preview](/products#product-launch-stages))\n- [Google Merchant Center](/bigquery/docs/merchant-center-transfer) ([Preview](/products#product-launch-stages))\n- [Google Play](/bigquery/docs/play-transfer)\n- [MySQL](/bigquery/docs/mysql-transfer) ([Preview](/products#product-launch-stages))\n- [Oracle](/bigquery/docs/oracle-transfer) ([Preview](/products#product-launch-stages))\n- [PostgreSQL](/bigquery/docs/postgresql-transfer) ([Preview](/products#product-launch-stages))\n- [Salesforce](/bigquery/docs/salesforce-transfer) ([Preview](/products#product-launch-stages))\n- [Salesforce Marketing Cloud](/bigquery/docs/sfmc-transfer) ([Preview](/products#product-launch-stages))\n- [Search Ads 360](/bigquery/docs/search-ads-transfer)\n- [ServiceNow](/bigquery/docs/servicenow-transfer) ([Preview](/products#product-launch-stages))\n- [Teradata](/bigquery/docs/migration/teradata)\n- [YouTube Channel](/bigquery/docs/youtube-channel-transfer)\n- [YouTube Content Owner](/bigquery/docs/youtube-content-owner-transfer)\n\nSupported regions\n-----------------\n\nLike BigQuery, the BigQuery Data Transfer Service is a\n[multi-regional resource](/docs/geography-and-regions#regional_resources), with many additional single regions available.\n\nA BigQuery dataset's locality is specified when you\n[create a destination dataset](/bigquery/docs/datasets) to store the data\ntransferred by the BigQuery Data Transfer Service. When you set up a transfer, the\ntransfer configuration itself is set to the same location as the destination\ndataset. The BigQuery Data Transfer Service processes and stages data in the same\nlocation as the destination dataset.\n\nThe data you want to transfer to BigQuery can also have a region. In most\ncases, the region where your data is stored and the location of\nthe destination dataset in BigQuery are irrelevant. In other kinds of\ntransfers, the dataset and the source data must be *colocated* in the\nsame region, or a compatible region.\n\nFor detailed information about transfers and region compatibility for\nBigQuery Data Transfer Service, see [Dataset locations and transfers](/bigquery/docs/dts-locations).\nFor supported regions for BigQuery, see [Dataset locations](/bigquery/docs/locations#supported_locations).\n\nUsing reservation slots with data transfers\n-------------------------------------------\n\nJobs triggered by the BigQuery Data Transfer Service only use reservation slots if the\nproject, folder, or organization is assigned to a reservation with any of the\nfollowing [job types](/bigquery/docs/reservations-workload-management#assignments):\n\n- Query jobs using `QUERY`\n- Load jobs using `PIPELINE`\n\nJobs that [copy datasets](/bigquery/docs/managing-datasets#copy-datasets)\ndon't use reservation slots.\n\nPricing\n-------\n\nFor information on BigQuery Data Transfer Service pricing, see the\n[Pricing](/bigquery/pricing) page.\n\nOnce data is transferred to BigQuery, standard\nBigQuery [storage](/bigquery/pricing#storage) and\n[query](/bigquery/pricing#queries) pricing applies.\n\nQuotas\n------\n\nFor information on BigQuery Data Transfer Service quotas, see the\n[Quotas and limits](/bigquery/quotas) page.\n\nWhat's next\n-----------\n\nTo learn how to create a transfer, see the documentation for your\n[data source](#supported_data_sources)."]]