JSON to BigQuery Converter

Convert JSON to BigQuery schema.

☁️ BigQuery Data Type Mapping

The tool uses the following logic to map JSON types to BigQuery types:

  • STRING: Any text or ISO-8601 strings (though timestamps are prioritized).
  • INT64: Whole numbers without decimal points.
  • FLOAT64: Numbers with decimal points.
  • BOOLEAN: True or False values.
  • RECORD: Nested JSON objects.
  • REPEATED: JSON arrays (as the mode for a field).