Cloud Spanner Database

Docs > DDSQL Reference > Data Directory > Cloud Spanner Database

Cloud Spanner Database is a fully managed, horizontally scalable, and strongly consistent relational database service on Google Cloud. It combines the benefits of traditional relational databases with the scalability of non-relational systems. Spanner automatically handles replication, sharding, and failover across regions, providing high availability and global consistency. It supports standard SQL queries and integrates with other GCP services for analytics and application development.

gcp.spanner_database

Fields

ID	Type	Data Type	Description
_key	core	string
ancestors	core	array<string>
create_time	core	timestamp	Output only. If exists, the time at which the database creation started.
database_dialect	core	string	Output only. The dialect of the Cloud Spanner Database.
datadog_display_name	core	string
default_leader	core	string	Output only. The read-write region which contains the database's leader replicas. This is the same as the value of default_leader database option set using DatabaseAdmin.CreateDatabase or DatabaseAdmin.UpdateDatabaseDdl. If not explicitly set, this is empty.
earliest_version_time	core	timestamp	Output only. Earliest timestamp at which older versions of the data can be read. This value is continuously updated by Cloud Spanner and becomes stale the moment it is queried. If you are using this value to recover data, make sure to account for the time from the moment when the value is queried to the moment when you initiate the recovery.
enable_drop_protection	core	bool	Optional. Whether drop protection is enabled for this database. Defaults to false, if not set. For more details, please see how to [prevent accidental database deletion](https://cloud.google.com/spanner/docs/prevent-database-deletion).
encryption_config	core	json	Output only. For databases that are using customer managed encryption, this field contains the encryption configuration for the database. For databases that are using Google default or other types of encryption, this field is empty.
encryption_info	core	json	Output only. For databases that are using customer managed encryption, this field contains the encryption information for the database, such as all Cloud KMS key versions that are in use. The `encryption_status` field inside of each `EncryptionInfo` is not populated. For databases that are using Google default or other types of encryption, this field is empty. This field is propagated lazily from the backend. There might be a delay from when a key version is being used and when it appears in this field.
labels	core	array<string>
name	core	string	Required. The name of the database. Values are of the form `projects//instances//databases/`, where `` is as specified in the `CREATE DATABASE` statement. This name can be passed to other API methods to identify the database.
organization_id	core	string
parent	core	string
project_id	core	string
project_number	core	string
quorum_info	core	json	Output only. Applicable only for databases that use dual-region instance configurations. Contains information about the quorum.
reconciling	core	bool	Output only. If true, the database is being updated. If false, there are no ongoing update operations for the database.
region_id	core	string
resource_name	core	string
restore_info	core	json	Output only. Applicable only for restored databases. Contains information about the restore source.
state	core	string	Output only. The current database state.
tags	core	hstore_csv
version_retention_period	core	string	Output only. The period in which Cloud Spanner retains all versions of data for the database. This is the same as the value of version_retention_period database option set using UpdateDatabaseDdl. Defaults to 1 hour, if not set.
zone_id	core	string