> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-parallel-read-in-order-multi-part.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> List of format settings for the JSON format

# Format Settings For JSON

On this page you can find format settings common to all JSON formats.

| Setting | Description | Default | Note |
| - | - | - | - |
| [`input_format_import_nested_json`](/reference/settings/formats/input-format#input_format_import_nested_json) | Map nested JSON data to nested tables (it works for JSONEachRow format). | `false` | |
| [`input_format_json_read_bools_as_numbers`](/reference/settings/formats/input-format#input_format_json_read_bools_as_numbers) | Allow to parse bools as numbers in JSON input formats. | `true` | |
| [`input_format_json_read_bools_as_strings`](/reference/settings/formats/input-format#input_format_json_read_bools_as_strings) | Allow to parse bools as strings in JSON input formats. | `true` | |
| [`input_format_json_read_numbers_as_strings`](/reference/settings/formats/input-format#input_format_json_read_numbers_as_strings) | Allow to parse numbers as strings in JSON input formats. | `true` | |
| [`input_format_json_read_arrays_as_strings`](/reference/settings/formats/input-format#input_format_json_read_arrays_as_strings) | Allow to parse JSON arrays as strings in JSON input formats. | `true` | |
| [`input_format_json_read_objects_as_strings`](/reference/settings/formats/input-format#input_format_json_read_objects_as_strings) | Allow to parse JSON objects as strings in JSON input formats. | `true` | |
| [`input_format_json_named_tuples_as_objects`](/reference/settings/formats/input-format#input_format_json_named_tuples_as_objects) | Parse named tuple columns as JSON objects. | `true` | |
| [`input_format_json_try_infer_numbers_from_strings`](/reference/settings/formats/input-format#input_format_json_try_infer_numbers_from_strings) | Try to infer numbers from string fields while schema inference. | `false` | |
| [`input_format_json_try_infer_named_tuples_from_objects`](/reference/settings/formats/input-format#input_format_json_try_infer_named_tuples_from_objects) | Try to infer named tuple from JSON objects during schema inference. | `true` | |
| [`input_format_json_infer_incomplete_types_as_strings`](/reference/settings/formats/input-format#input_format_json_infer_incomplete_types_as_strings) | Use type String for keys that contains only Nulls or empty objects/arrays during schema inference in JSON input formats. | `true` | |
| [`input_format_json_defaults_for_missing_elements_in_named_tuple`](/reference/settings/formats/input-format#input_format_json_defaults_for_missing_elements_in_named_tuple) | Insert default values for missing elements in JSON object while parsing named tuple. | `true` | |
| [`input_format_json_ignore_unknown_keys_in_named_tuple`](/reference/settings/formats/input-format#input_format_json_ignore_unknown_keys_in_named_tuple) | Ignore unknown keys in json object for named tuples. | `false` | |
| [`input_format_json_compact_allow_variable_number_of_columns`](/reference/settings/formats/input-format#input_format_json_compact_allow_variable_number_of_columns) | Allow variable number of columns in JSONCompact/JSONCompactEachRow format, ignore extra columns and use default values on missing columns. | `false` | |
| [`input_format_json_throw_on_bad_escape_sequence`](/reference/settings/formats/input-format#input_format_json_throw_on_bad_escape_sequence) | Throw an exception if JSON string contains bad escape sequence. If disabled, bad escape sequences will remain as is in the data. | `true` | |
| [`input_format_json_empty_as_default`](/reference/settings/formats/input-format#input_format_json_empty_as_default) | Treat empty fields in JSON input as default values. | `false` | For complex default expressions [input\_format\_defaults\_for\_omitted\_fields](/reference/settings/formats/input-format#input_format_defaults_for_omitted_fields) must be enabled too. |
| [`output_format_json_quote_64bit_integers`](/reference/settings/formats/output-format#output_format_json_quote_64bit_integers) | Controls quoting of 64-bit or bigger integers in JSON output format. | `false` | |
| [`output_format_json_quote_64bit_floats`](/reference/settings/formats/output-format#output_format_json_quote_64bit_floats) | Controls quoting of 64-bit floats in JSON output format. | `false` | |
| [`output_format_json_quote_denormals`](/reference/settings/formats/output-format#output_format_json_quote_denormals) | Enables '+nan', '-nan', '+inf', '-inf' outputs in JSON output format. | `false` | |
| [`output_format_json_quote_decimals`](/reference/settings/formats/output-format#output_format_json_quote_decimals) | Controls quoting of decimals in JSON output format. | `false` | |
| [`output_format_json_escape_forward_slashes`](/reference/settings/formats/output-format#output_format_json_escape_forward_slashes) | Controls escaping forward slashes for string outputs in JSON output format. | `true` | |
| [`output_format_json_named_tuples_as_objects`](/reference/settings/formats/output-format#output_format_json_named_tuples_as_objects) | Serialize named tuple columns as JSON objects. | `true` | |
| [`output_format_json_array_of_rows`](/reference/settings/formats/output-format#output_format_json_array_of_rows) | Output a JSON array of all rows in JSONEachRow(Compact) format. | `false` | |
| [`output_format_json_validate_utf8`](/reference/settings/formats/output-format#output_format_json_validate_utf8) | Enables validation of UTF-8 sequences in JSON output formats | `false` | Note that it doesn't impact formats JSON/JSONCompact/JSONColumnsWithMetadata, they always validate utf8. |