JSON to BigQuery schema
Create a BigQuery table schema (name, type, mode) from a sample JSON row, with RECORD, REPEATED, TIMESTAMP and DATE detected for you.
Frequently asked questions
How do I use the schema?
Save it as schema.json and run: bq mk --table mydataset.orders schema.json, or paste it into the BigQuery console under "Edit as text".
Why is a field JSON?
BigQuery cannot store an array of arrays or a value that changes type between rows, so those become a JSON column.
Is JSON to BigQuery schema free?
Yes. JSON to BigQuery schema is free to use. You get 3 free conversions a day without an account, and unlimited use when you sign in with Google.
Are my files uploaded?
No. The conversion runs inside your browser, so your files stay on your device and are never sent to our servers.
Does it work on mobile?
Yes. PixKaro works in Chrome, Safari, Edge and Firefox on Android, iPhone, Windows and Mac.