> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

> System table containing information about data files stored on remote disks such as S3 or Azure Blob Storage.

# system.remote_data_paths

<h2 id="description">
  Description
</h2>

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.

<h2 id="columns">
  Columns
</h2>

* `disk_name` ([String](/reference/data-types/index)) — Disk name.
* `path` ([String](/reference/data-types/index)) — Disk path.
* `cache_base_path` ([String](/reference/data-types/index)) — Base directory of cache files.
* `local_path` ([String](/reference/data-types/index)) — Path of ClickHouse file, also used as metadata path.
* `remote_path` ([String](/reference/data-types/index)) — Blob path in object storage, with which ClickHouse file is associated with.
* `size` ([UInt64](/reference/data-types/index)) — Size of the file (compressed).
* `common_prefix_for_blobs` ([String](/reference/data-types/index)) — Common prefix for blobs in object storage.
* `cache_paths` ([Array(String)](/reference/data-types/index)) — Cache files for corresponding blob.

<h2 id="example">
  Example
</h2>

```sql theme={null}
SELECT * FROM system.remote_data_paths LIMIT 1 FORMAT Vertical;
```

```text theme={null}
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']
```

<h2 id="see-also">
  See Also
</h2>

* [Using external storage for data storage](/reference/engines/table-engines/mergetree-family/mergetree#table_engine-mergetree-s3)
* [Configuring external storage](/concepts/features/configuration/server-config/storing-data#configuring-external-storage)
* [system.disks](/reference/system-tables/disks)