You need to enable JavaScript to run this app.
ByteHouse Cloud Data Warehouse Version

ByteHouse Cloud Data Warehouse Version

  • Documentation
    • ByteHouse Cloud Data Warehouse VersionDevelopment referenceSQL referenceSystem tablessystem.databases
Copy page
Download PDF
System tables
system.databases
Copy page
Download PDF
system.databases

The system table system.databases contains information about all databases in the current environment, including the database name, engine, storage path, unique identifier, and others. It can be used for quickly viewing the database list and core attributes.

Column names

| | | | \

NameData typeDescription
\
nameStringThe name of the database.
\
engineStringThe engine of the database. Fixed as "Cnch".
\
data_pathStringThe storage path of the database data in the file system.
\
metadata_pathStringThe path of the metadata, which is empty.
\
uuidUUIDThe unique UUID identifier of the database.

Example

Query databases in the current environment whose name contains demo:

SELECT 
  name AS database_name, 
  engine, 
  data_path 
FROM system.databases 
WHERE name LIKE 'demo' 
ORDER BY name 
LIMIT 10;

Example of query results:
Image

Last updated: 2026.03.31 16:16:45