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

# Configurações de formato

> Configurações que controlam os formatos de entrada e saída.

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="https://clickhouse.com/docs/reference/settings/beta-and-experimental-features#beta-features" className="betaBadge">
            <span>Recurso beta</span>
        </a>;
};

export const ExperimentalBadge = () => {
  return <a href="https://clickhouse.com/docs/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>
            Recurso experimental
        </a>;
};

export const FormatSettingsExplorer = ({href: baseRoute}) => {
  const [entries] = useState(() => [{
    label: "bool_*",
    count: 2,
    settings: [{
      name: "bool_false_representation",
      path: "/bool#bool_false_representation",
      default: "false"
    }, {
      name: "bool_true_representation",
      path: "/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",
      path: "/date-time#date_time_64_output_format_cut_trailing_zeros_align_to_groups_of_thousands",
      default: "0"
    }, {
      name: "date_time_input_format",
      path: "/date-time#date_time_input_format",
      default: "best_effort"
    }, {
      name: "date_time_output_format",
      path: "/date-time#date_time_output_format",
      default: "simple"
    }, {
      name: "date_time_overflow_behavior",
      path: "/date-time#date_time_overflow_behavior",
      default: "ignore"
    }],
    children: []
  }, {
    label: "format_*",
    count: 6,
    settings: [{
      name: "format_display_secrets_in_show_and_select",
      path: "/format#format_display_secrets_in_show_and_select",
      default: "0"
    }, {
      name: "format_geojson_validate_geometry",
      path: "/format#format_geojson_validate_geometry",
      default: "1"
    }, {
      name: "format_hive_text_rows_delimiter",
      path: "/format#format_hive_text_rows_delimiter",
      default: '""'
    }, {
      name: "format_json_object_each_row_column_for_object_name",
      path: "/format#format_json_object_each_row_column_for_object_name",
      default: '""'
    }, {
      name: "format_protobuf_use_autogenerated_schema",
      path: "/format#format_protobuf_use_autogenerated_schema",
      default: "1"
    }, {
      name: "format_tsv_null_representation",
      path: "/format#format_tsv_null_representation",
      default: "\\N"
    }],
    children: []
  }, {
    label: "format_avro_*",
    count: 6,
    settings: [{
      name: "format_avro_schema_registry_connection_timeout",
      path: "/format-avro#format_avro_schema_registry_connection_timeout",
      default: "1"
    }, {
      name: "format_avro_schema_registry_max_retries",
      path: "/format-avro#format_avro_schema_registry_max_retries",
      default: "5"
    }, {
      name: "format_avro_schema_registry_receive_timeout",
      path: "/format-avro#format_avro_schema_registry_receive_timeout",
      default: "1"
    }, {
      name: "format_avro_schema_registry_retry_initial_backoff_ms",
      path: "/format-avro#format_avro_schema_registry_retry_initial_backoff_ms",
      default: "100"
    }, {
      name: "format_avro_schema_registry_send_timeout",
      path: "/format-avro#format_avro_schema_registry_send_timeout",
      default: "1"
    }, {
      name: "format_avro_schema_registry_url",
      path: "/format-avro#format_avro_schema_registry_url",
      default: '""'
    }],
    children: []
  }, {
    label: "format_binary_*",
    count: 3,
    settings: [{
      name: "format_binary_max_array_size",
      path: "/format-binary#format_binary_max_array_size",
      default: "1073741824"
    }, {
      name: "format_binary_max_object_size",
      path: "/format-binary#format_binary_max_object_size",
      default: "100000"
    }, {
      name: "format_binary_max_string_size",
      path: "/format-binary#format_binary_max_string_size",
      default: "1073741824"
    }],
    children: []
  }, {
    label: "format_capn_*",
    count: 3,
    settings: [{
      name: "format_capn_proto_enum_comparising_mode",
      path: "/format-capn#format_capn_proto_enum_comparising_mode",
      default: "by_values"
    }, {
      name: "format_capn_proto_max_message_size",
      path: "/format-capn#format_capn_proto_max_message_size",
      default: "1073741824"
    }, {
      name: "format_capn_proto_use_autogenerated_schema",
      path: "/format-capn#format_capn_proto_use_autogenerated_schema",
      default: "1"
    }],
    children: []
  }, {
    label: "format_csv_*",
    count: 4,
    settings: [{
      name: "format_csv_allow_double_quotes",
      path: "/format-csv#format_csv_allow_double_quotes",
      default: "1"
    }, {
      name: "format_csv_allow_single_quotes",
      path: "/format-csv#format_csv_allow_single_quotes",
      default: "0"
    }, {
      name: "format_csv_delimiter",
      path: "/format-csv#format_csv_delimiter",
      default: ","
    }, {
      name: "format_csv_null_representation",
      path: "/format-csv#format_csv_null_representation",
      default: "\\N"
    }],
    children: []
  }, {
    label: "format_custom_*",
    count: 7,
    settings: [{
      name: "format_custom_escaping_rule",
      path: "/format-custom#format_custom_escaping_rule",
      default: "Escaped"
    }, {
      name: "format_custom_field_delimiter",
      path: "/format-custom#format_custom_field_delimiter",
      default: '""'
    }, {
      name: "format_custom_result_after_delimiter",
      path: "/format-custom#format_custom_result_after_delimiter",
      default: '""'
    }, {
      name: "format_custom_result_before_delimiter",
      path: "/format-custom#format_custom_result_before_delimiter",
      default: '""'
    }, {
      name: "format_custom_row_after_delimiter",
      path: "/format-custom#format_custom_row_after_delimiter",
      default: '""'
    }, {
      name: "format_custom_row_before_delimiter",
      path: "/format-custom#format_custom_row_before_delimiter",
      default: '""'
    }, {
      name: "format_custom_row_between_delimiter",
      path: "/format-custom#format_custom_row_between_delimiter",
      default: '""'
    }],
    children: []
  }, {
    label: "format_regexp_*",
    count: 3,
    settings: [{
      name: "format_regexp",
      path: "/format-regexp#format_regexp",
      default: '""'
    }, {
      name: "format_regexp_escaping_rule",
      path: "/format-regexp#format_regexp_escaping_rule",
      default: "Raw"
    }, {
      name: "format_regexp_skip_unmatched",
      path: "/format-regexp#format_regexp_skip_unmatched",
      default: "0"
    }],
    children: []
  }, {
    label: "format_schema_*",
    count: 3,
    settings: [{
      name: "format_schema",
      path: "/format-schema#format_schema",
      default: '""'
    }, {
      name: "format_schema_message_name",
      path: "/format-schema#format_schema_message_name",
      default: '""'
    }, {
      name: "format_schema_source",
      path: "/format-schema#format_schema_source",
      default: "file"
    }],
    children: []
  }, {
    label: "format_template_*",
    count: 5,
    settings: [{
      name: "format_template_resultset",
      path: "/format-template#format_template_resultset",
      default: '""'
    }, {
      name: "format_template_resultset_format",
      path: "/format-template#format_template_resultset_format",
      default: '""'
    }, {
      name: "format_template_row",
      path: "/format-template#format_template_row",
      default: '""'
    }, {
      name: "format_template_row_format",
      path: "/format-template#format_template_row_format",
      default: '""'
    }, {
      name: "format_template_rows_between_delimiter",
      path: "/format-template#format_template_rows_between_delimiter",
      default: '""'
    }],
    children: []
  }, {
    label: "input_format_*",
    count: 128,
    settings: [{
      name: "input_format_allow_errors_num",
      path: "/input-format#input_format_allow_errors_num",
      default: "0"
    }, {
      name: "input_format_allow_errors_ratio",
      path: "/input-format#input_format_allow_errors_ratio",
      default: "0"
    }, {
      name: "input_format_allow_seeks",
      path: "/input-format#input_format_allow_seeks",
      default: "1"
    }, {
      name: "input_format_arrow_allow_missing_columns",
      path: "/input-format#input_format_arrow_allow_missing_columns",
      default: "1"
    }, {
      name: "input_format_arrow_case_insensitive_column_matching",
      path: "/input-format#input_format_arrow_case_insensitive_column_matching",
      default: "0"
    }, {
      name: "input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference",
      path: "/input-format#input_format_arrow_skip_columns_with_unsupported_types_in_schema_inference",
      default: "0"
    }, {
      name: "input_format_avro_allow_missing_fields",
      path: "/input-format#input_format_avro_allow_missing_fields",
      default: "0"
    }, {
      name: "input_format_avro_null_as_default",
      path: "/input-format#input_format_avro_null_as_default",
      default: "0"
    }, {
      name: "input_format_binary_decode_types_in_binary_format",
      path: "/input-format#input_format_binary_decode_types_in_binary_format",
      default: "0"
    }, {
      name: "input_format_binary_max_type_complexity",
      path: "/input-format#input_format_binary_max_type_complexity",
      default: "1000"
    }, {
      name: "input_format_binary_read_json_as_string",
      path: "/input-format#input_format_binary_read_json_as_string",
      default: "0"
    }, {
      name: "input_format_bson_skip_fields_with_unsupported_types_in_schema_inference",
      path: "/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",
      path: "/input-format#input_format_capn_proto_skip_fields_with_unsupported_types_in_schema_inference",
      default: "0"
    }, {
      name: "input_format_column_name_matching_mode",
      path: "/input-format#input_format_column_name_matching_mode",
      default: "auto"
    }, {
      name: "input_format_connection_handling",
      path: "/input-format#input_format_connection_handling",
      default: "0"
    }, {
      name: "input_format_csv_allow_cr_end_of_line",
      path: "/input-format#input_format_csv_allow_cr_end_of_line",
      default: "0"
    }, {
      name: "input_format_csv_allow_variable_number_of_columns",
      path: "/input-format#input_format_csv_allow_variable_number_of_columns",
      default: "0"
    }, {
      name: "input_format_csv_allow_whitespace_or_tab_as_delimiter",
      path: "/input-format#input_format_csv_allow_whitespace_or_tab_as_delimiter",
      default: "0"
    }, {
      name: "input_format_csv_arrays_as_nested_csv",
      path: "/input-format#input_format_csv_arrays_as_nested_csv",
      default: "0"
    }, {
      name: "input_format_csv_deserialize_separate_columns_into_tuple",
      path: "/input-format#input_format_csv_deserialize_separate_columns_into_tuple",
      default: "1"
    }, {
      name: "input_format_csv_detect_header",
      path: "/input-format#input_format_csv_detect_header",
      default: "1"
    }, {
      name: "input_format_csv_empty_as_default",
      path: "/input-format#input_format_csv_empty_as_default",
      default: "1"
    }, {
      name: "input_format_csv_enum_as_number",
      path: "/input-format#input_format_csv_enum_as_number",
      default: "0"
    }, {
      name: "input_format_csv_missing_nullable_as_empty_string",
      path: "/input-format#input_format_csv_missing_nullable_as_empty_string",
      default: "0"
    }, {
      name: "input_format_csv_skip_first_lines",
      path: "/input-format#input_format_csv_skip_first_lines",
      default: "0"
    }, {
      name: "input_format_csv_skip_trailing_empty_lines",
      path: "/input-format#input_format_csv_skip_trailing_empty_lines",
      default: "0"
    }, {
      name: "input_format_csv_trim_whitespaces",
      path: "/input-format#input_format_csv_trim_whitespaces",
      default: "1"
    }, {
      name: "input_format_csv_try_infer_numbers_from_strings",
      path: "/input-format#input_format_csv_try_infer_numbers_from_strings",
      default: "0"
    }, {
      name: "input_format_csv_try_infer_strings_from_quoted_tuples",
      path: "/input-format#input_format_csv_try_infer_strings_from_quoted_tuples",
      default: "1"
    }, {
      name: "input_format_csv_use_best_effort_in_schema_inference",
      path: "/input-format#input_format_csv_use_best_effort_in_schema_inference",
      default: "1"
    }, {
      name: "input_format_csv_use_default_on_bad_values",
      path: "/input-format#input_format_csv_use_default_on_bad_values",
      default: "0"
    }, {
      name: "input_format_custom_allow_variable_number_of_columns",
      path: "/input-format#input_format_custom_allow_variable_number_of_columns",
      default: "0"
    }, {
      name: "input_format_custom_detect_header",
      path: "/input-format#input_format_custom_detect_header",
      default: "1"
    }, {
      name: "input_format_custom_skip_trailing_empty_lines",
      path: "/input-format#input_format_custom_skip_trailing_empty_lines",
      default: "0"
    }, {
      name: "input_format_defaults_for_omitted_fields",
      path: "/input-format#input_format_defaults_for_omitted_fields",
      default: "1"
    }, {
      name: "input_format_force_null_for_omitted_fields",
      path: "/input-format#input_format_force_null_for_omitted_fields",
      default: "0"
    }, {
      name: "input_format_geojson_unsupported_geometry_handling",
      path: "/input-format#input_format_geojson_unsupported_geometry_handling",
      default: "throw"
    }, {
      name: "input_format_hive_text_allow_variable_number_of_columns",
      path: "/input-format#input_format_hive_text_allow_variable_number_of_columns",
      default: "1"
    }, {
      name: "input_format_hive_text_collection_items_delimiter",
      path: "/input-format#input_format_hive_text_collection_items_delimiter",
      default: "\u0002"
    }, {
      name: "input_format_hive_text_fields_delimiter",
      path: "/input-format#input_format_hive_text_fields_delimiter",
      default: "\u0001"
    }, {
      name: "input_format_hive_text_map_keys_delimiter",
      path: "/input-format#input_format_hive_text_map_keys_delimiter",
      default: "\u0003"
    }, {
      name: "input_format_import_nested_json",
      path: "/input-format#input_format_import_nested_json",
      default: "0"
    }, {
      name: "input_format_ipv4_default_on_conversion_error",
      path: "/input-format#input_format_ipv4_default_on_conversion_error",
      default: "0"
    }, {
      name: "input_format_ipv6_default_on_conversion_error",
      path: "/input-format#input_format_ipv6_default_on_conversion_error",
      default: "0"
    }, {
      name: "input_format_json_compact_allow_variable_number_of_columns",
      path: "/input-format#input_format_json_compact_allow_variable_number_of_columns",
      default: "0"
    }, {
      name: "input_format_json_defaults_for_missing_elements_in_named_tuple",
      path: "/input-format#input_format_json_defaults_for_missing_elements_in_named_tuple",
      default: "1"
    }, {
      name: "input_format_json_empty_as_default",
      path: "/input-format#input_format_json_empty_as_default",
      default: "0"
    }, {
      name: "input_format_json_ignore_unknown_keys_in_named_tuple",
      path: "/input-format#input_format_json_ignore_unknown_keys_in_named_tuple",
      default: "1"
    }, {
      name: "input_format_json_ignore_unnecessary_fields",
      path: "/input-format#input_format_json_ignore_unnecessary_fields",
      default: "1"
    }, {
      name: "input_format_json_infer_array_of_dynamic_from_array_of_different_types",
      path: "/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",
      path: "/input-format#input_format_json_infer_incomplete_types_as_strings",
      default: "1"
    }, {
      name: "input_format_json_map_as_array_of_tuples",
      path: "/input-format#input_format_json_map_as_array_of_tuples",
      default: "0"
    }, {
      name: "input_format_json_max_depth",
      path: "/input-format#input_format_json_max_depth",
      default: "1000"
    }, {
      name: "input_format_json_max_string_column_growth_step",
      path: "/input-format#input_format_json_max_string_column_growth_step",
      default: "0"
    }, {
      name: "input_format_json_named_tuples_as_objects",
      path: "/input-format#input_format_json_named_tuples_as_objects",
      default: "1"
    }, {
      name: "input_format_json_read_arrays_as_strings",
      path: "/input-format#input_format_json_read_arrays_as_strings",
      default: "1"
    }, {
      name: "input_format_json_read_bools_as_numbers",
      path: "/input-format#input_format_json_read_bools_as_numbers",
      default: "1"
    }, {
      name: "input_format_json_read_bools_as_strings",
      path: "/input-format#input_format_json_read_bools_as_strings",
      default: "1"
    }, {
      name: "input_format_json_read_numbers_as_strings",
      path: "/input-format#input_format_json_read_numbers_as_strings",
      default: "1"
    }, {
      name: "input_format_json_read_objects_as_strings",
      path: "/input-format#input_format_json_read_objects_as_strings",
      default: "1"
    }, {
      name: "input_format_json_throw_on_bad_escape_sequence",
      path: "/input-format#input_format_json_throw_on_bad_escape_sequence",
      default: "1"
    }, {
      name: "input_format_json_try_infer_named_tuples_from_objects",
      path: "/input-format#input_format_json_try_infer_named_tuples_from_objects",
      default: "1"
    }, {
      name: "input_format_json_try_infer_numbers_from_strings",
      path: "/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",
      path: "/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",
      path: "/input-format#input_format_json_validate_types_from_metadata",
      default: "1"
    }, {
      name: "input_format_max_block_size_bytes",
      path: "/input-format#input_format_max_block_size_bytes",
      default: "0"
    }, {
      name: "input_format_max_block_wait_ms",
      path: "/input-format#input_format_max_block_wait_ms",
      default: "0"
    }, {
      name: "input_format_max_bytes_to_read_for_schema_inference",
      path: "/input-format#input_format_max_bytes_to_read_for_schema_inference",
      default: "33554432"
    }, {
      name: "input_format_max_rows_to_read_for_schema_inference",
      path: "/input-format#input_format_max_rows_to_read_for_schema_inference",
      default: "25000"
    }, {
      name: "input_format_msgpack_number_of_columns",
      path: "/input-format#input_format_msgpack_number_of_columns",
      default: "0"
    }, {
      name: "input_format_mysql_dump_map_column_names",
      path: "/input-format#input_format_mysql_dump_map_column_names",
      default: "1"
    }, {
      name: "input_format_mysql_dump_table_name",
      path: "/input-format#input_format_mysql_dump_table_name",
      default: '""'
    }, {
      name: "input_format_native_allow_types_conversion",
      path: "/input-format#input_format_native_allow_types_conversion",
      default: "1"
    }, {
      name: "input_format_native_decode_types_in_binary_format",
      path: "/input-format#input_format_native_decode_types_in_binary_format",
      default: "0"
    }, {
      name: "input_format_null_as_default",
      path: "/input-format#input_format_null_as_default",
      default: "1"
    }, {
      name: "input_format_orc_allow_missing_columns",
      path: "/input-format#input_format_orc_allow_missing_columns",
      default: "1"
    }, {
      name: "input_format_orc_case_insensitive_column_matching",
      path: "/input-format#input_format_orc_case_insensitive_column_matching",
      default: "0"
    }, {
      name: "input_format_orc_dictionary_as_low_cardinality",
      path: "/input-format#input_format_orc_dictionary_as_low_cardinality",
      default: "1"
    }, {
      name: "input_format_orc_filter_push_down",
      path: "/input-format#input_format_orc_filter_push_down",
      default: "1"
    }, {
      name: "input_format_orc_reader_time_zone_name",
      path: "/input-format#input_format_orc_reader_time_zone_name",
      default: "GMT"
    }, {
      name: "input_format_orc_row_batch_size",
      path: "/input-format#input_format_orc_row_batch_size",
      default: "100000"
    }, {
      name: "input_format_orc_skip_columns_with_unsupported_types_in_schema_inference",
      path: "/input-format#input_format_orc_skip_columns_with_unsupported_types_in_schema_inference",
      default: "0"
    }, {
      name: "input_format_parallel_parsing",
      path: "/input-format#input_format_parallel_parsing",
      default: "1"
    }, {
      name: "input_format_parquet_allow_geoparquet_parser",
      path: "/input-format#input_format_parquet_allow_geoparquet_parser",
      default: "1"
    }, {
      name: "input_format_parquet_allow_missing_columns",
      path: "/input-format#input_format_parquet_allow_missing_columns",
      default: "1"
    }, {
      name: "input_format_parquet_bloom_filter_push_down",
      path: "/input-format#input_format_parquet_bloom_filter_push_down",
      default: "1"
    }, {
      name: "input_format_parquet_case_insensitive_column_matching",
      path: "/input-format#input_format_parquet_case_insensitive_column_matching",
      default: "0"
    }, {
      name: "input_format_parquet_dictionary_filter_push_down",
      path: "/input-format#input_format_parquet_dictionary_filter_push_down",
      default: "1048576"
    }, {
      name: "input_format_parquet_enable_json_parsing",
      path: "/input-format#input_format_parquet_enable_json_parsing",
      default: "1"
    }, {
      name: "input_format_parquet_enable_row_group_prefetch",
      path: "/input-format#input_format_parquet_enable_row_group_prefetch",
      default: "1"
    }, {
      name: "input_format_parquet_filter_push_down",
      path: "/input-format#input_format_parquet_filter_push_down",
      default: "1"
    }, {
      name: "input_format_parquet_local_file_min_bytes_for_seek",
      path: "/input-format#input_format_parquet_local_file_min_bytes_for_seek",
      default: "8192"
    }, {
      name: "input_format_parquet_local_time_as_utc",
      path: "/input-format#input_format_parquet_local_time_as_utc",
      default: "1"
    }, {
      name: "input_format_parquet_max_block_size",
      path: "/input-format#input_format_parquet_max_block_size",
      default: "65409"
    }, {
      name: "input_format_parquet_memory_high_watermark",
      path: "/input-format#input_format_parquet_memory_high_watermark",
      default: "4294967296"
    }, {
      name: "input_format_parquet_memory_low_watermark",
      path: "/input-format#input_format_parquet_memory_low_watermark",
      default: "2097152"
    }, {
      name: "input_format_parquet_page_filter_push_down",
      path: "/input-format#input_format_parquet_page_filter_push_down",
      default: "1"
    }, {
      name: "input_format_parquet_prefer_block_bytes",
      path: "/input-format#input_format_parquet_prefer_block_bytes",
      default: "16744704"
    }, {
      name: "input_format_parquet_preserve_order",
      path: "/input-format#input_format_parquet_preserve_order",
      default: "0"
    }, {
      name: "input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference",
      path: "/input-format#input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference",
      default: "0"
    }, {
      name: "input_format_parquet_spatial_filter_push_down",
      path: "/input-format#input_format_parquet_spatial_filter_push_down",
      default: "1"
    }, {
      name: "input_format_parquet_use_offset_index",
      path: "/input-format#input_format_parquet_use_offset_index",
      default: "1"
    }, {
      name: "input_format_parquet_verify_checksums",
      path: "/input-format#input_format_parquet_verify_checksums",
      default: "1"
    }, {
      name: "input_format_protobuf_flatten_google_wrappers",
      path: "/input-format#input_format_protobuf_flatten_google_wrappers",
      default: "0"
    }, {
      name: "input_format_protobuf_oneof_presence",
      path: "/input-format#input_format_protobuf_oneof_presence",
      default: "0"
    }, {
      name: "input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference",
      path: "/input-format#input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference",
      default: "0"
    }, {
      name: "input_format_read_datetime_number_as_raw_value",
      path: "/input-format#input_format_read_datetime_number_as_raw_value",
      default: "0"
    }, {
      name: "input_format_record_errors_file_path",
      path: "/input-format#input_format_record_errors_file_path",
      default: '""'
    }, {
      name: "input_format_skip_unknown_fields",
      path: "/input-format#input_format_skip_unknown_fields",
      default: "1"
    }, {
      name: "input_format_try_infer_dates",
      path: "/input-format#input_format_try_infer_dates",
      default: "1"
    }, {
      name: "input_format_try_infer_datetimes",
      path: "/input-format#input_format_try_infer_datetimes",
      default: "1"
    }, {
      name: "input_format_try_infer_datetimes_only_datetime64",
      path: "/input-format#input_format_try_infer_datetimes_only_datetime64",
      default: "0"
    }, {
      name: "input_format_try_infer_exponent_floats",
      path: "/input-format#input_format_try_infer_exponent_floats",
      default: "0"
    }, {
      name: "input_format_try_infer_integers",
      path: "/input-format#input_format_try_infer_integers",
      default: "1"
    }, {
      name: "input_format_try_infer_variants",
      path: "/input-format#input_format_try_infer_variants",
      default: "0"
    }, {
      name: "input_format_tsv_allow_variable_number_of_columns",
      path: "/input-format#input_format_tsv_allow_variable_number_of_columns",
      default: "0"
    }, {
      name: "input_format_tsv_crlf_end_of_line",
      path: "/input-format#input_format_tsv_crlf_end_of_line",
      default: "0"
    }, {
      name: "input_format_tsv_detect_header",
      path: "/input-format#input_format_tsv_detect_header",
      default: "1"
    }, {
      name: "input_format_tsv_empty_as_default",
      path: "/input-format#input_format_tsv_empty_as_default",
      default: "0"
    }, {
      name: "input_format_tsv_enum_as_number",
      path: "/input-format#input_format_tsv_enum_as_number",
      default: "0"
    }, {
      name: "input_format_tsv_skip_first_lines",
      path: "/input-format#input_format_tsv_skip_first_lines",
      default: "0"
    }, {
      name: "input_format_tsv_skip_trailing_empty_lines",
      path: "/input-format#input_format_tsv_skip_trailing_empty_lines",
      default: "0"
    }, {
      name: "input_format_tsv_use_best_effort_in_schema_inference",
      path: "/input-format#input_format_tsv_use_best_effort_in_schema_inference",
      default: "1"
    }, {
      name: "input_format_values_accurate_types_of_literals",
      path: "/input-format#input_format_values_accurate_types_of_literals",
      default: "1"
    }, {
      name: "input_format_values_deduce_templates_of_expressions",
      path: "/input-format#input_format_values_deduce_templates_of_expressions",
      default: "1"
    }, {
      name: "input_format_values_interpret_expressions",
      path: "/input-format#input_format_values_interpret_expressions",
      default: "1"
    }, {
      name: "input_format_with_names_use_header",
      path: "/input-format#input_format_with_names_use_header",
      default: "1"
    }, {
      name: "input_format_with_types_use_header",
      path: "/input-format#input_format_with_types_use_header",
      default: "1"
    }],
    children: []
  }, {
    label: "output_format_*",
    count: 106,
    settings: [{
      name: "output_format_always_write_decimal_point_in_float_and_decimal",
      path: "/output-format#output_format_always_write_decimal_point_in_float_and_decimal",
      default: "0"
    }, {
      name: "output_format_arrow_compression_method",
      path: "/output-format#output_format_arrow_compression_method",
      default: "lz4_frame"
    }, {
      name: "output_format_arrow_date_as_uint16",
      path: "/output-format#output_format_arrow_date_as_uint16",
      default: "0"
    }, {
      name: "output_format_arrow_fixed_string_as_fixed_byte_array",
      path: "/output-format#output_format_arrow_fixed_string_as_fixed_byte_array",
      default: "1"
    }, {
      name: "output_format_arrow_low_cardinality_as_dictionary",
      path: "/output-format#output_format_arrow_low_cardinality_as_dictionary",
      default: "0"
    }, {
      name: "output_format_arrow_string_as_string",
      path: "/output-format#output_format_arrow_string_as_string",
      default: "1"
    }, {
      name: "output_format_arrow_unsupported_types_as_binary",
      path: "/output-format#output_format_arrow_unsupported_types_as_binary",
      default: "1"
    }, {
      name: "output_format_arrow_use_64_bit_indexes_for_dictionary",
      path: "/output-format#output_format_arrow_use_64_bit_indexes_for_dictionary",
      default: "0"
    }, {
      name: "output_format_arrow_use_signed_indexes_for_dictionary",
      path: "/output-format#output_format_arrow_use_signed_indexes_for_dictionary",
      default: "1"
    }, {
      name: "output_format_avro_codec",
      path: "/output-format#output_format_avro_codec",
      default: '""'
    }, {
      name: "output_format_avro_confluent_subject",
      path: "/output-format#output_format_avro_confluent_subject",
      default: '""'
    }, {
      name: "output_format_avro_rows_in_file",
      path: "/output-format#output_format_avro_rows_in_file",
      default: "1"
    }, {
      name: "output_format_avro_string_column_pattern",
      path: "/output-format#output_format_avro_string_column_pattern",
      default: '""'
    }, {
      name: "output_format_avro_sync_interval",
      path: "/output-format#output_format_avro_sync_interval",
      default: "16384"
    }, {
      name: "output_format_binary_encode_types_in_binary_format",
      path: "/output-format#output_format_binary_encode_types_in_binary_format",
      default: "0"
    }, {
      name: "output_format_binary_write_json_as_string",
      path: "/output-format#output_format_binary_write_json_as_string",
      default: "0"
    }, {
      name: "output_format_bson_string_as_string",
      path: "/output-format#output_format_bson_string_as_string",
      default: "0"
    }, {
      name: "output_format_compression_level",
      path: "/output-format#output_format_compression_level",
      default: "3"
    }, {
      name: "output_format_compression_zstd_window_log",
      path: "/output-format#output_format_compression_zstd_window_log",
      default: "0"
    }, {
      name: "output_format_csv_crlf_end_of_line",
      path: "/output-format#output_format_csv_crlf_end_of_line",
      default: "0"
    }, {
      name: "output_format_csv_header_serialize_tuple_into_separate_columns",
      path: "/output-format#output_format_csv_header_serialize_tuple_into_separate_columns",
      default: "1"
    }, {
      name: "output_format_csv_serialize_tuple_into_separate_columns",
      path: "/output-format#output_format_csv_serialize_tuple_into_separate_columns",
      default: "1"
    }, {
      name: "output_format_decimal_trailing_zeros",
      path: "/output-format#output_format_decimal_trailing_zeros",
      default: "0"
    }, {
      name: "output_format_float_precision",
      path: "/output-format#output_format_float_precision",
      default: "0"
    }, {
      name: "output_format_image_height",
      path: "/output-format#output_format_image_height",
      default: "1024"
    }, {
      name: "output_format_image_streaming_animation",
      path: "/output-format#output_format_image_streaming_animation",
      default: "0"
    }, {
      name: "output_format_image_terminal_mode",
      path: "/output-format#output_format_image_terminal_mode",
      default: '""'
    }, {
      name: "output_format_image_time_divisor_seconds",
      path: "/output-format#output_format_image_time_divisor_seconds",
      default: "60"
    }, {
      name: "output_format_image_time_multiplier_seconds",
      path: "/output-format#output_format_image_time_multiplier_seconds",
      default: "1"
    }, {
      name: "output_format_image_width",
      path: "/output-format#output_format_image_width",
      default: "1024"
    }, {
      name: "output_format_json_array_of_rows",
      path: "/output-format#output_format_json_array_of_rows",
      default: "0"
    }, {
      name: "output_format_json_escape_forward_slashes",
      path: "/output-format#output_format_json_escape_forward_slashes",
      default: "1"
    }, {
      name: "output_format_json_map_as_array_of_tuples",
      path: "/output-format#output_format_json_map_as_array_of_tuples",
      default: "0"
    }, {
      name: "output_format_json_named_tuples_as_objects",
      path: "/output-format#output_format_json_named_tuples_as_objects",
      default: "1"
    }, {
      name: "output_format_json_pretty_print",
      path: "/output-format#output_format_json_pretty_print",
      default: "1"
    }, {
      name: "output_format_json_quote_64bit_floats",
      path: "/output-format#output_format_json_quote_64bit_floats",
      default: "0"
    }, {
      name: "output_format_json_quote_64bit_integers",
      path: "/output-format#output_format_json_quote_64bit_integers",
      default: "0"
    }, {
      name: "output_format_json_quote_decimals",
      path: "/output-format#output_format_json_quote_decimals",
      default: "0"
    }, {
      name: "output_format_json_quote_denormals",
      path: "/output-format#output_format_json_quote_denormals",
      default: "0"
    }, {
      name: "output_format_json_skip_null_value_in_named_tuples",
      path: "/output-format#output_format_json_skip_null_value_in_named_tuples",
      default: "0"
    }, {
      name: "output_format_json_validate_utf8",
      path: "/output-format#output_format_json_validate_utf8",
      default: "0"
    }, {
      name: "output_format_markdown_escape_special_characters",
      path: "/output-format#output_format_markdown_escape_special_characters",
      default: "0"
    }, {
      name: "output_format_msgpack_uuid_representation",
      path: "/output-format#output_format_msgpack_uuid_representation",
      default: "ext"
    }, {
      name: "output_format_native_encode_types_in_binary_format",
      path: "/output-format#output_format_native_encode_types_in_binary_format",
      default: "0"
    }, {
      name: "output_format_native_use_flattened_dynamic_and_json_serialization",
      path: "/output-format#output_format_native_use_flattened_dynamic_and_json_serialization",
      default: "0"
    }, {
      name: "output_format_native_write_json_as_string",
      path: "/output-format#output_format_native_write_json_as_string",
      default: "0"
    }, {
      name: "output_format_orc_compression_block_size",
      path: "/output-format#output_format_orc_compression_block_size",
      default: "262144"
    }, {
      name: "output_format_orc_compression_method",
      path: "/output-format#output_format_orc_compression_method",
      default: "zstd"
    }, {
      name: "output_format_orc_dictionary_key_size_threshold",
      path: "/output-format#output_format_orc_dictionary_key_size_threshold",
      default: "0"
    }, {
      name: "output_format_orc_row_index_stride",
      path: "/output-format#output_format_orc_row_index_stride",
      default: "10000"
    }, {
      name: "output_format_orc_string_as_string",
      path: "/output-format#output_format_orc_string_as_string",
      default: "1"
    }, {
      name: "output_format_orc_writer_time_zone_name",
      path: "/output-format#output_format_orc_writer_time_zone_name",
      default: "GMT"
    }, {
      name: "output_format_parallel_formatting",
      path: "/output-format#output_format_parallel_formatting",
      default: "1"
    }, {
      name: "output_format_parquet_batch_size",
      path: "/output-format#output_format_parquet_batch_size",
      default: "1024"
    }, {
      name: "output_format_parquet_bloom_filter_bits_per_value",
      path: "/output-format#output_format_parquet_bloom_filter_bits_per_value",
      default: "10.5"
    }, {
      name: "output_format_parquet_bloom_filter_flush_threshold_bytes",
      path: "/output-format#output_format_parquet_bloom_filter_flush_threshold_bytes",
      default: "134217728"
    }, {
      name: "output_format_parquet_compression_method",
      path: "/output-format#output_format_parquet_compression_method",
      default: "zstd"
    }, {
      name: "output_format_parquet_data_page_size",
      path: "/output-format#output_format_parquet_data_page_size",
      default: "1048576"
    }, {
      name: "output_format_parquet_date_as_uint16",
      path: "/output-format#output_format_parquet_date_as_uint16",
      default: "0"
    }, {
      name: "output_format_parquet_datetime_as_uint32",
      path: "/output-format#output_format_parquet_datetime_as_uint32",
      default: "0"
    }, {
      name: "output_format_parquet_enum_as_byte_array",
      path: "/output-format#output_format_parquet_enum_as_byte_array",
      default: "1"
    }, {
      name: "output_format_parquet_fixed_string_as_fixed_byte_array",
      path: "/output-format#output_format_parquet_fixed_string_as_fixed_byte_array",
      default: "1"
    }, {
      name: "output_format_parquet_geometadata",
      path: "/output-format#output_format_parquet_geometadata",
      default: "1"
    }, {
      name: "output_format_parquet_max_dictionary_size",
      path: "/output-format#output_format_parquet_max_dictionary_size",
      default: "1048576"
    }, {
      name: "output_format_parquet_parallel_encoding",
      path: "/output-format#output_format_parquet_parallel_encoding",
      default: "1"
    }, {
      name: "output_format_parquet_row_group_size",
      path: "/output-format#output_format_parquet_row_group_size",
      default: "1000000"
    }, {
      name: "output_format_parquet_row_group_size_bytes",
      path: "/output-format#output_format_parquet_row_group_size_bytes",
      default: "536870912"
    }, {
      name: "output_format_parquet_string_as_string",
      path: "/output-format#output_format_parquet_string_as_string",
      default: "1"
    }, {
      name: "output_format_parquet_write_bloom_filter",
      path: "/output-format#output_format_parquet_write_bloom_filter",
      default: "1"
    }, {
      name: "output_format_parquet_write_checksums",
      path: "/output-format#output_format_parquet_write_checksums",
      default: "1"
    }, {
      name: "output_format_parquet_write_page_index",
      path: "/output-format#output_format_parquet_write_page_index",
      default: "1"
    }, {
      name: "output_format_pretty_color",
      path: "/output-format#output_format_pretty_color",
      default: "auto"
    }, {
      name: "output_format_pretty_display_footer_column_names",
      path: "/output-format#output_format_pretty_display_footer_column_names",
      default: "1"
    }, {
      name: "output_format_pretty_display_footer_column_names_min_rows",
      path: "/output-format#output_format_pretty_display_footer_column_names_min_rows",
      default: "50"
    }, {
      name: "output_format_pretty_fallback_to_vertical",
      path: "/output-format#output_format_pretty_fallback_to_vertical",
      default: "1"
    }, {
      name: "output_format_pretty_fallback_to_vertical_max_rows_per_chunk",
      path: "/output-format#output_format_pretty_fallback_to_vertical_max_rows_per_chunk",
      default: "10"
    }, {
      name: "output_format_pretty_fallback_to_vertical_min_columns",
      path: "/output-format#output_format_pretty_fallback_to_vertical_min_columns",
      default: "5"
    }, {
      name: "output_format_pretty_fallback_to_vertical_min_table_width",
      path: "/output-format#output_format_pretty_fallback_to_vertical_min_table_width",
      default: "250"
    }, {
      name: "output_format_pretty_glue_chunks",
      path: "/output-format#output_format_pretty_glue_chunks",
      default: "auto"
    }, {
      name: "output_format_pretty_grid_charset",
      path: "/output-format#output_format_pretty_grid_charset",
      default: "UTF-8"
    }, {
      name: "output_format_pretty_highlight_digit_groups",
      path: "/output-format#output_format_pretty_highlight_digit_groups",
      default: "1"
    }, {
      name: "output_format_pretty_highlight_trailing_spaces",
      path: "/output-format#output_format_pretty_highlight_trailing_spaces",
      default: "1"
    }, {
      name: "output_format_pretty_max_column_name_width_cut_to",
      path: "/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",
      path: "/output-format#output_format_pretty_max_column_name_width_min_chars_to_cut",
      default: "4"
    }, {
      name: "output_format_pretty_max_column_pad_width",
      path: "/output-format#output_format_pretty_max_column_pad_width",
      default: "250"
    }, {
      name: "output_format_pretty_max_rows",
      path: "/output-format#output_format_pretty_max_rows",
      default: "1000"
    }, {
      name: "output_format_pretty_max_value_width",
      path: "/output-format#output_format_pretty_max_value_width",
      default: "10000"
    }, {
      name: "output_format_pretty_max_value_width_apply_for_single_value",
      path: "/output-format#output_format_pretty_max_value_width_apply_for_single_value",
      default: "0"
    }, {
      name: "output_format_pretty_multiline_fields",
      path: "/output-format#output_format_pretty_multiline_fields",
      default: "1"
    }, {
      name: "output_format_pretty_named_tuples_as_json",
      path: "/output-format#output_format_pretty_named_tuples_as_json",
      default: "1"
    }, {
      name: "output_format_pretty_row_numbers",
      path: "/output-format#output_format_pretty_row_numbers",
      default: "1"
    }, {
      name: "output_format_pretty_single_large_number_tip_threshold",
      path: "/output-format#output_format_pretty_single_large_number_tip_threshold",
      default: "1000000"
    }, {
      name: "output_format_pretty_squash_consecutive_ms",
      path: "/output-format#output_format_pretty_squash_consecutive_ms",
      default: "50"
    }, {
      name: "output_format_pretty_squash_max_wait_ms",
      path: "/output-format#output_format_pretty_squash_max_wait_ms",
      default: "1000"
    }, {
      name: "output_format_pretty_use_nbsp_for_padding",
      path: "/output-format#output_format_pretty_use_nbsp_for_padding",
      default: "0"
    }, {
      name: "output_format_protobuf_nullables_with_google_wrappers",
      path: "/output-format#output_format_protobuf_nullables_with_google_wrappers",
      default: "0"
    }, {
      name: "output_format_schema",
      path: "/output-format#output_format_schema",
      default: '""'
    }, {
      name: "output_format_sql_insert_include_column_names",
      path: "/output-format#output_format_sql_insert_include_column_names",
      default: "1"
    }, {
      name: "output_format_sql_insert_max_batch_size",
      path: "/output-format#output_format_sql_insert_max_batch_size",
      default: "65409"
    }, {
      name: "output_format_sql_insert_quote_names",
      path: "/output-format#output_format_sql_insert_quote_names",
      default: "1"
    }, {
      name: "output_format_sql_insert_table_name",
      path: "/output-format#output_format_sql_insert_table_name",
      default: "table"
    }, {
      name: "output_format_sql_insert_use_replace",
      path: "/output-format#output_format_sql_insert_use_replace",
      default: "0"
    }, {
      name: "output_format_trim_fixed_string",
      path: "/output-format#output_format_trim_fixed_string",
      default: "0"
    }, {
      name: "output_format_tsv_crlf_end_of_line",
      path: "/output-format#output_format_tsv_crlf_end_of_line",
      default: "0"
    }, {
      name: "output_format_values_escape_quote_with_quote",
      path: "/output-format#output_format_values_escape_quote_with_quote",
      default: "0"
    }, {
      name: "output_format_write_statistics",
      path: "/output-format#output_format_write_statistics",
      default: "1"
    }],
    children: []
  }, {
    label: "schema_inference_*",
    count: 4,
    settings: [{
      name: "schema_inference_hints",
      path: "/schema-inference#schema_inference_hints",
      default: '""'
    }, {
      name: "schema_inference_make_columns_nullable",
      path: "/schema-inference#schema_inference_make_columns_nullable",
      default: "3"
    }, {
      name: "schema_inference_make_json_columns_nullable",
      path: "/schema-inference#schema_inference_make_json_columns_nullable",
      default: "0"
    }, {
      name: "schema_inference_mode",
      path: "/schema-inference#schema_inference_mode",
      default: "default"
    }],
    children: []
  }, {
    label: "show_create_*",
    count: 2,
    settings: [{
      name: "show_create_query_identifier_quoting_rule",
      path: "/show-create#show_create_query_identifier_quoting_rule",
      default: "when_necessary"
    }, {
      name: "show_create_query_identifier_quoting_style",
      path: "/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",
      path: "/type-json#type_json_allow_duplicated_key_with_literal_and_nested_object",
      default: "1"
    }, {
      name: "type_json_skip_duplicated_paths",
      path: "/type-json#type_json_skip_duplicated_paths",
      default: "0"
    }, {
      name: "type_json_skip_invalid_typed_paths",
      path: "/type-json#type_json_skip_invalid_typed_paths",
      default: "0"
    }, {
      name: "type_json_use_partial_match_to_skip_paths_by_regexp",
      path: "/type-json#type_json_use_partial_match_to_skip_paths_by_regexp",
      default: "1"
    }],
    children: []
  }, {
    label: "Outros",
    count: 11,
    settings: [{
      name: "allow_special_bool_values_inside_variant",
      path: "/other#allow_special_bool_values_inside_variant",
      default: "0"
    }, {
      name: "check_conversion_from_numbers_to_enum",
      path: "/other#check_conversion_from_numbers_to_enum",
      default: "1"
    }, {
      name: "column_names_for_schema_inference",
      path: "/other#column_names_for_schema_inference",
      default: '""'
    }, {
      name: "errors_output_format",
      path: "/other#errors_output_format",
      default: "CSV"
    }, {
      name: "insert_distributed_one_random_shard",
      path: "/other#insert_distributed_one_random_shard",
      default: "0"
    }, {
      name: "interval_output_format",
      path: "/other#interval_output_format",
      default: "numeric"
    }, {
      name: "into_outfile_create_parent_directories",
      path: "/other#into_outfile_create_parent_directories",
      default: "0"
    }, {
      name: "json_type_escape_dots_in_keys",
      path: "/other#json_type_escape_dots_in_keys",
      default: "0"
    }, {
      name: "max_dynamic_subcolumns_in_json_type_parsing",
      path: "/other#max_dynamic_subcolumns_in_json_type_parsing",
      default: "auto"
    }, {
      name: "precise_float_parsing",
      path: "/other#precise_float_parsing",
      default: "1"
    }, {
      name: "validate_experimental_and_suspicious_types_inside_nested_types",
      path: "/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 ? "configuração" : "configurações"}`;
    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={`https://clickhouse.com/docs${baseRoute}${item.value.path}`} 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="Valor padrão" className="whitespace-nowrap text-gray-500 dark:text-gray-400">
                    (padrão: {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="Buscar configurações" type="search" value={searchTerm} onChange={event => setSearchTerm(event.target.value)} placeholder="Buscar configurações, ex.: parallel replicas ou %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} {matchingCount === 1 ? "configuração correspondente" : "configurações correspondentes"}
          </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 ? "Recolher tudo" : "Expandir tudo"} 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 ? "Recolher tudo" : "Expandir tudo"}</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">Nenhuma configuração encontrada</div>}
      </div>
    </div>;
};

Essas configurações são geradas automaticamente a partir do [código-fonte](https://github.com/ClickHouse/ClickHouse/blob/master/src/Core/FormatFactorySettings.h).

<div id="browse-format-settings">
  ## Explorar configurações de formato
</div>

<FormatSettingsExplorer href="/pt-BR/reference/settings/formats" />