데이터 전송을 구성하면 BigQuery Data Transfer Service가 정기적으로 데이터를 BigQuery로 자동 로드합니다. 중단이나 불일치 문제를 해결하기 위해 데이터 백필을 시작할 수도 있습니다. BigQuery Data Transfer Service를 사용하여 BigQuery에서 다른 곳으로 데이터를 전송할 수 없습니다.
BigQuery Data Transfer Service는 BigQuery에 데이터를 로드하는 것 외에도 데이터 세트 사본과 예약된 쿼리의 두 가지 BigQuery 작업에 사용됩니다.
지원되는 데이터 소스
BigQuery Data Transfer Service는 다음 데이터 소스에서 데이터 로드를 지원합니다.
BigQuery와 마찬가지로 BigQuery Data Transfer Service는 여러 단일 리전을 사용할 수 있는 멀티 리전 리소스입니다.
BigQuery 데이터 세트의 지역은 BigQuery Data Transfer Service로 전송되는 데이터를 저장하기 위해 대상 데이터 세트를 만들 때 지정됩니다. 전송을 설정할 때 전송 구성은 대상 데이터세트와 동일한 위치에 설정됩니다. BigQuery Data Transfer Service는 대상 데이터 세트와 동일한 위치에서 데이터를 처리하고 스테이징합니다.
BigQuery로 전송할 데이터에는 리전이 있을 수도 있습니다. 대부분의 경우 데이터가 저장되는 리전과 BigQuery에서 대상 데이터 세트의 위치는 관련성이 없습니다. 다른 유형의 전송에서는 데이터 세트와 소스 데이터가 동일한 리전 또는 호환되는 리전의 같은 위치에 배치되어야 합니다.
BigQuery Data Transfer Service의 전송 및 리전 호환성에 대한 자세한 내용은 데이터 세트 위치 및 전송을 참조하세요.
BigQuery에서 지원되는 리전은 데이터 세트 위치를 참조하세요.
가격 책정
BigQuery Data Transfer Service 가격에 대한 자세한 내용은 가격 책정 페이지를 참조하세요.
데이터가 BigQuery로 전송되면 표준 BigQuery 스토리지와 쿼리 가격 책정이 적용됩니다.
할당량
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-03-24(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)."]]
