MV_ CLOUD_ BRANCHES
This view displays all databases and branches, and their properties.
This view is intended for internal SingleStore use.
Note
This view is only applicable for SingleStore Helios.
Column Name |
Description |
---|---|
ROW_ |
A unique identifier for this row during the scan of this table. |
STORAGE_ |
Storage ID of the database branch. |
WORKSPACE_ |
Workspace Group ID of the database branch. |
DATABASE_ |
Name of the database branch (Important identifier for branches, attaching existing database as a new name will result in a different branch). |
REGION |
Name of region containing the Workspace Group of this database branch. |
LATEST_ |
Compute ID for the latest compute session in this database branch. |
ATTATCH_ |
The attach type ( |
PREV_ |
|
PREV_ |
Compute ID of the previous database, subject to retention period:1 day (Standard) or 7 days (Premium). |
PREV_ |
Workspace Group ID of the previous database, subject to retention period: 1 day (Standard) or 7 days (Premium). |
PREV_ |
Name of the previous database, subject to retention period: 1 day (Standard) or 7 days (Premium). |
PREV_ |
Region of the previous database, subject to retention period: 1 day (Standard) or 7 days (Premium). |
OLDEST_ |
The oldest PITR-able version of this database branch. |
END_ |
If the database branch is detached, the detach version. |
LATEST_ |
The lower bound of the version that PITR-to-latest will attach to. |
OLDEST_ |
The matching timestamp of the |
END_ |
The matching timestamp of the |
LATEST_ |
The matching timestamp of the |
LATEST_ |
The approximate time of the latest attach to compute action( |
IS_ |
Indicates whether the database branch was safely detached from all workspaces. |
IS_ |
Indicates whether the database is attached to current workspace. |
IS_ |
Indicates whether this database branch has been dropped. |
IS_ |
Whether the current branch is attachable. |
ATTACH_ |
Syntax used to attach this database branch to a workspace. |
ATTACH_ |
Optional memo during attach. |
BRANCH_ |
A list of compute_ |
ATTACH_ |
The approximate time of the source data this branch is attached on. This information is subject to the retention period: 3 days (Standard) or 7 days (Premium). |
Last modified: May 17, 2024