JSON

Converts JSON data to SQL DDL statements

Assumptions

  • Nested JSON is flattened by default
  • You can generate normalized DDL by selecting Normalize JSON option
    • Note: JSON to Normalized SQL only generates DDL

  • Numeric values are mapped to decimal(10,4) SQL datatype
  • Text values are mapped to varchar(64) datatype