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

# Format Settings

> Settings which control input and output formats.

export const BetaBadge = ({link, galaxyTrack, galaxyEvent}) => {
  if (link) {
    return <a href={link} target="_blank" rel="noopener noreferrer" className="betaBadge" onClick={galaxyTrack && galaxyEvent ? galaxyOnClick(galaxyEvent) : undefined}>
                <span>Beta</span>
            </a>;
  }
  return <a href="/reference/settings/beta-and-experimental-features#beta-features" className="betaBadge">
            <span>Beta feature</span>
        </a>;
};

export const ExperimentalBadge = () => {
  return <a href="/reference/settings/beta-and-experimental-features#experimental-features" className="experimentalBadge">
            <div className="experimentalIcon">
            <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                <path strokeWidth="1.25" d="M5.5 2H10.5" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
                <path strokeWidth="1.25" d="M9.50015 2V6.19625L13.4283 12.7425C13.4738 12.8183 13.4985 12.9049 13.4996 12.9934C13.5008 13.0818 13.4785 13.169 13.435 13.246C13.3914 13.323 13.3283 13.3871 13.2519 13.4317C13.1755 13.4764 13.0886 13.4999 13.0002 13.5H3.00015C2.91164 13.5 2.8247 13.4766 2.74822 13.432C2.67174 13.3874 2.60847 13.3233 2.56487 13.2463C2.52126 13.1693 2.49889 13.082 2.50004 12.9935C2.50119 12.905 2.52582 12.8184 2.5714 12.7425L6.50015 6.19625V2" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
                <path strokeWidth="1.25" d="M4.47656 9.56754C5.30344 9.41254 6.47656 9.47942 7.99969 10.25C10.0153 11.2707 11.4216 11.0569 12.2184 10.7282" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
            </svg>
        </div>
            Experimental feature
        </a>;
};

