v.1.1.54362New Feature

Added Columns to System Tables

Official CH changelog text
Added the data_path and metadata_path columns to system.tablesandsystem.databases tables, and added the path column to the system.parts and system.parts_columns tables.
Added new columns to system tables to expose the data and metadata file paths associated with tables and parts.

Why it matters

The feature provides users with direct access to the file system paths where table and part data and metadata are stored. This enhances transparency and aids in debugging, auditing, and managing ClickHouse storage.

How to use it

Query the system.tables and system.databases tables to see the data_path and metadata_path columns, and query the system.parts and system.parts_columns tables to view the path column, using standard SQL queries.
PreviousNext