Format Settings

[input\_format\_json\_defaults\_for\_missing\_elements\_in\_named\_tuple](#input_format_json_defaults_for_missing_elements_in_named_tuple)- [input\_format\_json\_empty\_as\_default](#input_format_json_empty_as_default)- [input\_format\_json\_ignore\_unknown\_keys\_in\_named\_tuple](#input_format_json_ignore_unknown_keys_in_named_tuple)- [input\_format\_json\_ignore\_unnecessary\_fields](#input_format_json_ignore_unnecessary_fields)- [input\_format\_json\_infer\_array\_of\_dynamic\_from\_array\_of\_different\_types](#input_format_json_infer_array_of_dynamic_from_array_of_different_types)- [input\_format\_json\_infer\_incomplete\_types\_as\_strings](#input_format_json_infer_incomplete_types_as_strings)- [input\_format\_json\_map\_as\_array\_of\_tuples](#input_format_json_map_as_array_of_tuples)- [input\_format\_json\_max\_depth](#input_format_json_max_depth)- [input\_format\_json\_named\_tuples\_as\_objects](#input_format_json_named_tuples_as_objects)- [input\_format\_json\_read\_arrays\_as\_strings](#input_format_json_read_arrays_as_strings)- [input\_format\_json\_read\_bools\_as\_numbers](#input_format_json_read_bools_as_numbers)- [input\_format\_json\_read\_bools\_as\_strings](#input_format_json_read_bools_as_strings)- [input\_format\_json\_read\_numbers\_as\_strings](#input_format_json_read_numbers_as_strings)- [input\_format\_json\_read\_objects\_as\_strings](#input_format_json_read_objects_as_strings)- [input\_format\_json\_throw\_on\_bad\_escape\_sequence](#input_format_json_throw_on_bad_escape_sequence)- [input\_format\_json\_try\_infer\_named\_tuples\_from\_objects](#input_format_json_try_infer_named_tuples_from_objects)- [input\_format\_json\_try\_infer\_numbers\_from\_strings](#input_format_json_try_infer_numbers_from_strings)- [input\_format\_json\_use\_string\_type\_for\_ambiguous\_paths\_in\_named\_tuples\_inference\_from\_objects](#input_format_json_use_string_type_for_ambiguous_paths_in_named_tuples_inference_from_objects)- [input\_format\_json\_validate\_types\_from\_metadata](#input_format_json_validate_types_from_metadata)- [input\_format\_max\_block\_size\_bytes](#input_format_max_block_size_bytes)- [input\_format\_max\_block\_wait\_ms](#input_format_max_block_wait_ms)- [input\_format\_max\_bytes\_to\_read\_for\_schema\_inference](#input_format_max_bytes_to_read_for_schema_inference)- [input\_format\_max\_rows\_to\_read\_for\_schema\_inference](#input_format_max_rows_to_read_for_schema_inference)- [input\_format\_msgpack\_number\_of\_columns](#input_format_msgpack_number_of_columns)- [input\_format\_mysql\_dump\_map\_column\_names](#input_format_mysql_dump_map_column_names)- [input\_format\_mysql\_dump\_table\_name](#input_format_mysql_dump_table_name)- [input\_format\_native\_allow\_types\_conversion](#input_format_native_allow_types_conversion)- [input\_format\_native\_decode\_types\_in\_binary\_format](#input_format_native_decode_types_in_binary_format)- [input\_format\_null\_as\_default](#input_format_null_as_default)- [input\_format\_orc\_allow\_missing\_columns](#input_format_orc_allow_missing_columns)- [input\_format\_orc\_case\_insensitive\_column\_matching](#input_format_orc_case_insensitive_column_matching)- [input\_format\_orc\_dictionary\_as\_low\_cardinality](#input_format_orc_dictionary_as_low_cardinality)- [input\_format\_orc\_filter\_push\_down](#input_format_orc_filter_push_down)- [input\_format\_orc\_reader\_time\_zone\_name](#input_format_orc_reader_time_zone_name)- [input\_format\_orc\_row\_batch\_size](#input_format_orc_row_batch_size)- [input\_format\_orc\_skip\_columns\_with\_unsupported\_types\_in\_schema\_inference](#input_format_orc_skip_columns_with_unsupported_types_in_schema_inference)- [input\_format\_orc\_use\_fast\_decoder](#input_format_orc_use_fast_decoder)- [input\_format\_parallel\_parsing](#input_format_parallel_parsing)- [input\_format\_parquet\_allow\_geoparquet\_parser](#input_format_parquet_allow_geoparquet_parser)- [input\_format\_parquet\_allow\_missing\_columns](#input_format_parquet_allow_missing_columns)- [input\_format\_parquet\_bloom\_filter\_push\_down](#input_format_parquet_bloom_filter_push_down)- [input\_format\_parquet\_case\_insensitive\_column\_matching](#input_format_parquet_case_insensitive_column_matching)- [input\_format\_parquet\_enable\_json\_parsing](#input_format_parquet_enable_json_parsing)- [input\_format\_parquet\_enable\_row\_group\_prefetch](#input_format_parquet_enable_row_group_prefetch)- [input\_format\_parquet\_filter\_push\_down](#input_format_parquet_filter_push_down)- [input\_format\_parquet\_local\_file\_min\_bytes\_for\_seek](#input_format_parquet_local_file_min_bytes_for_seek)- [input\_format\_parquet\_local\_time\_as\_utc](#input_format_parquet_local_time_as_utc)- [input\_format\_parquet\_max\_block\_size](#input_format_parquet_max_block_size)- [input\_format\_parquet\_memory\_high\_watermark](#input_format_parquet_memory_high_watermark)- [input\_format\_parquet\_memory\_low\_watermark](#input_format_parquet_memory_low_watermark)- [input\_format\_parquet\_page\_filter\_push\_down](#input_format_parquet_page_filter_push_down)- [input\_format\_parquet\_prefer\_block\_bytes](#input_format_parquet_prefer_block_bytes)- [input\_format\_parquet\_preserve\_order](#input_format_parquet_preserve_order)- [input\_format\_parquet\_skip\_columns\_with\_unsupported\_types\_in\_schema\_inference](#input_format_parquet_skip_columns_with_unsupported_types_in_schema_inference)- [input\_format\_parquet\_use\_native\_reader\_v3](#input_format_parquet_use_native_reader_v3)- [input\_format\_parquet\_use\_offset\_index](#input_format_parquet_use_offset_index)- [input\_format\_parquet\_verify\_checksums](#input_format_parquet_verify_checksums)- [input\_format\_protobuf\_flatten\_google\_wrappers](#input_format_protobuf_flatten_google_wrappers)- [input\_format\_protobuf\_oneof\_presence](#input_format_protobuf_oneof_presence)- [input\_format\_protobuf\_skip\_fields\_with\_unsupported\_types\_in\_schema\_inference](#input_format_protobuf_skip_fields_with_unsupported_types_in_schema_inference)- [input\_format\_record\_errors\_file\_path](#input_format_record_errors_file_path)- [input\_format\_skip\_unknown\_fields](#input_format_skip_unknown_fields)- [input\_format\_try\_infer\_dates](#input_format_try_infer_dates)- [input\_format\_try\_infer\_datetimes](#input_format_try_infer_datetimes)- [input\_format\_try\_infer\_datetimes\_only\_datetime64](#input_format_try_infer_datetimes_only_datetime64)- [input\_format\_try\_infer\_exponent\_floats](#input_format_try_infer_exponent_floats)- [input\_format\_try\_infer\_integers](#input_format_try_infer_integers)- [input\_format\_try\_infer\_variants](#input_format_try_infer_variants)- [input\_format\_tsv\_allow\_variable\_number\_of\_columns](#input_format_tsv_allow_variable_number_of_columns)- [input\_format\_tsv\_crlf\_end\_of\_line](#input_format_tsv_crlf_end_of_line)- [input\_format\_tsv\_detect\_header](#input_format_tsv_detect_header)- [input\_format\_tsv\_empty\_as\_default](#input_format_tsv_empty_as_default)- [input\_format\_tsv\_enum\_as\_number](#input_format_tsv_enum_as_number)- [input\_format\_tsv\_skip\_first\_lines](#input_format_tsv_skip_first_lines)- [input\_format\_tsv\_skip\_trailing\_empty\_lines](#input_format_tsv_skip_trailing_empty_lines)- [input\_format\_tsv\_use\_best\_effort\_in\_schema\_inference](#input_format_tsv_use_best_effort_in_schema_inference)- [input\_format\_values\_accurate\_types\_of\_literals](#input_format_values_accurate_types_of_literals)- [input\_format\_values\_deduce\_templates\_of\_expressions](#input_format_values_deduce_templates_of_expressions)- [input\_format\_values\_interpret\_expressions](#input_format_values_interpret_expressions)- [input\_format\_with\_names\_use\_header](#input_format_with_names_use_header)- [input\_format\_with\_types\_use\_header](#input_format_with_types_use_header)- [insert\_distributed\_one\_random\_shard](#insert_distributed_one_random_shard)- [interval\_output\_format](#interval_output_format)- [into\_outfile\_create\_parent\_directories](#into_outfile_create_parent_directories)-