DISTRIBUTED_DATABASES

This view contains information about databases.

Column Name

Description

DATABASE_ID

The unique ID of a given database.

DATABASE_NAME

The name of a given database.

NUM_PARTITIONS

The number of a partitions in a given database.

NUM_SUB_PARTITIONS

The number of sub-partitions in a given database.

CLUSTER_ID

The ID of the related workspace for a given database.

REMOTE_NAME

The remote name of a given database.

IS_SYNC

Determines if the database uses synchronous replication for high availability.

IS_SYNC_DURABILITY

Determines if the database uses synchronous durability.

IS_PAUSED

Whether DR replication of a given database is paused.

SITE_ID

The ID for the workspace.

IS_SYNC_DURABILITY_ON_REF_DB_ONLY

Indicates whether the reference database is sync durable despite the partition databases being async durable.

STORAGE_ID

Storage ID of the database.

SAFE_TS

The lower bound of the pre-prepare timestamps of any unresolved 2PC their participants (reference and partition databases) participate or will participate in.

Last modified: June 5, 2023

Was this article helpful?