Skip to content
ClickHouse Docs
49.6kGet Started

remote_data_paths

View as MarkdownEdit this pageReport an issueSet up docs MCP

Autogenerated from ClickHouse system tables

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.
  • 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.

Examples

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

Navigation