Skip to main content
Skip to main content
Edit this page

system.remote_data_paths

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) — Name of the remote disk as defined in the storage configuration.
  • path (String) — Root path of the remote disk as configured in storage configuration.
  • cache_base_path (String) — Base directory for cache files associated with the remote disk.
  • local_path (String) — Local metadata file path relative to the ClickHouse data directory, pointing to the file that maps to the remote blob.
  • remote_path (String) — Blob path in the remote object storage that the local metadata file maps to.
  • size (UInt64) — Compressed size of the file in bytes.
  • common_prefix_for_blobs (String) — Common prefix for blobs in the remote object storage, applicable when multiple blobs share a path prefix.
  • cache_paths (Array(String)) — Local cache file paths corresponding to the remote blob.

Settings

  • traverse_shadow_remote_data_paths — When enabled, the table also includes data from frozen partitions (the shadow/ directory used by ALTER TABLE ... FREEZE). Disabled by default.

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