Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

azure_* session settings

These settings are available in system.settings and are autogenerated from source.

azure_allow_parallel_part_upload

Type
Bool
Default
1
Version history
VersionDefault valueComment
24.4trueUse multiple threads for azure multipart upload.

Use multiple threads for azure multipart upload.

azure_check_objects_after_upload

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.110Check each uploaded object in azure blob storage to be sure that upload was successful
24.100Check each uploaded object in azure blob storage to be sure that upload was successful

Check each uploaded object in azure blob storage to be sure that upload was successful

azure_connect_timeout_ms

Type
UInt64
Default
1000
Version history
VersionDefault valueComment
25.81000New setting

Connection timeout for host from azure disks.

azure_create_new_file_on_insert

Type
Bool
Default
0

Enables or disables creating a new file on each insert in azure engine tables

azure_ignore_file_doesnt_exist

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.60Allow to return 0 rows when the requested files don't exist instead of throwing an exception in AzureBlobStorage table engine

Ignore absence of file if it does not exist when reading certain keys.

Possible values:

  • 1 — SELECT returns empty result.
  • 0 — SELECT throws an exception.

azure_list_object_keys_size

Type
UInt64
Default
1000

Maximum number of files that could be returned in batch by ListObject request

azure_min_upload_part_size

Type
UInt64
Default
16777216
Version history
VersionDefault valueComment
24.316777216The minimum size of part to upload during multipart upload to Azure blob storage.

The minimum size of part to upload during multipart upload to Azure blob storage.

azure_request_timeout_ms

Type
UInt64
Default
30000
Version history
VersionDefault valueComment
25.830000New setting

Idleness timeout for sending and receiving data to/from azure. Fail if a single TCP read or write call blocks for this long.

azure_skip_empty_files

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.60Allow to skip empty files in azure table engine

Enables or disables skipping empty files in S3 engine.

Possible values:

  • 0 — SELECT throws an exception if empty file is not compatible with requested format.
  • 1 — SELECT returns empty result for empty file.

azure_strict_upload_part_size

Type
UInt64
Default
0
Version history
VersionDefault valueComment
24.30The exact size of part to upload during multipart upload to Azure blob storage.

The exact size of part to upload during multipart upload to Azure blob storage.

azure_throw_on_zero_files_match

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.60Allow to throw an error when ListObjects request cannot match any files in AzureBlobStorage engine instead of empty query result

Throw an error if matched zero files according to glob expansion rules.

Possible values:

  • 1 — SELECT throws an exception.
  • 0 — SELECT returns empty result.

azure_truncate_on_insert

Type
Bool
Default
0

Enables or disables truncate before insert in azure engine tables.

azure_use_adaptive_timeouts

Type
Bool
Default
1
Version history
VersionDefault valueComment
25.81New setting

When set to true than for all azure requests first two attempts are made with low send and receive timeouts. When set to false than all attempts are made with identical timeouts.

Navigation