Skip to main content
Skip to main content
Edit this page

system.remote_data_paths

Description​

Contains information about data files stored on remote disks (e.g. S3, Azure Blob Storage), including the mapping between local metadata paths and remote blob paths.

Each row represents one remote blob object associated with a data file.

Columns​

  • disk_name (String) — Disk name.
  • path (String) — Disk path.
  • 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.

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​