# MV\_CLOUD\_BRANCHES

This view displays all databases and branches, and their properties.

This view is intended for internal SingleStore use. No additional information is available.

> **📝 Note**: This view is only applicable for SingleStore Helios.

| Column Name                           | Description                                                                                                                                                                                                                                                                                                                                                               |
| ------------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| ROW\_NUMBER                           | A unique identifier for this row during the scan of this table. Serves to match`PREV_ROW_NUMBER`and has no other meaning. In particular it is not stable across different scans of the table.                                                                                                                                                                             |
| STORAGE\_ID                           | Storage ID of the database branch.                                                                                                                                                                                                                                                                                                                                        |
| WORKSPACE\_GROUP\_ID                  | Workspace Group ID of the database branch.                                                                                                                                                                                                                                                                                                                                |
| DATABASE\_NAME                        | Name of the database branch (Important identifier for branches, attaching existing database as a new name will result in a different branch). This is also non-unique since there may be multiple branches of the same database.                                                                                                                                          |
| REGION                                | Name of region containing the Workspace Group of this database branch.                                                                                                                                                                                                                                                                                                    |
| LATEST\_COMPUTE\_ID                   | Compute ID for the latest compute session in this database branch.                                                                                                                                                                                                                                                                                                        |
| ATTATCH\_TYPE                         | The attach type (`create`,`PITR`,`restore`,`resume`) that led to the creation of this database branch. Note:`create`,`PITR`, and`restore`are not to be considered the final/permanent type and may change to`resume`as the life-cycle of the branch evolves. This information is subject to the retention period and may change: 1 day (Standard) or 7 days (Enterprise). |
| PREV\_ROW\_NUMBER                     | `ROW_NUMBER`of the previous database branch (source of attach) , or NULL if one does not exist. Note, this information is subject to the retention period and may change: 1 day (Standard) or 7 days (Enterprise).                                                                                                                                                        |
| PREV\_COMPUTE\_ID                     | Compute ID of the previous database, subject to retention period:1 day (Standard) or 7 days (Enterprise).                                                                                                                                                                                                                                                                 |
| PREV\_WORKSPACE\_GROUP\_ID            | Workspace Group ID of the previous database, subject to retention period: 1 day (Standard) or 7 days (Enterprise).                                                                                                                                                                                                                                                        |
| PREV\_DATABASE\_NAME                  | Name of the previous database, subject to retention period: 1 day (Standard) or 7 days (Enterprise).                                                                                                                                                                                                                                                                      |
| PREV\_REGION                          | Region of the previous database, subject to retention period: 1 day (Standard) or 7 days (Enterprise).                                                                                                                                                                                                                                                                    |
| OLDEST\_VERSION                       | The oldest PITR-able version of this database branch.                                                                                                                                                                                                                                                                                                                     |
| END\_VERSION                          | If the database branch is detached, the detach version. Otherwise`NULL`.                                                                                                                                                                                                                                                                                                  |
| LATEST\_VERSION\_LOWER\_BOUND         | The lower bound of the version that PITR-to-latest will attach to. In the event of a`FAILOVER`, this is a bound on the data which will be lost.                                                                                                                                                                                                                           |
| OLDEST\_UNIX\_TIMESTAMP               | The matching timestamp of the`OLDEST_VERSION`.                                                                                                                                                                                                                                                                                                                            |
| END\_UNIX\_TIMESTAMP                  | The matching timestamp of the`END_VERSION`.                                                                                                                                                                                                                                                                                                                               |
| LATEST\_UNIX\_TIMESTAMP\_LOWER\_BOUND | The matching timestamp of the`LATEST_VERSION_LOWER_BOUND`.                                                                                                                                                                                                                                                                                                                |
| LATEST\_ATTACH\_TIME                  | The approximate time of the latest attach to compute action(`CREATE`/`ATTACH`/`RESTORE`) of this database branch.                                                                                                                                                                                                                                                         |
| IS\_DETACHED                          | Indicates whether the database branch was safely detached from allworkspaces.                                                                                                                                                                                                                                                                                             |
| IS\_ATTACHED\_TO\_THIS\_COMPUTE       | Indicates whether the database is attached to currentworkspace.                                                                                                                                                                                                                                                                                                           |
| IS\_DROPPED                           | Indicates whether this database branch has been dropped. The branch will be cleaned up subject to retention period: 1 day (Standard) or 7 days (Enterprise).                                                                                                                                                                                                              |
| IS\_ATTACHABLE                        | Whether the current branch is attachable.                                                                                                                                                                                                                                                                                                                                 |
| ATTACH\_SYNTAX                        | Syntax used to attach this database branch to aworkspace.                                                                                                                                                                                                                                                                                                                 |
| ATTACH\_MEMO                          | Optional memo during attach. Note: Some internal functions such as`FAILOVER`/`FAILBACK`may automatically populate this field.                                                                                                                                                                                                                                             |
| BRANCH\_COMPUTE\_HISTORY              | A list of compute\_ids for compute sessions that make up this branch, starting with the earliest compute\_id and ending with the latest\_compute\_id.                                                                                                                                                                                                                     |
| ATTACH\_SOURCE\_TIME                  | The approximate time of the source data this branch is attached on. For example,`ATTACH x_db AS y_db AT TIME t1;`will display`t1`here for y\_db). This field can be NULL if the branch was created by`CREATE`, or temporarily NULL waiting for background update.This information is subject to the retention period: 3 days (Standard) or 7 days (Enterprise).           |

***

Modified at: November 18, 2024

Source: [/cloud/reference/information-schema-reference/workload-profiling/mv-cloud-branches/](https://docs.singlestore.com/cloud/reference/information-schema-reference/workload-profiling/mv-cloud-branches/)

(An index of the documentation is available at /llms.txt)