more_settings_duckdb

settings:
        ###### GENERAL RESOURCE PROVISIONING ######
        max_memory: "4 GiB"
        # max_temp_directory_size: "90% of available disk space"
        # threads: 20
        # external_threads: 4
        # max_vacuum_tasks: 100

        ###### MORE NICHE PERFORMANCE / RESOURCE SETTINGS ######
        # enable_fsst_vectors: false # Only useful for specific string uses cases.
        # checkpoint_threshold: "1000.0 MiB"
        # preserve_insertion_order: false
        # allocator_background_threads: true
        # allocator_bulk_deallocation_flush_threshold: "20000.0 MiB"
        # allocator_flush_threshold: "10000.0 MiB"
        # # scheduler_process_partial: false
        # streaming_buffer_size: "4 GiB"

        ###### QUERY OPTIMIZATION SETTINGS ######
        # asof_loop_join_threshold: 64
        # dynamic_or_filter_threshold: 50
        # merge_join_threshold: 1000
        # nested_loop_join_threshold: 5
        # ordered_aggregate_threshold: 262144
        # perfect_ht_threshold: 12
        # pivot_filter_threshold: 20
        # pivot_limit: 100000
        # prefer_range_joins: false
        # late_materialization_max_rows: 50
        # max_expression_depth: 1000

        ###### DATA TYPE AND PARSING SETTINGS ######
        # old_implicit_casting: false
        # disable_timestamptz_casts: false
        # ieee_floating_point_ops: true
        # integer_division: false
        # lambda_syntax: "DEFAULT"
        # scalar_subquery_error_on_multiple_rows: true
        # zstd_min_string_length: 4096

        ###### LOGGING SETTINGS ######
        # enable_logging: true
        # enable_http_logging: true
        # logging_level: "INFO"
        # logging_mode: "LEVEL_ONLY"
        # logging_storage: "memory"

        ######  SECRET MANAGEMENT ######
        # allow_persistent_secrets: false # This doesn't work well in my testing.
        # default_secret_storage: "local_file"
        # secret_directory: "~/.duckdb/stored_secrets"

        ###### CACHING ######
        # disable_parquet_prefetching: false
        # enable_external_file_cache: true
        # parquet_metadata_cache: false
        # prefetch_all_parquet_files: false

        ###### ARROW SETTINGS ######
        # arrow_large_buffer_size: false
        # arrow_lossless_conversion: false
        # arrow_output_list_view: false
        # produce_arrow_string_view: false

        ###### PROXY/VPN SETTINGS ######
        # ca_cert_file: ""
        enable_server_cert_verification: true

        ###### HTTP SETTINGS ######
        # http_proxy_password: ""
        # http_proxy_username: ""
        # http_proxy: ""
        # http_retry_backoff: 4.0
        # http_retry_wait_ms: 100
        # force_download: false

        ###### ORDER QUERY SETTINGS ######
        # default_null_order: "NULLS_LAST"
        # default_order: "ASC"
        # default_collation: ""
        # order_by_non_integer_literal: false

        ###### EXTENSION SETTINGS ######
        # allow_community_extensions: true
        # allow_extensions_metadata_mismatch: false
        # allow_unredacted_secrets: false
        # allow_unsigned_extensions: false
        # autoinstall_extension_repository: ""
        # autoinstall_known_extensions: false
        # autoload_known_extensions: false
        # custom_extension_repository: ""
        # extension_directory: ""

        ###### STRICT PATH SETTINGS ######
        # allowed_directories: []
        # allowed_paths: []
        # file_search_path: ""
        # home_directory: ""

        ###### SCHEMA AND DATABASE SETTINGS ######
        # catalog_error_max_schemas: 100
        # schema: "main" # DO NOT TOUCH WILL CAUSE DBT TO BEHAVE IN UNEXPECTED WAYS
        # search_path: ""
        # preserve_identifier_case: true

        ###### PATH AND LOG ACCESS ######
        # disabled_compression_methods: ""
        # disabled_filesystems: ""
        # disabled_log_types: ""

        ###### FILE I/O AND STORAGE SETTINGS ######
        # default_block_size: 262144
        # partitioned_write_flush_threshold: 524288
        # partitioned_write_max_open_files: 100
        # s3_uploader_max_filesize: "800GB"
        # s3_uploader_max_parts_per_file: 10000
        # s3_uploader_thread_limit: 50
        # storage_compatibility_version: "v0.10.2"
        # temp_directory: "/curative/duckdb-dbt/duckdb_temp" # using this raises a not implemented error

        ###### GEO AND SPECIAL DATA TYPE SETTINGS ######
        # enable_geoparquet_conversion: true

        ###### DEPENDENCY AND MACRO SETTINGS ######
        # enable_macro_dependencies: false
        # enable_view_dependencies: false

        ###### PROFILING AND DEBUG SETTINGS ######
        # custom_profiling_settings: '{"ROWS_RETURNED": "true", "LATENCY": "true", "RESULT_SET_SIZE": "true", "OPERATOR_TIMING": "true", "OPERATOR_ROWS_SCANNED": "true", "CUMULATIVE_ROWS_SCANNED": "true", "OPERATOR_CARDINALITY": "true", "OPERATOR_TYPE": "true", "OPERATOR_NAME": "true", "CPU_TIME": "true", "EXTRA_INFO": "true", "SYSTEM_PEAK_BUFFER_MEMORY": "true", "BLOCKED_THREAD_TIME": "true", "CUMULATIVE_CARDINALITY": "true", "SYSTEM_PEAK_TEMP_DIR_SIZE": "true", "QUERY_NAME": "true"}'
        # enable_profiling: null # Options: JSON, QUERY_TREE, QUERY_TREE_OPTIMIZER
        # profiling_mode: null # Options: STANDARD or DETAILED
        # profile_output: ""
        # log_query_path: null
        # http_logging_output: ""

        ###### USER INTERFACE SETTINGS ######
        # enable_progress_bar_print: true
        # enable_progress_bar: true
        # progress_bar_time: 2000
        # errors_as_json: false
        # explain_output: "physical_only"

        ###### TRANSACTION AND CONCURRENCY SETTINGS ######
        # immediate_transaction_mode: false
        # preserve_insertion_order: true

        ###### INDEX AND SCAN SETTINGS ######
        # index_scan_max_count: 2048
        # index_scan_percentage: 0.001