Accurate conversion
Input is processed by this tool’s dedicated converter.
Offline engine (processed locally)SQL v1.0.0 Spec
JSON to BigQuery
v1.0.0Transform your JSON data structure into a BigQuery-compatible schema definition. This online converter infers field names, types, and nested records, making it easy to load JSON into Google BigQuery. A time-saver for data engineers and analysts. Free and client-side, no sign-up needed.
—ms
JSONInput (JSON)Invalid
lines: 1chars: 28Size: 28 BUTF-8
SQLOutput (SQL)
Auto-generated
Converted output will appear herelines: 0chars: 0Size: 0 BUTF-8
Size change: -100.00%TOML compliant: v1.0.0Tool guide
Local processing
Your input is processed in your browser and is not uploaded.
Ready-to-use output
Copy the result or save it as a file.