export const FormatSettingsExplorer = () => {
  const [entries] = useState(() => [{
    "label": "bool_*",
    "count": 2,
    "settings": [{
      "name": "bool_false_representation",
      "href": "/reference/settings/formats/bool#bool_false_representation",
      "default": "false"
    }, {
      "name": "bool_true_representation",
      "href": "/reference/settings/formats/bool#bool_true_representation",
      "default": "true"
    }],
    "children": []
  }, {
    "label": "date_time_*",
    "count": 4,
    "settings": [{
      "name": "date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands",
      "href": "/reference/settings/formats/date-time#date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands",
      "default": "0"
    }, {
      "name": "date_time_input_format",
      "href": "/reference/settings/formats/date-time#date_time_input_format",
      "default": "best_effort"
    }, {
      "name": "date_time_output_format",
      "href": "/reference/settings/formats/date-time#date_time_output_format",
      "default": "simple"
    }, {
      "name": "date_time_overflow_behavior",
      "href": "/reference/settings/formats/date-time#date_time_overflow_behavior",
      "default": "ignore"
    }],
    "children": []
  }, {
    "label": "format_*",
    "count": 5,
    "settings": [{
      "name": "format_display_secrets_in_show_and_select",
      "href": "/reference/settings/formats/format#format_display_secrets_in_show_and_select",
      "default": "0"
    }, {
      "name": "format_geojson_validate_geometry",
      "href": "/reference/settings/formats/format#format_geojson_validate_geometry",
      "default": "1"
    }, {
      "name": "format_json_object_each_row_column_for_object_name",
      "href": "/reference/settings/formats/format#format_json_object_each_row_column_for_object_name",
      "default": "\"\""
    }, {
      "name": "format_protobuf_use_autogenerated_schema",
      "href": "/reference/settings/formats/format#format_protobuf_use_autogenerated_schema",
      "default": "1"
    }, {
      "name": "format_tsv_null_representation",
      "href": "/reference/settings/formats/format#format_tsv_null_representation",
      "default": "\\N"
    }],
    "children": []
  }, {
    "label": "format_avro_*",
    "count": 6,
    "settings": [{
      "name": "format_avro_schema_registry_connection_timeout",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_connection_timeout",
      "default": "1"
    }, {
      "name": "format_avro_schema_registry_max_retries",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_max_retries",
      "default": "5"
    }, {
      "name": "format_avro_schema_registry_receive_timeout",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_receive_timeout",
      "default": "1"
    }, {
      "name": "format_avro_schema_registry_retry_initial_backoff_ms",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_retry_initial_backoff_ms",
      "default": "100"
    }, {
      "name": "format_avro_schema_registry_send_timeout",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_send_timeout",
      "default": "1"
    }, {
      "name": "format_avro_schema_registry_url",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_url",
      "default": "\"\""
    }],
    "children": []
  }, {
    "label": "format_binary_*",
    "count": 3,
    "settings": [{
      "name": "format_binary_max_array_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_array_size",
      "default": "1073741824"
    }, {
      "name": "format_binary_max_object_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_object_size",
      "default": "100000"
    }, {
      "name": "format_binary_max_string_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_string_size",
      "default": "1073741824"
    }],
    "children": []
  }, {
    "label": "format_capn_*",
    "count": 3,
    "settings": [{
      "name": "format_capn_proto_enum_comparising_mode",
      "href": "/reference/settings/formats/format-capn#format_capn_proto_enum_comparising_mode",
      "default": "by_values"
    }, {
      "name": "format_capn_proto_max_message_size",
      "href": "/reference/settings/formats/format-capn#format_capn_proto_max_message_size",
      "default": "1073741824"
    }, {
      "name": "format_capn_proto_use_autogenerated_schema",
      "href": "/reference/settings/formats/format-capn#format_capn_proto_use_autogenerated_schema",
      "default": "1"
    }],
    "children": []
  }, {
    "label": "format_csv_*",
    "count": 4,
    "settings": [{
      "name": "format_csv_allow_double_quotes",
      "href": "/reference/settings/formats/format-csv#format_csv_allow_double_quotes",
      "default": "1"
    }, {
      "name": "format_csv_allow_single_quotes",
      "href": "/reference/settings/formats/format-csv#format_csv_allow_single_quotes",
      "default": "0"
    }, {
      "name": "format_csv_delimiter",
      "href": "/reference/settings/formats/format-csv#format_csv_delimiter",
      "default": ","
    }, {
      "name": "format_csv_null_representation",
      "href": "/reference/settings/formats/format-csv#format_csv_null_representation",
      "default": "\\N"
    }],
    "children": []
  }, {
    "label": "format_custom_*",
    "count": 7,
    "settings": [{
      "name": "format_custom_escaping_rule",
      "href": "/reference/settings/formats/format-custom#format_custom_escaping_rule",
      "default": "Escaped"
    }, {
      "name": "format_custom_field_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_field_delimiter",
      "default": "\"\""
    }, {
      "name": "format_custom_result_after_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_result_after_delimiter",
      "default": "\"\""
    }, {
      "name": "format_custom_result_before_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_result_before_delimiter",
      "default": "\"\""
    }, {
      "name": "format_custom_row_after_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_after_delimiter",
      "default": "\"\""
    }, {
      "name": "format_custom_row_before_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_before_delimiter",
      "default": "\"\""
    }, {
      "name": "format_custom_row_between_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_between_delimiter",
      "default": "\"\""
    }],
    "children": []
  }, {
    "label": "format_regexp_*",
    "count": 3,
    "settings": [{
      "name": "format_regexp",
      "href": "/reference/settings/formats/format-regexp#format_regexp",
      "default": "\"\""
    }, {
      "name": "format_regexp_escaping_rule",
      "href": "/reference/settings/formats/format-regexp#format_regexp_escaping_rule",
      "default": "Raw"
    }, {
      "name": "format_regexp_skip_unmatched",
      "href": "/reference/settings/formats/format-regexp#format_regexp_skip_unmatched",
      "default": "0"
    }],
    "children": []
  }, {
    "label": "format_schema_*",
    "count": 3,
    "settings": [{
      "name": "format_schema",
      "href": "/reference/settings/formats/format-schema#format_schema",
      "default": "\"\""
    }, {
      "name": "format_schema_message_name",
      "href": "/reference/settings/formats/format-schema#format_schema_message_name",
      "default": "\"\""
    }, {
      "name": "format_schema_source",
      "href": "/reference/settings/formats/format-schema#format_schema_source",
      "default": "file"
    }],
    "children": []
  }, {
    "label": "format_template_*",
    "count": 5,
    "settings": [{
      "name": "format_template_resultset",
      "href": "/reference/settings/formats/format-template#format_template_resultset",
      "default": "\"\""
    }, {
      "name": "format_template_resultset_format",
      "href": "/reference/settings/formats/format-template#format_template_resultset_format",
      "default": "\"\""
    }, {
      "name": "format_template_row",
      "href": "/reference/settings/formats/format-template#format_template_row",
      "default": "\"\""
    }, {
      "name": "format_template_row_format",
      "href": "/reference/settings/formats/format-template#format_template_row_format",
      "default": "\"\""
    }, {
      "name": "format_template_rows_between_delimiter",
      "href": "/reference/settings/formats/format-template#format_template_rows_between_delimiter",
      "default": "\"\""
    }],
    "children": []
  }, {
    "label": "input_format_*",
    "count": 127,
    "settings": [{
      "name": "input_format_allow_errors_num",
      "href": "/reference/settings/formats/input-format#input_format_allow_errors_num",
      "default": "0"
    }, {
      "name": "input_format_allow_errors_ratio",
      "href": "/reference/settings/formats/input-format#input_format_allow_errors_ratio",
      "default": "0"
    }, {
      "name": "input_format_allow_seeks",
      "href": "/reference/settings/formats/input-format#input_format_allow_seeks",
      "default": "1"
    }, {
      "name": "input_format_arrow_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_arrow_allow_missing_columns",
      "default": "1"
    }, {
      "name": "input_format_arrow_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_arrow_case_insensitive_column_matching",
      "default": "0"
    }, {
      "name": "input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_avro_allow_missing_fields",
      "href": "/reference/settings/formats/input-format#input_format_avro_allow_missing_fields",
      "default": "0"
    }, {
      "name": "input_format_avro_null_as_default",
      "href": "/reference/settings/formats/input-format#input_format_avro_null_as_default",
      "default": "0"
    }, {
      "name": "input_format_binary_decode_types_in_binary_format",
      "href": "/reference/settings/formats/input-format#input_format_binary_decode_types_in_binary_format",
      "default": "0"
    }, {
      "name": "input_format_binary_max_type_complexity",
      "href": "/reference/settings/formats/input-format#input_format_binary_max_type_complexity",
      "default": "1000"
    }, {
      "name": "input_format_binary_read_json_as_string",
      "href": "/reference/settings/formats/input-format#input_format_binary_read_json_as_string",
      "default": "0"
    }, {
      "name": "input_format_bson_skip_fields_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_bson_skip_fields_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_capn_proto_skip_fields_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_capn_proto_skip_fields_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_column_name_matching_mode",
      "href": "/reference/settings/formats/input-format#input_format_column_name_matching_mode",
      "default": "auto"
    }, {
      "name": "input_format_connection_handling",
      "href": "/reference/settings/formats/input-format#input_format_connection_handling",
      "default": "0"
    }, {
      "name": "input_format_csv_allow_cr_end_of_line",
      "href": "/reference/settings/formats/input-format#input_format_csv_allow_cr_end_of_line",
      "default": "0"
    }, {
      "name": "input_format_csv_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_csv_allow_variable_number_of_columns",
      "default": "0"
    }, {
      "name": "input_format_csv_allow_whitespace_or_tab_as_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_csv_allow_whitespace_or_tab_as_delimiter",
      "default": "0"
    }, {
      "name": "input_format_csv_arrays_as_nested_csv",
      "href": "/reference/settings/formats/input-format#input_format_csv_arrays_as_nested_csv",
      "default": "0"
    }, {
      "name": "input_format_csv_deserialize_separate_columns_into_tuple",
      "href": "/reference/settings/formats/input-format#input_format_csv_deserialize_separate_columns_into_tuple",
      "default": "1"
    }, {
      "name": "input_format_csv_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_csv_detect_header",
      "default": "1"
    }, {
      "name": "input_format_csv_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_csv_empty_as_default",
      "default": "1"
    }, {
      "name": "input_format_csv_enum_as_number",
      "href": "/reference/settings/formats/input-format#input_format_csv_enum_as_number",
      "default": "0"
    }, {
      "name": "input_format_csv_missing_nullable_as_empty_string",
      "href": "/reference/settings/formats/input-format#input_format_csv_missing_nullable_as_empty_string",
      "default": "0"
    }, {
      "name": "input_format_csv_skip_first_lines",
      "href": "/reference/settings/formats/input-format#input_format_csv_skip_first_lines",
      "default": "0"
    }, {
      "name": "input_format_csv_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_csv_skip_trailing_empty_lines",
      "default": "0"
    }, {
      "name": "input_format_csv_trim_whitespaces",
      "href": "/reference/settings/formats/input-format#input_format_csv_trim_whitespaces",
      "default": "1"
    }, {
      "name": "input_format_csv_try_infer_numbers_from_strings",
      "href": "/reference/settings/formats/input-format#input_format_csv_try_infer_numbers_from_strings",
      "default": "0"
    }, {
      "name": "input_format_csv_try_infer_strings_from_quoted_tuples",
      "href": "/reference/settings/formats/input-format#input_format_csv_try_infer_strings_from_quoted_tuples",
      "default": "1"
    }, {
      "name": "input_format_csv_use_best_effort_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_csv_use_best_effort_in_schema_inference",
      "default": "1"
    }, {
      "name": "input_format_csv_use_default_on_bad_values",
      "href": "/reference/settings/formats/input-format#input_format_csv_use_default_on_bad_values",
      "default": "0"
    }, {
      "name": "input_format_custom_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_custom_allow_variable_number_of_columns",
      "default": "0"
    }, {
      "name": "input_format_custom_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_custom_detect_header",
      "default": "1"
    }, {
      "name": "input_format_custom_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_custom_skip_trailing_empty_lines",
      "default": "0"
    }, {
      "name": "input_format_defaults_for_omitted_fields",
      "href": "/reference/settings/formats/input-format#input_format_defaults_for_omitted_fields",
      "default": "1"
    }, {
      "name": "input_format_force_null_for_omitted_fields",
      "href": "/reference/settings/formats/input-format#input_format_force_null_for_omitted_fields",
      "default": "0"
    }, {
      "name": "input_format_geojson_unsupported_geometry_handling",
      "href": "/reference/settings/formats/input-format#input_format_geojson_unsupported_geometry_handling",
      "default": "throw"
    }, {
      "name": "input_format_hive_text_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_allow_variable_number_of_columns",
      "default": "1"
    }, {
      "name": "input_format_hive_text_collection_items_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_collection_items_delimiter",
      "default": "\u0002"
    }, {
      "name": "input_format_hive_text_fields_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_fields_delimiter",
      "default": "\u0001"
    }, {
      "name": "input_format_hive_text_map_keys_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_map_keys_delimiter",
      "default": "\u0003"
    }, {
      "name": "input_format_import_nested_json",
      "href": "/reference/settings/formats/input-format#input_format_import_nested_json",
      "default": "0"
    }, {
      "name": "input_format_ipv4_default_on_conversion_error",
      "href": "/reference/settings/formats/input-format#input_format_ipv4_default_on_conversion_error",
      "default": "0"
    }, {
      "name": "input_format_ipv6_default_on_conversion_error",
      "href": "/reference/settings/formats/input-format#input_format_ipv6_default_on_conversion_error",
      "default": "0"
    }, {
      "name": "input_format_json_compact_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_json_compact_allow_variable_number_of_columns",
      "default": "0"
    }, {
      "name": "input_format_json_defaults_for_missing_elements_in_named_tuple",
      "href": "/reference/settings/formats/input-format#input_format_json_defaults_for_missing_elements_in_named_tuple",
      "default": "1"
    }, {
      "name": "input_format_json_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_json_empty_as_default",
      "default": "0"
    }, {
      "name": "input_format_json_ignore_unknown_keys_in_named_tuple",
      "href": "/reference/settings/formats/input-format#input_format_json_ignore_unknown_keys_in_named_tuple",
      "default": "1"
    }, {
      "name": "input_format_json_ignore_unnecessary_fields",
      "href": "/reference/settings/formats/input-format#input_format_json_ignore_unnecessary_fields",
      "default": "1"
    }, {
      "name": "input_format_json_infer_array_of_dynamic_from_array_of_different_types",
      "href": "/reference/settings/formats/input-format#input_format_json_infer_array_of_dynamic_from_array_of_different_types",
      "default": "1"
    }, {
      "name": "input_format_json_infer_incomplete_types_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_infer_incomplete_types_as_strings",
      "default": "1"
    }, {
      "name": "input_format_json_map_as_array_of_tuples",
      "href": "/reference/settings/formats/input-format#input_format_json_map_as_array_of_tuples",
      "default": "0"
    }, {
      "name": "input_format_json_max_depth",
      "href": "/reference/settings/formats/input-format#input_format_json_max_depth",
      "default": "1000"
    }, {
      "name": "input_format_json_named_tuples_as_objects",
      "href": "/reference/settings/formats/input-format#input_format_json_named_tuples_as_objects",
      "default": "1"
    }, {
      "name": "input_format_json_read_arrays_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_arrays_as_strings",
      "default": "1"
    }, {
      "name": "input_format_json_read_bools_as_numbers",
      "href": "/reference/settings/formats/input-format#input_format_json_read_bools_as_numbers",
      "default": "1"
    }, {
      "name": "input_format_json_read_bools_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_bools_as_strings",
      "default": "1"
    }, {
      "name": "input_format_json_read_numbers_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_numbers_as_strings",
      "default": "1"
    }, {
      "name": "input_format_json_read_objects_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_objects_as_strings",
      "default": "1"
    }, {
      "name": "input_format_json_throw_on_bad_escape_sequence",
      "href": "/reference/settings/formats/input-format#input_format_json_throw_on_bad_escape_sequence",
      "default": "1"
    }, {
      "name": "input_format_json_try_infer_named_tuples_from_objects",
      "href": "/reference/settings/formats/input-format#input_format_json_try_infer_named_tuples_from_objects",
      "default": "1"
    }, {
      "name": "input_format_json_try_infer_numbers_from_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_try_infer_numbers_from_strings",
      "default": "0"
    }, {
      "name": "input_format_json_use_string_type_for_ambiguous_paths_in_named_tuples_inference_from_objects",
      "href": "/reference/settings/formats/input-format#input_format_json_use_string_type_for_ambiguous_paths_in_named_tuples_inference_from_objects",
      "default": "0"
    }, {
      "name": "input_format_json_validate_types_from_metadata",
      "href": "/reference/settings/formats/input-format#input_format_json_validate_types_from_metadata",
      "default": "1"
    }, {
      "name": "input_format_max_block_size_bytes",
      "href": "/reference/settings/formats/input-format#input_format_max_block_size_bytes",
      "default": "0"
    }, {
      "name": "input_format_max_block_wait_ms",
      "href": "/reference/settings/formats/input-format#input_format_max_block_wait_ms",
      "default": "0"
    }, {
      "name": "input_format_max_bytes_to_read_for_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_max_bytes_to_read_for_schema_inference",
      "default": "33554432"
    }, {
      "name": "input_format_max_rows_to_read_for_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_max_rows_to_read_for_schema_inference",
      "default": "25000"
    }, {
      "name": "input_format_msgpack_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_msgpack_number_of_columns",
      "default": "0"
    }, {
      "name": "input_format_mysql_dump_map_column_names",
      "href": "/reference/settings/formats/input-format#input_format_mysql_dump_map_column_names",
      "default": "1"
    }, {
      "name": "input_format_mysql_dump_table_name",
      "href": "/reference/settings/formats/input-format#input_format_mysql_dump_table_name",
      "default": "\"\""
    }, {
      "name": "input_format_native_allow_types_conversion",
      "href": "/reference/settings/formats/input-format#input_format_native_allow_types_conversion",
      "default": "1"
    }, {
      "name": "input_format_native_decode_types_in_binary_format",
      "href": "/reference/settings/formats/input-format#input_format_native_decode_types_in_binary_format",
      "default": "0"
    }, {
      "name": "input_format_null_as_default",
      "href": "/reference/settings/formats/input-format#input_format_null_as_default",
      "default": "1"
    }, {
      "name": "input_format_orc_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_orc_allow_missing_columns",
      "default": "1"
    }, {
      "name": "input_format_orc_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_orc_case_insensitive_column_matching",
      "default": "0"
    }, {
      "name": "input_format_orc_dictionary_as_low_cardinality",
      "href": "/reference/settings/formats/input-format#input_format_orc_dictionary_as_low_cardinality",
      "default": "1"
    }, {
      "name": "input_format_orc_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_orc_filter_push_down",
      "default": "1"
    }, {
      "name": "input_format_orc_reader_time_zone_name",
      "href": "/reference/settings/formats/input-format#input_format_orc_reader_time_zone_name",
      "default": "GMT"
    }, {
      "name": "input_format_orc_row_batch_size",
      "href": "/reference/settings/formats/input-format#input_format_orc_row_batch_size",
      "default": "100000"
    }, {
      "name": "input_format_orc_skip_columns_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_orc_skip_columns_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_parallel_parsing",
      "href": "/reference/settings/formats/input-format#input_format_parallel_parsing",
      "default": "1"
    }, {
      "name": "input_format_parquet_allow_geoparquet_parser",
      "href": "/reference/settings/formats/input-format#input_format_parquet_allow_geoparquet_parser",
      "default": "1"
    }, {
      "name": "input_format_parquet_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_parquet_allow_missing_columns",
      "default": "1"
    }, {
      "name": "input_format_parquet_bloom_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_bloom_filter_push_down",
      "default": "1"
    }, {
      "name": "input_format_parquet_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_parquet_case_insensitive_column_matching",
      "default": "0"
    }, {
      "name": "input_format_parquet_dictionary_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_dictionary_filter_push_down",
      "default": "1048576"
    }, {
      "name": "input_format_parquet_enable_json_parsing",
      "href": "/reference/settings/formats/input-format#input_format_parquet_enable_json_parsing",
      "default": "1"
    }, {
      "name": "input_format_parquet_enable_row_group_prefetch",
      "href": "/reference/settings/formats/input-format#input_format_parquet_enable_row_group_prefetch",
      "default": "1"
    }, {
      "name": "input_format_parquet_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_filter_push_down",
      "default": "1"
    }, {
      "name": "input_format_parquet_local_file_min_bytes_for_seek",
      "href": "/reference/settings/formats/input-format#input_format_parquet_local_file_min_bytes_for_seek",
      "default": "8192"
    }, {
      "name": "input_format_parquet_local_time_as_utc",
      "href": "/reference/settings/formats/input-format#input_format_parquet_local_time_as_utc",
      "default": "1"
    }, {
      "name": "input_format_parquet_max_block_size",
      "href": "/reference/settings/formats/input-format#input_format_parquet_max_block_size",
      "default": "65409"
    }, {
      "name": "input_format_parquet_memory_high_watermark",
      "href": "/reference/settings/formats/input-format#input_format_parquet_memory_high_watermark",
      "default": "4294967296"
    }, {
      "name": "input_format_parquet_memory_low_watermark",
      "href": "/reference/settings/formats/input-format#input_format_parquet_memory_low_watermark",
      "default": "2097152"
    }, {
      "name": "input_format_parquet_page_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_page_filter_push_down",
      "default": "1"
    }, {
      "name": "input_format_parquet_prefer_block_bytes",
      "href": "/reference/settings/formats/input-format#input_format_parquet_prefer_block_bytes",
      "default": "16744704"
    }, {
      "name": "input_format_parquet_preserve_order",
      "href": "/reference/settings/formats/input-format#input_format_parquet_preserve_order",
      "default": "0"
    }, {
      "name": "input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_parquet_spatial_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_spatial_filter_push_down",
      "default": "1"
    }, {
      "name": "input_format_parquet_use_offset_index",
      "href": "/reference/settings/formats/input-format#input_format_parquet_use_offset_index",
      "default": "1"
    }, {
      "name": "input_format_parquet_verify_checksums",
      "href": "/reference/settings/formats/input-format#input_format_parquet_verify_checksums",
      "default": "1"
    }, {
      "name": "input_format_protobuf_flatten_google_wrappers",
      "href": "/reference/settings/formats/input-format#input_format_protobuf_flatten_google_wrappers",
      "default": "0"
    }, {
      "name": "input_format_protobuf_oneof_presence",
      "href": "/reference/settings/formats/input-format#input_format_protobuf_oneof_presence",
      "default": "0"
    }, {
      "name": "input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference",
      "default": "0"
    }, {
      "name": "input_format_read_datetime_number_as_raw_value",
      "href": "/reference/settings/formats/input-format#input_format_read_datetime_number_as_raw_value",
      "default": "0"
    }, {
      "name": "input_format_record_errors_file_path",
      "href": "/reference/settings/formats/input-format#input_format_record_errors_file_path",
      "default": "\"\""
    }, {
      "name": "input_format_skip_unknown_fields",
      "href": "/reference/settings/formats/input-format#input_format_skip_unknown_fields",
      "default": "1"
    }, {
      "name": "input_format_try_infer_dates",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_dates",
      "default": "1"
    }, {
      "name": "input_format_try_infer_datetimes",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_datetimes",
      "default": "1"
    }, {
      "name": "input_format_try_infer_datetimes_only_datetime64",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_datetimes_only_datetime64",
      "default": "0"
    }, {
      "name": "input_format_try_infer_exponent_floats",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_exponent_floats",
      "default": "0"
    }, {
      "name": "input_format_try_infer_integers",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_integers",
      "default": "1"
    }, {
      "name": "input_format_try_infer_variants",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_variants",
      "default": "0"
    }, {
      "name": "input_format_tsv_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_tsv_allow_variable_number_of_columns",
      "default": "0"
    }, {
      "name": "input_format_tsv_crlf_end_of_line",
      "href": "/reference/settings/formats/input-format#input_format_tsv_crlf_end_of_line",
      "default": "0"
    }, {
      "name": "input_format_tsv_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_tsv_detect_header",
      "default": "1"
    }, {
      "name": "input_format_tsv_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_tsv_empty_as_default",
      "default": "0"
    }, {
      "name": "input_format_tsv_enum_as_number",
      "href": "/reference/settings/formats/input-format#input_format_tsv_enum_as_number",
      "default": "0"
    }, {
      "name": "input_format_tsv_skip_first_lines",
      "href": "/reference/settings/formats/input-format#input_format_tsv_skip_first_lines",
      "default": "0"
    }, {
      "name": "input_format_tsv_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_tsv_skip_trailing_empty_lines",
      "default": "0"
    }, {
      "name": "input_format_tsv_use_best_effort_in_schema_inference",
      "href": "/reference/settings/formats/input-format#input_format_tsv_use_best_effort_in_schema_inference",
      "default": "1"
    }, {
      "name": "input_format_values_accurate_types_of_literals",
      "href": "/reference/settings/formats/input-format#input_format_values_accurate_types_of_literals",
      "default": "1"
    }, {
      "name": "input_format_values_deduce_templates_of_expressions",
      "href": "/reference/settings/formats/input-format#input_format_values_deduce_templates_of_expressions",
      "default": "1"
    }, {
      "name": "input_format_values_interpret_expressions",
      "href": "/reference/settings/formats/input-format#input_format_values_interpret_expressions",
      "default": "1"
    }, {
      "name": "input_format_with_names_use_header",
      "href": "/reference/settings/formats/input-format#input_format_with_names_use_header",
      "default": "1"
    }, {
      "name": "input_format_with_types_use_header",
      "href": "/reference/settings/formats/input-format#input_format_with_types_use_header",
      "default": "1"
    }],
    "children": []
  }, {
    "label": "output_format_*",
    "count": 103,
    "settings": [{
      "name": "output_format_always_write_decimal_point_in_float_and_decimal",
      "href": "/reference/settings/formats/output-format#output_format_always_write_decimal_point_in_float_and_decimal",
      "default": "0"
    }, {
      "name": "output_format_arrow_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_arrow_compression_method",
      "default": "lz4_frame"
    }, {
      "name": "output_format_arrow_date_as_uint16",
      "href": "/reference/settings/formats/output-format#output_format_arrow_date_as_uint16",
      "default": "0"
    }, {
      "name": "output_format_arrow_fixed_string_as_fixed_byte_array",
      "href": "/reference/settings/formats/output-format#output_format_arrow_fixed_string_as_fixed_byte_array",
      "default": "1"
    }, {
      "name": "output_format_arrow_low_cardinality_as_dictionary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_low_cardinality_as_dictionary",
      "default": "0"
    }, {
      "name": "output_format_arrow_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_arrow_string_as_string",
      "default": "1"
    }, {
      "name": "output_format_arrow_unsupported_types_as_binary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_unsupported_types_as_binary",
      "default": "1"
    }, {
      "name": "output_format_arrow_use_64_bit_indexes_for_dictionary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_use_64_bit_indexes_for_dictionary",
      "default": "0"
    }, {
      "name": "output_format_arrow_use_signed_indexes_for_dictionary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_use_signed_indexes_for_dictionary",
      "default": "1"
    }, {
      "name": "output_format_avro_codec",
      "href": "/reference/settings/formats/output-format#output_format_avro_codec",
      "default": "\"\""
    }, {
      "name": "output_format_avro_confluent_subject",
      "href": "/reference/settings/formats/output-format#output_format_avro_confluent_subject",
      "default": "\"\""
    }, {
      "name": "output_format_avro_rows_in_file",
      "href": "/reference/settings/formats/output-format#output_format_avro_rows_in_file",
      "default": "1"
    }, {
      "name": "output_format_avro_string_column_pattern",
      "href": "/reference/settings/formats/output-format#output_format_avro_string_column_pattern",
      "default": "\"\""
    }, {
      "name": "output_format_avro_sync_interval",
      "href": "/reference/settings/formats/output-format#output_format_avro_sync_interval",
      "default": "16384"
    }, {
      "name": "output_format_binary_encode_types_in_binary_format",
      "href": "/reference/settings/formats/output-format#output_format_binary_encode_types_in_binary_format",
      "default": "0"
    }, {
      "name": "output_format_binary_write_json_as_string",
      "href": "/reference/settings/formats/output-format#output_format_binary_write_json_as_string",
      "default": "0"
    }, {
      "name": "output_format_bson_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_bson_string_as_string",
      "default": "0"
    }, {
      "name": "output_format_compression_level",
      "href": "/reference/settings/formats/output-format#output_format_compression_level",
      "default": "3"
    }, {
      "name": "output_format_compression_zstd_window_log",
      "href": "/reference/settings/formats/output-format#output_format_compression_zstd_window_log",
      "default": "0"
    }, {
      "name": "output_format_csv_crlf_end_of_line",
      "href": "/reference/settings/formats/output-format#output_format_csv_crlf_end_of_line",
      "default": "0"
    }, {
      "name": "output_format_csv_header_serialize_tuple_into_separate_columns",
      "href": "/reference/settings/formats/output-format#output_format_csv_header_serialize_tuple_into_separate_columns",
      "default": "1"
    }, {
      "name": "output_format_csv_serialize_tuple_into_separate_columns",
      "href": "/reference/settings/formats/output-format#output_format_csv_serialize_tuple_into_separate_columns",
      "default": "1"
    }, {
      "name": "output_format_decimal_trailing_zeros",
      "href": "/reference/settings/formats/output-format#output_format_decimal_trailing_zeros",
      "default": "0"
    }, {
      "name": "output_format_float_precision",
      "href": "/reference/settings/formats/output-format#output_format_float_precision",
      "default": "0"
    }, {
      "name": "output_format_image_height",
      "href": "/reference/settings/formats/output-format#output_format_image_height",
      "default": "1024"
    }, {
      "name": "output_format_image_terminal_mode",
      "href": "/reference/settings/formats/output-format#output_format_image_terminal_mode",
      "default": "\"\""
    }, {
      "name": "output_format_image_width",
      "href": "/reference/settings/formats/output-format#output_format_image_width",
      "default": "1024"
    }, {
      "name": "output_format_json_array_of_rows",
      "href": "/reference/settings/formats/output-format#output_format_json_array_of_rows",
      "default": "0"
    }, {
      "name": "output_format_json_escape_forward_slashes",
      "href": "/reference/settings/formats/output-format#output_format_json_escape_forward_slashes",
      "default": "1"
    }, {
      "name": "output_format_json_map_as_array_of_tuples",
      "href": "/reference/settings/formats/output-format#output_format_json_map_as_array_of_tuples",
      "default": "0"
    }, {
      "name": "output_format_json_named_tuples_as_objects",
      "href": "/reference/settings/formats/output-format#output_format_json_named_tuples_as_objects",
      "default": "1"
    }, {
      "name": "output_format_json_pretty_print",
      "href": "/reference/settings/formats/output-format#output_format_json_pretty_print",
      "default": "1"
    }, {
      "name": "output_format_json_quote_64bit_floats",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_64bit_floats",
      "default": "0"
    }, {
      "name": "output_format_json_quote_64bit_integers",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_64bit_integers",
      "default": "0"
    }, {
      "name": "output_format_json_quote_decimals",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_decimals",
      "default": "0"
    }, {
      "name": "output_format_json_quote_denormals",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_denormals",
      "default": "0"
    }, {
      "name": "output_format_json_skip_null_value_in_named_tuples",
      "href": "/reference/settings/formats/output-format#output_format_json_skip_null_value_in_named_tuples",
      "default": "0"
    }, {
      "name": "output_format_json_validate_utf8",
      "href": "/reference/settings/formats/output-format#output_format_json_validate_utf8",
      "default": "0"
    }, {
      "name": "output_format_markdown_escape_special_characters",
      "href": "/reference/settings/formats/output-format#output_format_markdown_escape_special_characters",
      "default": "0"
    }, {
      "name": "output_format_msgpack_uuid_representation",
      "href": "/reference/settings/formats/output-format#output_format_msgpack_uuid_representation",
      "default": "ext"
    }, {
      "name": "output_format_native_encode_types_in_binary_format",
      "href": "/reference/settings/formats/output-format#output_format_native_encode_types_in_binary_format",
      "default": "0"
    }, {
      "name": "output_format_native_use_flattened_dynamic_and_json_serialization",
      "href": "/reference/settings/formats/output-format#output_format_native_use_flattened_dynamic_and_json_serialization",
      "default": "0"
    }, {
      "name": "output_format_native_write_json_as_string",
      "href": "/reference/settings/formats/output-format#output_format_native_write_json_as_string",
      "default": "0"
    }, {
      "name": "output_format_orc_compression_block_size",
      "href": "/reference/settings/formats/output-format#output_format_orc_compression_block_size",
      "default": "262144"
    }, {
      "name": "output_format_orc_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_orc_compression_method",
      "default": "zstd"
    }, {
      "name": "output_format_orc_dictionary_key_size_threshold",
      "href": "/reference/settings/formats/output-format#output_format_orc_dictionary_key_size_threshold",
      "default": "0"
    }, {
      "name": "output_format_orc_row_index_stride",
      "href": "/reference/settings/formats/output-format#output_format_orc_row_index_stride",
      "default": "10000"
    }, {
      "name": "output_format_orc_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_orc_string_as_string",
      "default": "1"
    }, {
      "name": "output_format_orc_writer_time_zone_name",
      "href": "/reference/settings/formats/output-format#output_format_orc_writer_time_zone_name",
      "default": "GMT"
    }, {
      "name": "output_format_parallel_formatting",
      "href": "/reference/settings/formats/output-format#output_format_parallel_formatting",
      "default": "1"
    }, {
      "name": "output_format_parquet_batch_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_batch_size",
      "default": "1024"
    }, {
      "name": "output_format_parquet_bloom_filter_bits_per_value",
      "href": "/reference/settings/formats/output-format#output_format_parquet_bloom_filter_bits_per_value",
      "default": "10.5"
    }, {
      "name": "output_format_parquet_bloom_filter_flush_threshold_bytes",
      "href": "/reference/settings/formats/output-format#output_format_parquet_bloom_filter_flush_threshold_bytes",
      "default": "134217728"
    }, {
      "name": "output_format_parquet_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_parquet_compression_method",
      "default": "zstd"
    }, {
      "name": "output_format_parquet_data_page_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_data_page_size",
      "default": "1048576"
    }, {
      "name": "output_format_parquet_date_as_uint16",
      "href": "/reference/settings/formats/output-format#output_format_parquet_date_as_uint16",
      "default": "0"
    }, {
      "name": "output_format_parquet_datetime_as_uint32",
      "href": "/reference/settings/formats/output-format#output_format_parquet_datetime_as_uint32",
      "default": "0"
    }, {
      "name": "output_format_parquet_enum_as_byte_array",
      "href": "/reference/settings/formats/output-format#output_format_parquet_enum_as_byte_array",
      "default": "1"
    }, {
      "name": "output_format_parquet_fixed_string_as_fixed_byte_array",
      "href": "/reference/settings/formats/output-format#output_format_parquet_fixed_string_as_fixed_byte_array",
      "default": "1"
    }, {
      "name": "output_format_parquet_geometadata",
      "href": "/reference/settings/formats/output-format#output_format_parquet_geometadata",
      "default": "1"
    }, {
      "name": "output_format_parquet_max_dictionary_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_max_dictionary_size",
      "default": "1048576"
    }, {
      "name": "output_format_parquet_parallel_encoding",
      "href": "/reference/settings/formats/output-format#output_format_parquet_parallel_encoding",
      "default": "1"
    }, {
      "name": "output_format_parquet_row_group_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_row_group_size",
      "default": "1000000"
    }, {
      "name": "output_format_parquet_row_group_size_bytes",
      "href": "/reference/settings/formats/output-format#output_format_parquet_row_group_size_bytes",
      "default": "536870912"
    }, {
      "name": "output_format_parquet_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_parquet_string_as_string",
      "default": "1"
    }, {
      "name": "output_format_parquet_write_bloom_filter",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_bloom_filter",
      "default": "1"
    }, {
      "name": "output_format_parquet_write_checksums",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_checksums",
      "default": "1"
    }, {
      "name": "output_format_parquet_write_page_index",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_page_index",
      "default": "1"
    }, {
      "name": "output_format_pretty_color",
      "href": "/reference/settings/formats/output-format#output_format_pretty_color",
      "default": "auto"
    }, {
      "name": "output_format_pretty_display_footer_column_names",
      "href": "/reference/settings/formats/output-format#output_format_pretty_display_footer_column_names",
      "default": "1"
    }, {
      "name": "output_format_pretty_display_footer_column_names_min_rows",
      "href": "/reference/settings/formats/output-format#output_format_pretty_display_footer_column_names_min_rows",
      "default": "50"
    }, {
      "name": "output_format_pretty_fallback_to_vertical",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical",
      "default": "1"
    }, {
      "name": "output_format_pretty_fallback_to_vertical_max_rows_per_chunk",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical_max_rows_per_chunk",
      "default": "10"
    }, {
      "name": "output_format_pretty_fallback_to_vertical_min_columns",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical_min_columns",
      "default": "5"
    }, {
      "name": "output_format_pretty_fallback_to_vertical_min_table_width",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical_min_table_width",
      "default": "250"
    }, {
      "name": "output_format_pretty_glue_chunks",
      "href": "/reference/settings/formats/output-format#output_format_pretty_glue_chunks",
      "default": "auto"
    }, {
      "name": "output_format_pretty_grid_charset",
      "href": "/reference/settings/formats/output-format#output_format_pretty_grid_charset",
      "default": "UTF-8"
    }, {
      "name": "output_format_pretty_highlight_digit_groups",
      "href": "/reference/settings/formats/output-format#output_format_pretty_highlight_digit_groups",
      "default": "1"
    }, {
      "name": "output_format_pretty_highlight_trailing_spaces",
      "href": "/reference/settings/formats/output-format#output_format_pretty_highlight_trailing_spaces",
      "default": "1"
    }, {
      "name": "output_format_pretty_max_column_name_width_cut_to",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_column_name_width_cut_to",
      "default": "24"
    }, {
      "name": "output_format_pretty_max_column_name_width_min_chars_to_cut",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_column_name_width_min_chars_to_cut",
      "default": "4"
    }, {
      "name": "output_format_pretty_max_column_pad_width",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_column_pad_width",
      "default": "250"
    }, {
      "name": "output_format_pretty_max_rows",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_rows",
      "default": "1000"
    }, {
      "name": "output_format_pretty_max_value_width",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_value_width",
      "default": "10000"
    }, {
      "name": "output_format_pretty_max_value_width_apply_for_single_value",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_value_width_apply_for_single_value",
      "default": "0"
    }, {
      "name": "output_format_pretty_multiline_fields",
      "href": "/reference/settings/formats/output-format#output_format_pretty_multiline_fields",
      "default": "1"
    }, {
      "name": "output_format_pretty_named_tuples_as_json",
      "href": "/reference/settings/formats/output-format#output_format_pretty_named_tuples_as_json",
      "default": "1"
    }, {
      "name": "output_format_pretty_row_numbers",
      "href": "/reference/settings/formats/output-format#output_format_pretty_row_numbers",
      "default": "1"
    }, {
      "name": "output_format_pretty_single_large_number_tip_threshold",
      "href": "/reference/settings/formats/output-format#output_format_pretty_single_large_number_tip_threshold",
      "default": "1000000"
    }, {
      "name": "output_format_pretty_squash_consecutive_ms",
      "href": "/reference/settings/formats/output-format#output_format_pretty_squash_consecutive_ms",
      "default": "50"
    }, {
      "name": "output_format_pretty_squash_max_wait_ms",
      "href": "/reference/settings/formats/output-format#output_format_pretty_squash_max_wait_ms",
      "default": "1000"
    }, {
      "name": "output_format_pretty_use_nbsp_for_padding",
      "href": "/reference/settings/formats/output-format#output_format_pretty_use_nbsp_for_padding",
      "default": "0"
    }, {
      "name": "output_format_protobuf_nullables_with_google_wrappers",
      "href": "/reference/settings/formats/output-format#output_format_protobuf_nullables_with_google_wrappers",
      "default": "0"
    }, {
      "name": "output_format_schema",
      "href": "/reference/settings/formats/output-format#output_format_schema",
      "default": "\"\""
    }, {
      "name": "output_format_sql_insert_include_column_names",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_include_column_names",
      "default": "1"
    }, {
      "name": "output_format_sql_insert_max_batch_size",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_max_batch_size",
      "default": "65409"
    }, {
      "name": "output_format_sql_insert_quote_names",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_quote_names",
      "default": "1"
    }, {
      "name": "output_format_sql_insert_table_name",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_table_name",
      "default": "table"
    }, {
      "name": "output_format_sql_insert_use_replace",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_use_replace",
      "default": "0"
    }, {
      "name": "output_format_trim_fixed_string",
      "href": "/reference/settings/formats/output-format#output_format_trim_fixed_string",
      "default": "0"
    }, {
      "name": "output_format_tsv_crlf_end_of_line",
      "href": "/reference/settings/formats/output-format#output_format_tsv_crlf_end_of_line",
      "default": "0"
    }, {
      "name": "output_format_values_escape_quote_with_quote",
      "href": "/reference/settings/formats/output-format#output_format_values_escape_quote_with_quote",
      "default": "0"
    }, {
      "name": "output_format_write_statistics",
      "href": "/reference/settings/formats/output-format#output_format_write_statistics",
      "default": "1"
    }],
    "children": []
  }, {
    "label": "schema_inference_*",
    "count": 4,
    "settings": [{
      "name": "schema_inference_hints",
      "href": "/reference/settings/formats/schema-inference#schema_inference_hints",
      "default": "\"\""
    }, {
      "name": "schema_inference_make_columns_nullable",
      "href": "/reference/settings/formats/schema-inference#schema_inference_make_columns_nullable",
      "default": "3"
    }, {
      "name": "schema_inference_make_json_columns_nullable",
      "href": "/reference/settings/formats/schema-inference#schema_inference_make_json_columns_nullable",
      "default": "0"
    }, {
      "name": "schema_inference_mode",
      "href": "/reference/settings/formats/schema-inference#schema_inference_mode",
      "default": "default"
    }],
    "children": []
  }, {
    "label": "show_create_*",
    "count": 2,
    "settings": [{
      "name": "show_create_query_identifier_quoting_rule",
      "href": "/reference/settings/formats/show-create#show_create_query_identifier_quoting_rule",
      "default": "when_necessary"
    }, {
      "name": "show_create_query_identifier_quoting_style",
      "href": "/reference/settings/formats/show-create#show_create_query_identifier_quoting_style",
      "default": "Backticks"
    }],
    "children": []
  }, {
    "label": "type_json_*",
    "count": 4,
    "settings": [{
      "name": "type_json_allow_duplicated_key_with_literal_and_nested_object",
      "href": "/reference/settings/formats/type-json#type_json_allow_duplicated_key_with_literal_and_nested_object",
      "default": "1"
    }, {
      "name": "type_json_skip_duplicated_paths",
      "href": "/reference/settings/formats/type-json#type_json_skip_duplicated_paths",
      "default": "0"
    }, {
      "name": "type_json_skip_invalid_typed_paths",
      "href": "/reference/settings/formats/type-json#type_json_skip_invalid_typed_paths",
      "default": "0"
    }, {
      "name": "type_json_use_partial_match_to_skip_paths_by_regexp",
      "href": "/reference/settings/formats/type-json#type_json_use_partial_match_to_skip_paths_by_regexp",
      "default": "1"
    }],
    "children": []
  }, {
    "label": "Other",
    "count": 11,
    "settings": [{
      "name": "allow_special_bool_values_inside_variant",
      "href": "/reference/settings/formats/other#allow_special_bool_values_inside_variant",
      "default": "0"
    }, {
      "name": "check_conversion_from_numbers_to_enum",
      "href": "/reference/settings/formats/other#check_conversion_from_numbers_to_enum",
      "default": "1"
    }, {
      "name": "column_names_for_schema_inference",
      "href": "/reference/settings/formats/other#column_names_for_schema_inference",
      "default": "\"\""
    }, {
      "name": "errors_output_format",
      "href": "/reference/settings/formats/other#errors_output_format",
      "default": "CSV"
    }, {
      "name": "insert_distributed_one_random_shard",
      "href": "/reference/settings/formats/other#insert_distributed_one_random_shard",
      "default": "0"
    }, {
      "name": "interval_output_format",
      "href": "/reference/settings/formats/other#interval_output_format",
      "default": "numeric"
    }, {
      "name": "into_outfile_create_parent_directories",
      "href": "/reference/settings/formats/other#into_outfile_create_parent_directories",
      "default": "0"
    }, {
      "name": "json_type_escape_dots_in_keys",
      "href": "/reference/settings/formats/other#json_type_escape_dots_in_keys",
      "default": "0"
    }, {
      "name": "max_dynamic_subcolumns_in_json_type_parsing",
      "href": "/reference/settings/formats/other#max_dynamic_subcolumns_in_json_type_parsing",
      "default": "auto"
    }, {
      "name": "precise_float_parsing",
      "href": "/reference/settings/formats/other#precise_float_parsing",
      "default": "1"
    }, {
      "name": "validate_experimental_and_suspicious_types_inside_nested_types",
      "href": "/reference/settings/formats/other#validate_experimental_and_suspicious_types_inside_nested_types",
      "default": "1"
    }],
    "children": []
  }]);
  const [allGroupKeys] = useState(() => {
    const collectGroupKeys = (items, path = []) => items.flatMap(entry => {
      const key = [...path, entry.label].join("/");
      return [key, ...collectGroupKeys(entry.children, [...path, entry.label])];
    });
    return collectGroupKeys(entries);
  });
  const [expandedGroups, setExpandedGroups] = useState(() => new Set());
  const [searchTerm, setSearchTerm] = useState("");
  const normalizedSearch = searchTerm.trim().toLowerCase();
  const toPlainSearchTerms = value => value.replace(/([a-z0-9])([A-Z])/g, "$1 $2").toLowerCase().split(/[^a-z0-9]+/).filter(term => term.length > 1).map(term => term.length > 3 && term.endsWith("s") ? term.slice(0, -1) : term);
  const usesWildcard = normalizedSearch.includes("%");
  const plainSearchTerms = toPlainSearchTerms(searchTerm);
  const isSearching = usesWildcard ? normalizedSearch.replaceAll("%", "").trim().length > 0 : plainSearchTerms.length > 0;
  const matchesSearch = value => {
    const candidate = value.toLowerCase();
    if (!isSearching) return true;
    if (!usesWildcard) {
      const candidateTerms = toPlainSearchTerms(value);
      return plainSearchTerms.every(searchTerm => candidateTerms.some(candidateTerm => candidateTerm.startsWith(searchTerm)));
    }
    const parts = normalizedSearch.split("%");
    let position = 0;
    for (let index = 0; index < parts.length; index += 1) {
      const part = parts[index];
      if (!part) continue;
      const matchPosition = candidate.indexOf(part, position);
      if (matchPosition < 0) return false;
      if (index === 0 && !normalizedSearch.startsWith("%") && matchPosition !== 0) {
        return false;
      }
      position = matchPosition + part.length;
    }
    const lastPart = parts[parts.length - 1];
    return normalizedSearch.endsWith("%") || !lastPart || position === candidate.length;
  };
  const filterEntry = entry => {
    const settings = entry.settings.filter(setting => matchesSearch(setting.name));
    const children = entry.children.map(filterEntry).filter(Boolean);
    const count = settings.length + children.reduce((total, child) => total + child.count, 0);
    if (!count) return null;
    return {
      ...entry,
      count,
      settings,
      children
    };
  };
  const filteredEntries = isSearching ? entries.map(filterEntry).filter(Boolean) : entries;
  const matchingCount = filteredEntries.reduce((total, entry) => total + entry.count, 0);
  const allGroupsExpanded = allGroupKeys.length > 0 && allGroupKeys.every(key => expandedGroups.has(key));
  const toggleGroup = key => {
    setExpandedGroups(current => {
      const next = new Set(current);
      if (next.has(key)) next.delete(key); else next.add(key);
      return next;
    });
  };
  const toggleAllGroups = () => {
    setExpandedGroups(current => {
      const shouldCollapse = allGroupKeys.every(key => current.has(key));
      return shouldCollapse ? new Set() : new Set(allGroupKeys);
    });
  };
  const branchPrefix = (continuations, isLast) => {
    const prefix = continuations.map(continued => continued ? "│  " : "   ").join("");
    return `${prefix}${isLast ? "└─ " : "├─ "}`;
  };
  const branch = value => <span aria-hidden="true" className="shrink-0 select-none text-gray-400 dark:text-gray-600" style={{
    whiteSpace: "pre"
  }}>
      {value}
    </span>;
  const renderGroup = (entry, continuations = [], isLast = false, path = []) => {
    const key = [...path, entry.label].join("/");
    const isOpen = isSearching || expandedGroups.has(key);
    const items = [...entry.settings.map(setting => ({
      type: "setting",
      value: setting
    })), ...entry.children.map(child => ({
      type: "group",
      value: child
    }))];
    const countLabel = `${entry.count} ${entry.count === 1 ? "setting" : "settings"}`;
    return <div key={key} className="min-w-max">
        <button type="button" aria-expanded={isOpen} disabled={isSearching} onClick={() => toggleGroup(key)} className="flex min-w-max items-baseline whitespace-nowrap text-left" style={{
      appearance: "none",
      background: "transparent",
      border: 0,
      color: "inherit",
      cursor: isSearching ? "default" : "pointer",
      font: "inherit",
      lineHeight: "inherit",
      padding: 0
    }}>
          <span aria-hidden="true" style={{
      display: "inline-block",
      width: "1rem"
    }}>
            {isOpen ? "▾" : "▸"}
          </span>
          {branch(branchPrefix(continuations, isLast))}
          <span className="font-medium">{entry.label}</span>
          <span className="ml-3 text-xs text-gray-500 dark:text-gray-400">{countLabel}</span>
        </button>
        {isOpen && items.map((item, index) => {
      const itemIsLast = index === items.length - 1;
      const childContinuations = [...continuations, !isLast];
      if (item.type === "group") {
        return renderGroup(item.value, childContinuations, itemIsLast, [...path, entry.label]);
      }
      return <div key={item.value.name} className="grid min-w-max items-start gap-x-3 whitespace-nowrap" style={{
        gridTemplateColumns: "44ch max-content"
      }}>
              <span className="flex min-w-0 items-start">
                <span aria-hidden="true" className="w-4 shrink-0" />
                {branch(branchPrefix(childContinuations, itemIsLast))}
                <a href={item.value.href} className="min-w-0 whitespace-normal no-underline hover:underline" style={{
        overflowWrap: "anywhere"
      }}>
                  {item.value.name.split("_").map((part, index, parts) => <span key={`${part}-${index}`}>
                      {part}
                      {index < parts.length - 1 ? "_" : ""}
                      {index < parts.length - 1 && <wbr />}
                    </span>)}
                </a>
              </span>
              {item.value.default !== undefined && <span title="Default value" className="whitespace-nowrap text-gray-500 dark:text-gray-400">
                  (default: {item.value.default})
                </span>}
            </div>;
    })}
      </div>;
  };
  return <div className="not-prose my-6 w-full">
      <div className="relative w-full">
        <svg aria-hidden="true" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" className="pointer-events-none absolute left-3 h-4 w-4 text-gray-500 dark:text-gray-400" style={{
    top: "50%",
    transform: "translateY(-50%)"
  }}>
          <circle cx="11" cy="11" r="8" />
          <path d="m21 21-4.3-4.3" />
        </svg>
        <input aria-label="Search settings" type="search" value={searchTerm} onChange={event => setSearchTerm(event.target.value)} placeholder="Search settings, e.g. parallel replicas or %materialized%" className="w-full rounded-lg border border-gray-500 bg-gray-50 py-2 pl-9 pr-3 text-sm text-gray-900 placeholder:text-gray-600 focus:border-gray-600 focus:outline-0 focus-visible:outline-0 dark:border-white/30 dark:bg-white/5 dark:text-white dark:placeholder:text-gray-400 dark:focus:border-[#fdff75]" />
      </div>
      {isSearching && <div className="mt-2 text-right text-xs text-gray-500 dark:text-gray-400">
          <span>{matchingCount} matching {matchingCount === 1 ? "setting" : "settings"}</span>
        </div>}
      <div className="mt-3 w-full overflow-x-auto rounded-xl border border-gray-200 bg-gray-50/50 px-4 py-3 font-mono text-sm leading-6 dark:border-white/10 dark:bg-transparent">
        <div className="flex min-w-full items-center justify-between gap-4">
          <div className="min-w-max font-semibold">/format-settings</div>
          <button type="button" aria-label={allGroupsExpanded ? "Collapse all" : "Expand all"} aria-pressed={allGroupsExpanded} disabled={isSearching} onClick={toggleAllGroups} className="inline-flex shrink-0 items-center gap-1 whitespace-nowrap rounded border-0 bg-transparent px-1 py-0.5 font-sans text-xs font-medium text-gray-600 hover:text-gray-900 focus:outline-0 focus-visible:text-gray-900 disabled:cursor-not-allowed disabled:opacity-50 dark:text-gray-400 dark:hover:text-[#fdff75] dark:focus-visible:text-[#fdff75]">
            <svg aria-hidden="true" viewBox="0 0 24 24" fill="none" stroke="currentColor" strokeWidth="2" strokeLinecap="round" strokeLinejoin="round" className="h-3 w-3">
              {allGroupsExpanded ? <path d="m6 9 6 6 6-6" /> : <path d="m9 18 6-6-6-6" />}
            </svg>
            <span>{allGroupsExpanded ? "Collapse all" : "Expand all"}</span>
          </button>
        </div>
        {filteredEntries.length > 0 ? filteredEntries.map((entry, index) => renderGroup(entry, [], index === filteredEntries.length - 1)) : <div className="py-2 text-gray-500 dark:text-gray-400">No matching settings</div>}
      </div>
    </div>;
};

These settings are autogenerated from [source](https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/FormatFactorySettings.h).

## Browse format settings

<FormatSettingsExplorer />