system.remote_data_paths

​

Description

​

Columns

• disk_name (String) — Disk name.
• path (String) — Disk path.
• metadata_type (String) — Metadata storage type of the disk (e.g. Local, PlainRewritable).
• cache_base_path (String) — Base directory of cache files.
• local_path (String) — Path of ClickHouse file, also used as metadata path.
• remote_path (String) — Blob path in object storage, with which ClickHouse file is associated with.
• size (UInt64) — Size of the file (compressed).
• common_prefix_for_blobs (String) — Common prefix for blobs in object storage.
• cache_paths (Array(String)) — Cache files for corresponding blob.
• last_modified (DateTime) — Last modification time of the file’s metadata. Zero for a metadata storage that records none.

​

Example

SELECT * FROM system.remote_data_paths LIMIT 1 FORMAT Vertical;

Row 1:
──────
disk_name:              s3
path:                   /var/lib/clickhouse/disks/s3/
cache_base_path:        /var/lib/clickhouse/disks/s3_cache/
local_path:             store/123/1234abcd-1234-1234-1234-1234abcd1234/all_0_0_0/data.bin
remote_path:            abc123/all_0_0_0/data.bin
size:                   1048576
common_prefix_for_blobs:
cache_paths:            ['/var/lib/clickhouse/disks/s3_cache/a1/b2/c3d4e5f6']

​

See Also

• Using external storage for data storage
• Configuring external storage
• system.disks