[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-08-17。"],[[["\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)."]]
