> ## Documentation Index
> Fetch the complete documentation index at: https://clickhouse.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Format Settings

> Settings which control input and output formats.

export const FormatSettingsExplorer = () => {
  const [entries] = useState(() => [{
    "label": "bool_*",
    "count": 2,
    "settings": [{
      "name": "bool_false_representation",
      "href": "/reference/settings/formats/bool#bool_false_representation"
    }, {
      "name": "bool_true_representation",
      "href": "/reference/settings/formats/bool#bool_true_representation"
    }],
    "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"
    }, {
      "name": "date_time_input_format",
      "href": "/reference/settings/formats/date-time#date_time_input_format"
    }, {
      "name": "date_time_output_format",
      "href": "/reference/settings/formats/date-time#date_time_output_format"
    }, {
      "name": "date_time_overflow_behavior",
      "href": "/reference/settings/formats/date-time#date_time_overflow_behavior"
    }],
    "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"
    }, {
      "name": "format_geojson_validate_geometry",
      "href": "/reference/settings/formats/format#format_geojson_validate_geometry"
    }, {
      "name": "format_json_object_each_row_column_for_object_name",
      "href": "/reference/settings/formats/format#format_json_object_each_row_column_for_object_name"
    }, {
      "name": "format_protobuf_use_autogenerated_schema",
      "href": "/reference/settings/formats/format#format_protobuf_use_autogenerated_schema"
    }, {
      "name": "format_tsv_null_representation",
      "href": "/reference/settings/formats/format#format_tsv_null_representation"
    }],
    "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"
    }, {
      "name": "format_avro_schema_registry_max_retries",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_max_retries"
    }, {
      "name": "format_avro_schema_registry_receive_timeout",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_receive_timeout"
    }, {
      "name": "format_avro_schema_registry_retry_initial_backoff_ms",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_retry_initial_backoff_ms"
    }, {
      "name": "format_avro_schema_registry_send_timeout",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_send_timeout"
    }, {
      "name": "format_avro_schema_registry_url",
      "href": "/reference/settings/formats/format-avro#format_avro_schema_registry_url"
    }],
    "children": []
  }, {
    "label": "format_binary_*",
    "count": 3,
    "settings": [{
      "name": "format_binary_max_array_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_array_size"
    }, {
      "name": "format_binary_max_object_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_object_size"
    }, {
      "name": "format_binary_max_string_size",
      "href": "/reference/settings/formats/format-binary#format_binary_max_string_size"
    }],
    "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"
    }, {
      "name": "format_capn_proto_max_message_size",
      "href": "/reference/settings/formats/format-capn#format_capn_proto_max_message_size"
    }, {
      "name": "format_capn_proto_use_autogenerated_schema",
      "href": "/reference/settings/formats/format-capn#format_capn_proto_use_autogenerated_schema"
    }],
    "children": []
  }, {
    "label": "format_csv_*",
    "count": 4,
    "settings": [{
      "name": "format_csv_allow_double_quotes",
      "href": "/reference/settings/formats/format-csv#format_csv_allow_double_quotes"
    }, {
      "name": "format_csv_allow_single_quotes",
      "href": "/reference/settings/formats/format-csv#format_csv_allow_single_quotes"
    }, {
      "name": "format_csv_delimiter",
      "href": "/reference/settings/formats/format-csv#format_csv_delimiter"
    }, {
      "name": "format_csv_null_representation",
      "href": "/reference/settings/formats/format-csv#format_csv_null_representation"
    }],
    "children": []
  }, {
    "label": "format_custom_*",
    "count": 7,
    "settings": [{
      "name": "format_custom_escaping_rule",
      "href": "/reference/settings/formats/format-custom#format_custom_escaping_rule"
    }, {
      "name": "format_custom_field_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_field_delimiter"
    }, {
      "name": "format_custom_result_after_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_result_after_delimiter"
    }, {
      "name": "format_custom_result_before_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_result_before_delimiter"
    }, {
      "name": "format_custom_row_after_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_after_delimiter"
    }, {
      "name": "format_custom_row_before_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_before_delimiter"
    }, {
      "name": "format_custom_row_between_delimiter",
      "href": "/reference/settings/formats/format-custom#format_custom_row_between_delimiter"
    }],
    "children": []
  }, {
    "label": "format_regexp_*",
    "count": 3,
    "settings": [{
      "name": "format_regexp",
      "href": "/reference/settings/formats/format-regexp#format_regexp"
    }, {
      "name": "format_regexp_escaping_rule",
      "href": "/reference/settings/formats/format-regexp#format_regexp_escaping_rule"
    }, {
      "name": "format_regexp_skip_unmatched",
      "href": "/reference/settings/formats/format-regexp#format_regexp_skip_unmatched"
    }],
    "children": []
  }, {
    "label": "format_schema_*",
    "count": 3,
    "settings": [{
      "name": "format_schema",
      "href": "/reference/settings/formats/format-schema#format_schema"
    }, {
      "name": "format_schema_message_name",
      "href": "/reference/settings/formats/format-schema#format_schema_message_name"
    }, {
      "name": "format_schema_source",
      "href": "/reference/settings/formats/format-schema#format_schema_source"
    }],
    "children": []
  }, {
    "label": "format_template_*",
    "count": 5,
    "settings": [{
      "name": "format_template_resultset",
      "href": "/reference/settings/formats/format-template#format_template_resultset"
    }, {
      "name": "format_template_resultset_format",
      "href": "/reference/settings/formats/format-template#format_template_resultset_format"
    }, {
      "name": "format_template_row",
      "href": "/reference/settings/formats/format-template#format_template_row"
    }, {
      "name": "format_template_row_format",
      "href": "/reference/settings/formats/format-template#format_template_row_format"
    }, {
      "name": "format_template_rows_between_delimiter",
      "href": "/reference/settings/formats/format-template#format_template_rows_between_delimiter"
    }],
    "children": []
  }, {
    "label": "input_format_*",
    "count": 126,
    "settings": [{
      "name": "input_format_allow_errors_num",
      "href": "/reference/settings/formats/input-format#input_format_allow_errors_num"
    }, {
      "name": "input_format_allow_errors_ratio",
      "href": "/reference/settings/formats/input-format#input_format_allow_errors_ratio"
    }, {
      "name": "input_format_allow_seeks",
      "href": "/reference/settings/formats/input-format#input_format_allow_seeks"
    }, {
      "name": "input_format_arrow_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_arrow_allow_missing_columns"
    }, {
      "name": "input_format_arrow_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_arrow_case_insensitive_column_matching"
    }, {
      "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"
    }, {
      "name": "input_format_arrow_use_native_reader",
      "href": "/reference/settings/formats/input-format#input_format_arrow_use_native_reader"
    }, {
      "name": "input_format_avro_allow_missing_fields",
      "href": "/reference/settings/formats/input-format#input_format_avro_allow_missing_fields"
    }, {
      "name": "input_format_avro_null_as_default",
      "href": "/reference/settings/formats/input-format#input_format_avro_null_as_default"
    }, {
      "name": "input_format_binary_decode_types_in_binary_format",
      "href": "/reference/settings/formats/input-format#input_format_binary_decode_types_in_binary_format"
    }, {
      "name": "input_format_binary_max_type_complexity",
      "href": "/reference/settings/formats/input-format#input_format_binary_max_type_complexity"
    }, {
      "name": "input_format_binary_read_json_as_string",
      "href": "/reference/settings/formats/input-format#input_format_binary_read_json_as_string"
    }, {
      "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"
    }, {
      "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"
    }, {
      "name": "input_format_column_name_matching_mode",
      "href": "/reference/settings/formats/input-format#input_format_column_name_matching_mode"
    }, {
      "name": "input_format_connection_handling",
      "href": "/reference/settings/formats/input-format#input_format_connection_handling"
    }, {
      "name": "input_format_csv_allow_cr_end_of_line",
      "href": "/reference/settings/formats/input-format#input_format_csv_allow_cr_end_of_line"
    }, {
      "name": "input_format_csv_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_csv_allow_variable_number_of_columns"
    }, {
      "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"
    }, {
      "name": "input_format_csv_arrays_as_nested_csv",
      "href": "/reference/settings/formats/input-format#input_format_csv_arrays_as_nested_csv"
    }, {
      "name": "input_format_csv_deserialize_separate_columns_into_tuple",
      "href": "/reference/settings/formats/input-format#input_format_csv_deserialize_separate_columns_into_tuple"
    }, {
      "name": "input_format_csv_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_csv_detect_header"
    }, {
      "name": "input_format_csv_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_csv_empty_as_default"
    }, {
      "name": "input_format_csv_enum_as_number",
      "href": "/reference/settings/formats/input-format#input_format_csv_enum_as_number"
    }, {
      "name": "input_format_csv_missing_nullable_as_empty_string",
      "href": "/reference/settings/formats/input-format#input_format_csv_missing_nullable_as_empty_string"
    }, {
      "name": "input_format_csv_skip_first_lines",
      "href": "/reference/settings/formats/input-format#input_format_csv_skip_first_lines"
    }, {
      "name": "input_format_csv_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_csv_skip_trailing_empty_lines"
    }, {
      "name": "input_format_csv_trim_whitespaces",
      "href": "/reference/settings/formats/input-format#input_format_csv_trim_whitespaces"
    }, {
      "name": "input_format_csv_try_infer_numbers_from_strings",
      "href": "/reference/settings/formats/input-format#input_format_csv_try_infer_numbers_from_strings"
    }, {
      "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"
    }, {
      "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"
    }, {
      "name": "input_format_csv_use_default_on_bad_values",
      "href": "/reference/settings/formats/input-format#input_format_csv_use_default_on_bad_values"
    }, {
      "name": "input_format_custom_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_custom_allow_variable_number_of_columns"
    }, {
      "name": "input_format_custom_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_custom_detect_header"
    }, {
      "name": "input_format_custom_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_custom_skip_trailing_empty_lines"
    }, {
      "name": "input_format_defaults_for_omitted_fields",
      "href": "/reference/settings/formats/input-format#input_format_defaults_for_omitted_fields"
    }, {
      "name": "input_format_force_null_for_omitted_fields",
      "href": "/reference/settings/formats/input-format#input_format_force_null_for_omitted_fields"
    }, {
      "name": "input_format_geojson_unsupported_geometry_handling",
      "href": "/reference/settings/formats/input-format#input_format_geojson_unsupported_geometry_handling"
    }, {
      "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"
    }, {
      "name": "input_format_hive_text_collection_items_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_collection_items_delimiter"
    }, {
      "name": "input_format_hive_text_fields_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_fields_delimiter"
    }, {
      "name": "input_format_hive_text_map_keys_delimiter",
      "href": "/reference/settings/formats/input-format#input_format_hive_text_map_keys_delimiter"
    }, {
      "name": "input_format_import_nested_json",
      "href": "/reference/settings/formats/input-format#input_format_import_nested_json"
    }, {
      "name": "input_format_ipv4_default_on_conversion_error",
      "href": "/reference/settings/formats/input-format#input_format_ipv4_default_on_conversion_error"
    }, {
      "name": "input_format_ipv6_default_on_conversion_error",
      "href": "/reference/settings/formats/input-format#input_format_ipv6_default_on_conversion_error"
    }, {
      "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"
    }, {
      "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"
    }, {
      "name": "input_format_json_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_json_empty_as_default"
    }, {
      "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"
    }, {
      "name": "input_format_json_ignore_unnecessary_fields",
      "href": "/reference/settings/formats/input-format#input_format_json_ignore_unnecessary_fields"
    }, {
      "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"
    }, {
      "name": "input_format_json_infer_incomplete_types_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_infer_incomplete_types_as_strings"
    }, {
      "name": "input_format_json_map_as_array_of_tuples",
      "href": "/reference/settings/formats/input-format#input_format_json_map_as_array_of_tuples"
    }, {
      "name": "input_format_json_max_depth",
      "href": "/reference/settings/formats/input-format#input_format_json_max_depth"
    }, {
      "name": "input_format_json_named_tuples_as_objects",
      "href": "/reference/settings/formats/input-format#input_format_json_named_tuples_as_objects"
    }, {
      "name": "input_format_json_read_arrays_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_arrays_as_strings"
    }, {
      "name": "input_format_json_read_bools_as_numbers",
      "href": "/reference/settings/formats/input-format#input_format_json_read_bools_as_numbers"
    }, {
      "name": "input_format_json_read_bools_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_bools_as_strings"
    }, {
      "name": "input_format_json_read_numbers_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_numbers_as_strings"
    }, {
      "name": "input_format_json_read_objects_as_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_read_objects_as_strings"
    }, {
      "name": "input_format_json_throw_on_bad_escape_sequence",
      "href": "/reference/settings/formats/input-format#input_format_json_throw_on_bad_escape_sequence"
    }, {
      "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"
    }, {
      "name": "input_format_json_try_infer_numbers_from_strings",
      "href": "/reference/settings/formats/input-format#input_format_json_try_infer_numbers_from_strings"
    }, {
      "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"
    }, {
      "name": "input_format_json_validate_types_from_metadata",
      "href": "/reference/settings/formats/input-format#input_format_json_validate_types_from_metadata"
    }, {
      "name": "input_format_max_block_size_bytes",
      "href": "/reference/settings/formats/input-format#input_format_max_block_size_bytes"
    }, {
      "name": "input_format_max_block_wait_ms",
      "href": "/reference/settings/formats/input-format#input_format_max_block_wait_ms"
    }, {
      "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"
    }, {
      "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"
    }, {
      "name": "input_format_msgpack_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_msgpack_number_of_columns"
    }, {
      "name": "input_format_mysql_dump_map_column_names",
      "href": "/reference/settings/formats/input-format#input_format_mysql_dump_map_column_names"
    }, {
      "name": "input_format_mysql_dump_table_name",
      "href": "/reference/settings/formats/input-format#input_format_mysql_dump_table_name"
    }, {
      "name": "input_format_native_allow_types_conversion",
      "href": "/reference/settings/formats/input-format#input_format_native_allow_types_conversion"
    }, {
      "name": "input_format_native_decode_types_in_binary_format",
      "href": "/reference/settings/formats/input-format#input_format_native_decode_types_in_binary_format"
    }, {
      "name": "input_format_null_as_default",
      "href": "/reference/settings/formats/input-format#input_format_null_as_default"
    }, {
      "name": "input_format_orc_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_orc_allow_missing_columns"
    }, {
      "name": "input_format_orc_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_orc_case_insensitive_column_matching"
    }, {
      "name": "input_format_orc_dictionary_as_low_cardinality",
      "href": "/reference/settings/formats/input-format#input_format_orc_dictionary_as_low_cardinality"
    }, {
      "name": "input_format_orc_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_orc_filter_push_down"
    }, {
      "name": "input_format_orc_reader_time_zone_name",
      "href": "/reference/settings/formats/input-format#input_format_orc_reader_time_zone_name"
    }, {
      "name": "input_format_orc_row_batch_size",
      "href": "/reference/settings/formats/input-format#input_format_orc_row_batch_size"
    }, {
      "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"
    }, {
      "name": "input_format_orc_use_fast_decoder",
      "href": "/reference/settings/formats/input-format#input_format_orc_use_fast_decoder"
    }, {
      "name": "input_format_parallel_parsing",
      "href": "/reference/settings/formats/input-format#input_format_parallel_parsing"
    }, {
      "name": "input_format_parquet_allow_geoparquet_parser",
      "href": "/reference/settings/formats/input-format#input_format_parquet_allow_geoparquet_parser"
    }, {
      "name": "input_format_parquet_allow_missing_columns",
      "href": "/reference/settings/formats/input-format#input_format_parquet_allow_missing_columns"
    }, {
      "name": "input_format_parquet_bloom_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_bloom_filter_push_down"
    }, {
      "name": "input_format_parquet_case_insensitive_column_matching",
      "href": "/reference/settings/formats/input-format#input_format_parquet_case_insensitive_column_matching"
    }, {
      "name": "input_format_parquet_enable_json_parsing",
      "href": "/reference/settings/formats/input-format#input_format_parquet_enable_json_parsing"
    }, {
      "name": "input_format_parquet_enable_row_group_prefetch",
      "href": "/reference/settings/formats/input-format#input_format_parquet_enable_row_group_prefetch"
    }, {
      "name": "input_format_parquet_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_filter_push_down"
    }, {
      "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"
    }, {
      "name": "input_format_parquet_local_time_as_utc",
      "href": "/reference/settings/formats/input-format#input_format_parquet_local_time_as_utc"
    }, {
      "name": "input_format_parquet_max_block_size",
      "href": "/reference/settings/formats/input-format#input_format_parquet_max_block_size"
    }, {
      "name": "input_format_parquet_memory_high_watermark",
      "href": "/reference/settings/formats/input-format#input_format_parquet_memory_high_watermark"
    }, {
      "name": "input_format_parquet_memory_low_watermark",
      "href": "/reference/settings/formats/input-format#input_format_parquet_memory_low_watermark"
    }, {
      "name": "input_format_parquet_page_filter_push_down",
      "href": "/reference/settings/formats/input-format#input_format_parquet_page_filter_push_down"
    }, {
      "name": "input_format_parquet_prefer_block_bytes",
      "href": "/reference/settings/formats/input-format#input_format_parquet_prefer_block_bytes"
    }, {
      "name": "input_format_parquet_preserve_order",
      "href": "/reference/settings/formats/input-format#input_format_parquet_preserve_order"
    }, {
      "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"
    }, {
      "name": "input_format_parquet_use_offset_index",
      "href": "/reference/settings/formats/input-format#input_format_parquet_use_offset_index"
    }, {
      "name": "input_format_parquet_verify_checksums",
      "href": "/reference/settings/formats/input-format#input_format_parquet_verify_checksums"
    }, {
      "name": "input_format_protobuf_flatten_google_wrappers",
      "href": "/reference/settings/formats/input-format#input_format_protobuf_flatten_google_wrappers"
    }, {
      "name": "input_format_protobuf_oneof_presence",
      "href": "/reference/settings/formats/input-format#input_format_protobuf_oneof_presence"
    }, {
      "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"
    }, {
      "name": "input_format_record_errors_file_path",
      "href": "/reference/settings/formats/input-format#input_format_record_errors_file_path"
    }, {
      "name": "input_format_skip_unknown_fields",
      "href": "/reference/settings/formats/input-format#input_format_skip_unknown_fields"
    }, {
      "name": "input_format_try_infer_dates",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_dates"
    }, {
      "name": "input_format_try_infer_datetimes",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_datetimes"
    }, {
      "name": "input_format_try_infer_datetimes_only_datetime64",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_datetimes_only_datetime64"
    }, {
      "name": "input_format_try_infer_exponent_floats",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_exponent_floats"
    }, {
      "name": "input_format_try_infer_integers",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_integers"
    }, {
      "name": "input_format_try_infer_variants",
      "href": "/reference/settings/formats/input-format#input_format_try_infer_variants"
    }, {
      "name": "input_format_tsv_allow_variable_number_of_columns",
      "href": "/reference/settings/formats/input-format#input_format_tsv_allow_variable_number_of_columns"
    }, {
      "name": "input_format_tsv_crlf_end_of_line",
      "href": "/reference/settings/formats/input-format#input_format_tsv_crlf_end_of_line"
    }, {
      "name": "input_format_tsv_detect_header",
      "href": "/reference/settings/formats/input-format#input_format_tsv_detect_header"
    }, {
      "name": "input_format_tsv_empty_as_default",
      "href": "/reference/settings/formats/input-format#input_format_tsv_empty_as_default"
    }, {
      "name": "input_format_tsv_enum_as_number",
      "href": "/reference/settings/formats/input-format#input_format_tsv_enum_as_number"
    }, {
      "name": "input_format_tsv_skip_first_lines",
      "href": "/reference/settings/formats/input-format#input_format_tsv_skip_first_lines"
    }, {
      "name": "input_format_tsv_skip_trailing_empty_lines",
      "href": "/reference/settings/formats/input-format#input_format_tsv_skip_trailing_empty_lines"
    }, {
      "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"
    }, {
      "name": "input_format_values_accurate_types_of_literals",
      "href": "/reference/settings/formats/input-format#input_format_values_accurate_types_of_literals"
    }, {
      "name": "input_format_values_deduce_templates_of_expressions",
      "href": "/reference/settings/formats/input-format#input_format_values_deduce_templates_of_expressions"
    }, {
      "name": "input_format_values_interpret_expressions",
      "href": "/reference/settings/formats/input-format#input_format_values_interpret_expressions"
    }, {
      "name": "input_format_with_names_use_header",
      "href": "/reference/settings/formats/input-format#input_format_with_names_use_header"
    }, {
      "name": "input_format_with_types_use_header",
      "href": "/reference/settings/formats/input-format#input_format_with_types_use_header"
    }],
    "children": []
  }, {
    "label": "output_format_*",
    "count": 104,
    "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"
    }, {
      "name": "output_format_arrow_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_arrow_compression_method"
    }, {
      "name": "output_format_arrow_date_as_uint16",
      "href": "/reference/settings/formats/output-format#output_format_arrow_date_as_uint16"
    }, {
      "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"
    }, {
      "name": "output_format_arrow_low_cardinality_as_dictionary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_low_cardinality_as_dictionary"
    }, {
      "name": "output_format_arrow_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_arrow_string_as_string"
    }, {
      "name": "output_format_arrow_unsupported_types_as_binary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_unsupported_types_as_binary"
    }, {
      "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"
    }, {
      "name": "output_format_arrow_use_native_writer",
      "href": "/reference/settings/formats/output-format#output_format_arrow_use_native_writer"
    }, {
      "name": "output_format_arrow_use_signed_indexes_for_dictionary",
      "href": "/reference/settings/formats/output-format#output_format_arrow_use_signed_indexes_for_dictionary"
    }, {
      "name": "output_format_avro_codec",
      "href": "/reference/settings/formats/output-format#output_format_avro_codec"
    }, {
      "name": "output_format_avro_confluent_subject",
      "href": "/reference/settings/formats/output-format#output_format_avro_confluent_subject"
    }, {
      "name": "output_format_avro_rows_in_file",
      "href": "/reference/settings/formats/output-format#output_format_avro_rows_in_file"
    }, {
      "name": "output_format_avro_string_column_pattern",
      "href": "/reference/settings/formats/output-format#output_format_avro_string_column_pattern"
    }, {
      "name": "output_format_avro_sync_interval",
      "href": "/reference/settings/formats/output-format#output_format_avro_sync_interval"
    }, {
      "name": "output_format_binary_encode_types_in_binary_format",
      "href": "/reference/settings/formats/output-format#output_format_binary_encode_types_in_binary_format"
    }, {
      "name": "output_format_binary_write_json_as_string",
      "href": "/reference/settings/formats/output-format#output_format_binary_write_json_as_string"
    }, {
      "name": "output_format_bson_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_bson_string_as_string"
    }, {
      "name": "output_format_compression_level",
      "href": "/reference/settings/formats/output-format#output_format_compression_level"
    }, {
      "name": "output_format_compression_zstd_window_log",
      "href": "/reference/settings/formats/output-format#output_format_compression_zstd_window_log"
    }, {
      "name": "output_format_csv_crlf_end_of_line",
      "href": "/reference/settings/formats/output-format#output_format_csv_crlf_end_of_line"
    }, {
      "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"
    }, {
      "name": "output_format_csv_serialize_tuple_into_separate_columns",
      "href": "/reference/settings/formats/output-format#output_format_csv_serialize_tuple_into_separate_columns"
    }, {
      "name": "output_format_decimal_trailing_zeros",
      "href": "/reference/settings/formats/output-format#output_format_decimal_trailing_zeros"
    }, {
      "name": "output_format_float_precision",
      "href": "/reference/settings/formats/output-format#output_format_float_precision"
    }, {
      "name": "output_format_image_height",
      "href": "/reference/settings/formats/output-format#output_format_image_height"
    }, {
      "name": "output_format_image_terminal_mode",
      "href": "/reference/settings/formats/output-format#output_format_image_terminal_mode"
    }, {
      "name": "output_format_image_width",
      "href": "/reference/settings/formats/output-format#output_format_image_width"
    }, {
      "name": "output_format_json_array_of_rows",
      "href": "/reference/settings/formats/output-format#output_format_json_array_of_rows"
    }, {
      "name": "output_format_json_escape_forward_slashes",
      "href": "/reference/settings/formats/output-format#output_format_json_escape_forward_slashes"
    }, {
      "name": "output_format_json_map_as_array_of_tuples",
      "href": "/reference/settings/formats/output-format#output_format_json_map_as_array_of_tuples"
    }, {
      "name": "output_format_json_named_tuples_as_objects",
      "href": "/reference/settings/formats/output-format#output_format_json_named_tuples_as_objects"
    }, {
      "name": "output_format_json_pretty_print",
      "href": "/reference/settings/formats/output-format#output_format_json_pretty_print"
    }, {
      "name": "output_format_json_quote_64bit_floats",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_64bit_floats"
    }, {
      "name": "output_format_json_quote_64bit_integers",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_64bit_integers"
    }, {
      "name": "output_format_json_quote_decimals",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_decimals"
    }, {
      "name": "output_format_json_quote_denormals",
      "href": "/reference/settings/formats/output-format#output_format_json_quote_denormals"
    }, {
      "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"
    }, {
      "name": "output_format_json_validate_utf8",
      "href": "/reference/settings/formats/output-format#output_format_json_validate_utf8"
    }, {
      "name": "output_format_markdown_escape_special_characters",
      "href": "/reference/settings/formats/output-format#output_format_markdown_escape_special_characters"
    }, {
      "name": "output_format_msgpack_uuid_representation",
      "href": "/reference/settings/formats/output-format#output_format_msgpack_uuid_representation"
    }, {
      "name": "output_format_native_encode_types_in_binary_format",
      "href": "/reference/settings/formats/output-format#output_format_native_encode_types_in_binary_format"
    }, {
      "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"
    }, {
      "name": "output_format_native_write_json_as_string",
      "href": "/reference/settings/formats/output-format#output_format_native_write_json_as_string"
    }, {
      "name": "output_format_orc_compression_block_size",
      "href": "/reference/settings/formats/output-format#output_format_orc_compression_block_size"
    }, {
      "name": "output_format_orc_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_orc_compression_method"
    }, {
      "name": "output_format_orc_dictionary_key_size_threshold",
      "href": "/reference/settings/formats/output-format#output_format_orc_dictionary_key_size_threshold"
    }, {
      "name": "output_format_orc_row_index_stride",
      "href": "/reference/settings/formats/output-format#output_format_orc_row_index_stride"
    }, {
      "name": "output_format_orc_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_orc_string_as_string"
    }, {
      "name": "output_format_orc_writer_time_zone_name",
      "href": "/reference/settings/formats/output-format#output_format_orc_writer_time_zone_name"
    }, {
      "name": "output_format_parallel_formatting",
      "href": "/reference/settings/formats/output-format#output_format_parallel_formatting"
    }, {
      "name": "output_format_parquet_batch_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_batch_size"
    }, {
      "name": "output_format_parquet_bloom_filter_bits_per_value",
      "href": "/reference/settings/formats/output-format#output_format_parquet_bloom_filter_bits_per_value"
    }, {
      "name": "output_format_parquet_bloom_filter_flush_threshold_bytes",
      "href": "/reference/settings/formats/output-format#output_format_parquet_bloom_filter_flush_threshold_bytes"
    }, {
      "name": "output_format_parquet_compression_method",
      "href": "/reference/settings/formats/output-format#output_format_parquet_compression_method"
    }, {
      "name": "output_format_parquet_data_page_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_data_page_size"
    }, {
      "name": "output_format_parquet_date_as_uint16",
      "href": "/reference/settings/formats/output-format#output_format_parquet_date_as_uint16"
    }, {
      "name": "output_format_parquet_datetime_as_uint32",
      "href": "/reference/settings/formats/output-format#output_format_parquet_datetime_as_uint32"
    }, {
      "name": "output_format_parquet_enum_as_byte_array",
      "href": "/reference/settings/formats/output-format#output_format_parquet_enum_as_byte_array"
    }, {
      "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"
    }, {
      "name": "output_format_parquet_geometadata",
      "href": "/reference/settings/formats/output-format#output_format_parquet_geometadata"
    }, {
      "name": "output_format_parquet_max_dictionary_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_max_dictionary_size"
    }, {
      "name": "output_format_parquet_parallel_encoding",
      "href": "/reference/settings/formats/output-format#output_format_parquet_parallel_encoding"
    }, {
      "name": "output_format_parquet_row_group_size",
      "href": "/reference/settings/formats/output-format#output_format_parquet_row_group_size"
    }, {
      "name": "output_format_parquet_row_group_size_bytes",
      "href": "/reference/settings/formats/output-format#output_format_parquet_row_group_size_bytes"
    }, {
      "name": "output_format_parquet_string_as_string",
      "href": "/reference/settings/formats/output-format#output_format_parquet_string_as_string"
    }, {
      "name": "output_format_parquet_write_bloom_filter",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_bloom_filter"
    }, {
      "name": "output_format_parquet_write_checksums",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_checksums"
    }, {
      "name": "output_format_parquet_write_page_index",
      "href": "/reference/settings/formats/output-format#output_format_parquet_write_page_index"
    }, {
      "name": "output_format_pretty_color",
      "href": "/reference/settings/formats/output-format#output_format_pretty_color"
    }, {
      "name": "output_format_pretty_display_footer_column_names",
      "href": "/reference/settings/formats/output-format#output_format_pretty_display_footer_column_names"
    }, {
      "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"
    }, {
      "name": "output_format_pretty_fallback_to_vertical",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical"
    }, {
      "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"
    }, {
      "name": "output_format_pretty_fallback_to_vertical_min_columns",
      "href": "/reference/settings/formats/output-format#output_format_pretty_fallback_to_vertical_min_columns"
    }, {
      "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"
    }, {
      "name": "output_format_pretty_glue_chunks",
      "href": "/reference/settings/formats/output-format#output_format_pretty_glue_chunks"
    }, {
      "name": "output_format_pretty_grid_charset",
      "href": "/reference/settings/formats/output-format#output_format_pretty_grid_charset"
    }, {
      "name": "output_format_pretty_highlight_digit_groups",
      "href": "/reference/settings/formats/output-format#output_format_pretty_highlight_digit_groups"
    }, {
      "name": "output_format_pretty_highlight_trailing_spaces",
      "href": "/reference/settings/formats/output-format#output_format_pretty_highlight_trailing_spaces"
    }, {
      "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"
    }, {
      "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"
    }, {
      "name": "output_format_pretty_max_column_pad_width",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_column_pad_width"
    }, {
      "name": "output_format_pretty_max_rows",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_rows"
    }, {
      "name": "output_format_pretty_max_value_width",
      "href": "/reference/settings/formats/output-format#output_format_pretty_max_value_width"
    }, {
      "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"
    }, {
      "name": "output_format_pretty_multiline_fields",
      "href": "/reference/settings/formats/output-format#output_format_pretty_multiline_fields"
    }, {
      "name": "output_format_pretty_named_tuples_as_json",
      "href": "/reference/settings/formats/output-format#output_format_pretty_named_tuples_as_json"
    }, {
      "name": "output_format_pretty_row_numbers",
      "href": "/reference/settings/formats/output-format#output_format_pretty_row_numbers"
    }, {
      "name": "output_format_pretty_single_large_number_tip_threshold",
      "href": "/reference/settings/formats/output-format#output_format_pretty_single_large_number_tip_threshold"
    }, {
      "name": "output_format_pretty_squash_consecutive_ms",
      "href": "/reference/settings/formats/output-format#output_format_pretty_squash_consecutive_ms"
    }, {
      "name": "output_format_pretty_squash_max_wait_ms",
      "href": "/reference/settings/formats/output-format#output_format_pretty_squash_max_wait_ms"
    }, {
      "name": "output_format_pretty_use_nbsp_for_padding",
      "href": "/reference/settings/formats/output-format#output_format_pretty_use_nbsp_for_padding"
    }, {
      "name": "output_format_protobuf_nullables_with_google_wrappers",
      "href": "/reference/settings/formats/output-format#output_format_protobuf_nullables_with_google_wrappers"
    }, {
      "name": "output_format_schema",
      "href": "/reference/settings/formats/output-format#output_format_schema"
    }, {
      "name": "output_format_sql_insert_include_column_names",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_include_column_names"
    }, {
      "name": "output_format_sql_insert_max_batch_size",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_max_batch_size"
    }, {
      "name": "output_format_sql_insert_quote_names",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_quote_names"
    }, {
      "name": "output_format_sql_insert_table_name",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_table_name"
    }, {
      "name": "output_format_sql_insert_use_replace",
      "href": "/reference/settings/formats/output-format#output_format_sql_insert_use_replace"
    }, {
      "name": "output_format_trim_fixed_string",
      "href": "/reference/settings/formats/output-format#output_format_trim_fixed_string"
    }, {
      "name": "output_format_tsv_crlf_end_of_line",
      "href": "/reference/settings/formats/output-format#output_format_tsv_crlf_end_of_line"
    }, {
      "name": "output_format_values_escape_quote_with_quote",
      "href": "/reference/settings/formats/output-format#output_format_values_escape_quote_with_quote"
    }, {
      "name": "output_format_write_statistics",
      "href": "/reference/settings/formats/output-format#output_format_write_statistics"
    }],
    "children": []
  }, {
    "label": "schema_inference_*",
    "count": 4,
    "settings": [{
      "name": "schema_inference_hints",
      "href": "/reference/settings/formats/schema-inference#schema_inference_hints"
    }, {
      "name": "schema_inference_make_columns_nullable",
      "href": "/reference/settings/formats/schema-inference#schema_inference_make_columns_nullable"
    }, {
      "name": "schema_inference_make_json_columns_nullable",
      "href": "/reference/settings/formats/schema-inference#schema_inference_make_json_columns_nullable"
    }, {
      "name": "schema_inference_mode",
      "href": "/reference/settings/formats/schema-inference#schema_inference_mode"
    }],
    "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"
    }, {
      "name": "show_create_query_identifier_quoting_style",
      "href": "/reference/settings/formats/show-create#show_create_query_identifier_quoting_style"
    }],
    "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"
    }, {
      "name": "type_json_skip_duplicated_paths",
      "href": "/reference/settings/formats/type-json#type_json_skip_duplicated_paths"
    }, {
      "name": "type_json_skip_invalid_typed_paths",
      "href": "/reference/settings/formats/type-json#type_json_skip_invalid_typed_paths"
    }, {
      "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"
    }],
    "children": []
  }, {
    "label": "Other",
    "count": 11,
    "settings": [{
      "name": "allow_special_bool_values_inside_variant",
      "href": "/reference/settings/formats/other#allow_special_bool_values_inside_variant"
    }, {
      "name": "check_conversion_from_numbers_to_enum",
      "href": "/reference/settings/formats/other#check_conversion_from_numbers_to_enum"
    }, {
      "name": "column_names_for_schema_inference",
      "href": "/reference/settings/formats/other#column_names_for_schema_inference"
    }, {
      "name": "errors_output_format",
      "href": "/reference/settings/formats/other#errors_output_format"
    }, {
      "name": "insert_distributed_one_random_shard",
      "href": "/reference/settings/formats/other#insert_distributed_one_random_shard"
    }, {
      "name": "interval_output_format",
      "href": "/reference/settings/formats/other#interval_output_format"
    }, {
      "name": "into_outfile_create_parent_directories",
      "href": "/reference/settings/formats/other#into_outfile_create_parent_directories"
    }, {
      "name": "json_type_escape_dots_in_keys",
      "href": "/reference/settings/formats/other#json_type_escape_dots_in_keys"
    }, {
      "name": "max_dynamic_subcolumns_in_json_type_parsing",
      "href": "/reference/settings/formats/other#max_dynamic_subcolumns_in_json_type_parsing"
    }, {
      "name": "precise_float_parsing",
      "href": "/reference/settings/formats/other#precise_float_parsing"
    }, {
      "name": "validate_experimental_and_suspicious_types_inside_nested_types",
      "href": "/reference/settings/formats/other#validate_experimental_and_suspicious_types_inside_nested_types"
    }],
    "children": []
  }]);
  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 toggleGroup = key => {
    setExpandedGroups(current => {
      const next = new Set(current);
      if (next.has(key)) next.delete(key); else next.add(key);
      return next;
    });
  };
  const branchPrefix = (continuations, isLast) => {
    const prefix = continuations.map(continued => continued ? "│  " : "   ").join("");
    return `${prefix}${isLast ? "└─ " : "├─ "}`;
  };
  const branch = value => <span aria-hidden="true" className="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="flex min-w-max items-baseline whitespace-nowrap">
              <span aria-hidden="true" style={{
        display: "inline-block",
        width: "1rem"
      }} />
              {branch(branchPrefix(childContinuations, itemIsLast))}
              <a href={item.value.href} className="no-underline hover:underline">
                {item.value.name}
              </a>
            </div>;
    })}
      </div>;
  };
  return <div className="not-prose my-6 w-full">
      <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-300 bg-white px-3 py-2 text-sm text-gray-900 outline-none placeholder:text-gray-500 focus:border-yellow-400 focus:ring-2 focus:ring-yellow-400/20 dark:border-white/10 dark:bg-transparent dark:text-white dark:placeholder:text-gray-500" />
      {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="min-w-max font-semibold">/format-settings</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 />