# Source: https://docs.datadoghq.com/ddsql_reference/data_directory/gcp/gcp.spanner_database.dataset.md

---
title: Cloud Spanner Database
description: Datadog, the leading service for cloud-scale monitoring.
breadcrumbs: Docs > DDSQL Reference > Data Directory > Cloud Spanner Database
---

# 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

| Title                    | 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        |