BigQuery Data Transfer Service を使用すると、BigQuery へのデータ読み込みパイプラインを自動化するために、読み込みジョブをスケジュール設定できます。1 回限りまたはバッチのデータ転送を定期的な間隔（毎日、毎月など）でスケジュールできます。BigQuery データが常に最新の状態になるように、転送をモニタリングしてログに記録できます。
BigQuery Data Transfer Service でサポートされているデータソースの一覧については、サポートされているデータソースをご覧ください。
BigQuery では、外部接続を作成して、Cloud Storage や Spanner などの Google Cloud サービス、または Amazon Web Services（AWS）や Microsoft Azure などのサードパーティ ソースに保存されている、BigQuery 外のデータをクエリできます。これらの外部接続では、BigQuery Connection API を使用します。詳細については、接続の概要をご覧ください。
[[["わかりやすい","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-09-04 UTC。"],[[["\u003cp\u003eBigQuery supports two primary data integration approaches: Extract, Load, Transform (ELT) and Extract, Transform, Load (ETL).\u003c/p\u003e\n"],["\u003cp\u003eData can be loaded into BigQuery using batch loading for large datasets, streaming for near real-time data, or Change Data Capture (CDC) for replicating database changes in near real time.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery allows federation to external data sources, enabling access without requiring data to be loaded into BigQuery itself.\u003c/p\u003e\n"],["\u003cp\u003eProgrammatic methods include creating load jobs for batch loading data from Cloud Storage or local files, as well as using Dataflow or the BigQuery Storage Write API for streaming data from custom sources.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery offers alternative ways to access data without direct loading such as Public datasets, shared datasets via Analytics Hub, and log data from Cloud Logging or Log Analytics.\u003c/p\u003e\n"]]],[],null,["# Introduction to loading data\n============================\n\nThis document explains how you can load data into BigQuery. The two\ncommon approaches to data integration are to extract, load, and\ntransform (ELT) or to extract, transform, load (ETL) data.\n\nFor an overview of ELT and ETL approaches, see\n[Introduction to loading, transforming, and exporting data](/bigquery/docs/load-transform-export-intro).\n\nMethods of loading or accessing external data\n---------------------------------------------\n\nIn the BigQuery page, in the\n[**Add data** dialog](/bigquery/docs/bigquery-web-ui#add_data), you can view all\navailable methods to load data into BigQuery or access data from\nBigQuery. Choose one of the following options based on your use\ncase and data sources:\n\nYou can also use the following programmatic methods to load the data:\n\n[Cloud Data Fusion](/data-fusion/docs/concepts/overview) can help facilitate your ETL process. BigQuery also works with\n[3rd party partners that transform and load data into BigQuery](/bigquery/docs/bigquery-ready-partners#etl-data-integration).\n\nBigQuery lets you create external connections to query data that's\nstored outside of BigQuery in Google Cloud services like\nCloud Storage or Spanner, or in third-party sources like\nAmazon Web Services (AWS) or Microsoft Azure. These external connections use the\nBigQuery Connection API. For more information, see [Introduction to connections](/bigquery/docs/connections-api-intro).\n\nOther ways to acquire data\n--------------------------\n\nYou can run queries on data without loading it into BigQuery\nyourself. The following sections describe some alternatives.\n\nThe following list describes some of the alternatives:\n\n### Run queries on public data\n\nPublic datasets are datasets stored in BigQuery and shared with\nthe public. For more information, see\n[BigQuery public datasets](/bigquery/public-data).\n\n### Run queries on shared data\n\nTo run queries on a BigQuery dataset that someone has shared\nwith you, see\n[Introduction to BigQuery sharing (formerly Analytics Hub)](/bigquery/docs/analytics-hub-introduction). Sharing is a data\nexchange platform that enables data sharing.\n\n### Run queries with log data\n\nYou can run queries on logs without creating additional load jobs:\n\n- **Cloud Logging** lets you\n [route logs to a BigQuery destination](/logging/docs/export/configure_export).\n\n- **Log Analytics** lets you\n [run queries that analyze your log data](/logging/docs/log-analytics#analytics).\n\nWhat's next\n-----------\n\n- Learn how to [prepare data](/bigquery/docs/data-prep-introduction) with Gemini in BigQuery.\n- Learn more about transforming data with [Dataform](/dataform/docs/overview).\n- Learn more about monitoring load jobs in the [administrative jobs explorer](/bigquery/docs/admin-jobs-explorer) and [BigQuery metrics](/monitoring/api/metrics_gcp_a_b#gcp-bigquery)."]]
