# How to Load Data From JSON to BigQuery (3 Easy Methods)

DevFeed: [How to Load Data From JSON to BigQuery (3 Easy Methods)](<https://devfeed.tech/articles/how-to-load-data-from-json-to-bigquery-3-easy-methods-126851.md>)

Original publisher: [Read original article](<https://estuary.dev/blog/json-to-bigquery>)

Author: Jeffrey Richman

Published: 2023-10-24T19:57:17Z

Content type: tutorial

Language: en

Sources: [Estuary](<https://devfeed.tech/sources/estuary.md>)

Topics: [BigQuery](<https://devfeed.tech/topics/bigquery.md>), [JSON](<https://devfeed.tech/topics/json.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [json lines format](<https://devfeed.tech/topics/json-lines-format.md>)

Tags: [3](<https://devfeed.tech/tags/3.md>), [analysis](<https://devfeed.tech/tags/analysis.md>), [automated](<https://devfeed.tech/tags/automated.md>), [bigquery](<https://devfeed.tech/tags/bigquery.md>), [easy](<https://devfeed.tech/tags/easy.md>), [export](<https://devfeed.tech/tags/export.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [json](<https://devfeed.tech/tags/json.md>), [load](<https://devfeed.tech/tags/load.md>)

## AI overview

BigQuery's bq CLI and Cloud Console load newline-delimited JSON (JSONL), so regular JSON with comma-separated objects must be reformatted. The CLI workflow uses Cloud Shell, a project and dataset, and `bq load` with a source path and schema; the Console workflow creates a dataset and table, lets users choose a source and enter or auto-detect the schema, and offers optional partition and clustering settings. The article also describes Estuary's no-code pipeline: capture JSON from an HTTP endpoint, configure BigQuery as the destination, and publish for continuous near-real-time synchronization. Manual methods must be repeated as data changes. The text notes that schema autodetection can miss nested arrays, incorrect schemas may prevent loading, and Cloud Storage object versioning is unsupported with no guaranteed consistency for external sources.

## Source excerpt

Discover efficient ways to export JSON data to BigQuery for advanced analysis and integration with diverse technologies. Learn manual and automated methods in this article.