SHOW REPOSITORIES

Description

This statement is used to view the currently created warehouse

Syntax

SHOW REPOSITORIES;

Return Value

Field	Description
RepoId	The unique identifier (ID) of the repository
RepoName	The name of the repository
CreateTime	The creation time of the repository
IsReadOnly	Whether the repository is read-only. false means not read-only, true means read-only
Location	The root directory used for backing up data in the repository
Broker	-
Type	The repository type, currently supporting S3 and HDFS
ErrMsg	The error message of the repository. Typically NULL if no error occurs

Examples

View the created repository:

SHOW REPOSITORIES;

+--------+--------------+---------------------+------------+----------+--------+------+--------+
| RepoId | RepoName     | CreateTime          | IsReadOnly | Location | Broker | Type | ErrMsg |
+--------+--------------+---------------------+------------+----------+--------+------+--------+
| 43411  | example_repo | 2025-01-17 18:50:47 | false      | s3://rep1  | -      | S3   | NULL   |
+--------+--------------+---------------------+------------+----------+--------+------+--------+