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.

Was this article helpful?