Free · No sign-up · Runs in your browser
JSON to BigQuery Schema Generator
Infer a BigQuery table schema from JSON records to prepare newline-delimited JSON loads.
STEP 1
Start with your input
Edit the example or replace it with your own text.
How to use JSON to BigQuery Schema Generator
- Paste or edit the json object or array of records.
- Select generate bigquery schema to process it in your browser.
- Review the result, then copy it or download the generated file.
Create JSON to BigQuery Schema output
Infers STRING, INTEGER, FLOAT, BOOLEAN, RECORD and repeated fields from samples. Schema inference is a draft; confirm nullable fields, precision and nested record modes before loading production data.
Review before importing or running
Generated output is a starting point for your workflow. Check target-specific names, permissions, field types and limits before importing data or running commands.
Example input
[{"id":1,"name":"Ada","active":true},{"id":2,"name":"Linus","active":false}]Is my input uploaded?
No. This conversion runs in your browser and does not upload your input.
Is input uploaded?
Processing takes place in your browser. This tool does not send your input or selected files to a conversion API.