--- title: Sqladmin Backup description: Datadog, the leading service for cloud-scale monitoring. breadcrumbs: Docs > DDSQL Reference > Data Directory > Sqladmin Backup --- # Sqladmin Backup This table represents the sqladmin_backup resource from Google Cloud Platform. ``` gcp.sqladmin_backup ``` ## Fields | Title | ID | Type | Data Type | Description | | ---------------------- | ---- | ------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------- | | _key | core | string | | ancestors | core | array | | backup_interval | core | json | Output only. This output contains the following values: start_time: All database writes up to this time are available. end_time: Any database writes after this time aren't available. | | backup_kind | core | string | Output only. Specifies the kind of backup, PHYSICAL or DEFAULT_SNAPSHOT. Possible values: ['SQL_BACKUP_KIND_UNSPECIFIED', 'SNAPSHOT', 'PHYSICAL']. Values descriptions: ['This is an unknown BackupKind.', 'Snapshot-based backups.', 'Physical backups.'] | | backup_run | core | string | Output only. The mapping to backup run resource used for IAM validations. | | database_version | core | string | Output only. The database version of the instance of at the time this backup was made. Possible values: ['SQL_DATABASE_VERSION_UNSPECIFIED', 'MYSQL_5_1', 'MYSQL_5_5', 'MYSQL_5_6', 'MYSQL_5_7', 'MYSQL_8_0', 'MYSQL_8_0_18', 'MYSQL_8_0_26', 'MYSQL_8_0_27', 'MYSQL_8_0_28', 'MYSQL_8_0_29', 'MYSQL_8_0_30', 'MYSQL_8_0_31', 'MYSQL_8_0_32', 'MYSQL_8_0_33', 'MYSQL_8_0_34', 'MYSQL_8_0_35', 'MYSQL_8_0_36', 'MYSQL_8_0_37', 'MYSQL_8_0_39', 'MYSQL_8_0_40', 'MYSQL_8_0_41', 'MYSQL_8_0_42', 'MYSQL_8_0_43', 'MYSQL_8_0_44', 'MYSQL_8_0_45', 'MYSQL_8_0_46', 'MYSQL_8_4', 'SQLSERVER_2017_STANDARD', 'SQLSERVER_2017_ENTERPRISE', 'SQLSERVER_2017_EXPRESS', 'SQLSERVER_2017_WEB', 'POSTGRES_9_6', 'POSTGRES_10', 'POSTGRES_11', 'POSTGRES_12', 'POSTGRES_13', 'POSTGRES_14', 'POSTGRES_15', 'POSTGRES_16', 'POSTGRES_17', 'SQLSERVER_2019_STANDARD', 'SQLSERVER_2019_ENTERPRISE', 'SQLSERVER_2019_EXPRESS', 'SQLSERVER_2019_WEB', 'SQLSERVER_2022_STANDARD', 'SQLSERVER_2022_ENTERPRISE', 'SQLSERVER_2022_EXPRESS', 'SQLSERVER_2022_WEB']. Values descriptions: ['This is an unknown database version.', 'The database version is MySQL 5.1.', 'The database version is MySQL 5.5.', 'The database version is MySQL 5.6.', 'The database version is MySQL 5.7.', 'The database version is MySQL 8.', 'The database major version is MySQL 8.0 and the minor version is 18.', 'The database major version is MySQL 8.0 and the minor version is 26.', 'The database major version is MySQL 8.0 and the minor version is 27.', 'The database major version is MySQL 8.0 and the minor version is 28.', 'The database major version is MySQL 8.0 and the minor version is 29.', 'The database major version is MySQL 8.0 and the minor version is 30.', 'The database major version is MySQL 8.0 and the minor version is 31.', 'The database major version is MySQL 8.0 and the minor version is 32.', 'The database major version is MySQL 8.0 and the minor version is 33.', 'The database major version is MySQL 8.0 and the minor version is 34.', 'The database major version is MySQL 8.0 and the minor version is 35.', 'The database major version is MySQL 8.0 and the minor version is 36.', 'The database major version is MySQL 8.0 and the minor version is 37.', 'The database major version is MySQL 8.0 and the minor version is 39.', 'The database major version is MySQL 8.0 and the minor version is 40.', 'The database major version is MySQL 8.0 and the minor version is 41.', 'The database major version is MySQL 8.0 and the minor version is 42.', 'The database major version is MySQL 8.0 and the minor version is 43.', 'The database major version is MySQL 8.0 and the minor version is 44.', 'The database major version is MySQL 8.0 and the minor version is 45.', 'The database major version is MySQL 8.0 and the minor version is 46.', 'The database version is MySQL 8.4.', 'The database version is SQL Server 2017 Standard.', 'The database version is SQL Server 2017 Enterprise.', 'The database version is SQL Server 2017 Express.', 'The database version is SQL Server 2017 Web.', 'The database version is PostgreSQL 9.6.', 'The database version is PostgreSQL 10.', 'The database version is PostgreSQL 11.', 'The database version is PostgreSQL 12.', 'The database version is PostgreSQL 13.', 'The database version is PostgreSQL 14.', 'The database version is PostgreSQL 15.', 'The database version is PostgreSQL 16.', 'The database version is PostgreSQL 17.', 'The database version is SQL Server 2019 Standard.', 'The database version is SQL Server 2019 Enterprise.', 'The database version is SQL Server 2019 Express.', 'The database version is SQL Server 2019 Web.', 'The database version is SQL Server 2022 Standard.', 'The database version is SQL Server 2022 Enterprise.', 'The database version is SQL Server 2022 Express.', 'The database version is SQL Server 2022 Web.'] | | datadog_display_name | core | string | | description | core | string | The description of this backup. | | error | core | json | Output only. Information about why the backup operation fails (for example, when the backup state fails). | | expiry_time | core | timestamp | Backup expiration time. A UTC timestamp of when this resource expired. | | instance | core | string | The name of the database instance. | | instance_deletion_time | core | timestamp | Optional. Output only. Timestamp in UTC of when the instance associated with this backup is deleted. | | instance_settings | core | json | Optional. Output only. Instance setting of the source instance that's associated with this backup. | | kind | core | string | Output only. This is always `sql#backup`. | | kms_key_version | core | string | Output only. This output contains the encryption status for a backup and the version of the KMS key that's used to encrypt the Cloud SQL instance. | | labels | core | array | | location | core | string | The storage location of the backups. The location can be multi-regional. | | max_chargeable_bytes | core | int64 | Output only. The maximum chargeable bytes for the backup. | | name | core | string | Output only. The resource name of the backup. Format: projects/{project}/backups/{backup}. | | organization_id | core | string | | parent | core | string | | project_id | core | string | | project_number | core | string | | region_id | core | string | | resource_name | core | string | | satisfies_pzi | core | bool | Output only. This status indicates whether the backup satisfies PZI. The status is reserved for future use. | | satisfies_pzs | core | bool | Output only. This status indicates whether the backup satisfies PZS. The status is reserved for future use. | | self_link | core | string | Output only. The URI of this resource. | | state | core | string | Output only. The state of this backup. Possible values: ['SQL_BACKUP_STATE_UNSPECIFIED', 'ENQUEUED', 'RUNNING', 'FAILED', 'SUCCESSFUL', 'DELETING', 'DELETION_FAILED']. Values descriptions: ['The state of the backup is unknown.', "The backup that's added to a queue.", 'The backup is in progress.', 'The backup failed.', 'The backup is successful.', 'The backup is being deleted.', 'Deletion of the backup failed.'] | | tags | core | hstore_csv | | time_zone | core | string | Output only. This output contains a backup time zone. If a Cloud SQL for SQL Server instance has a different time zone from the backup's time zone, then the restore to the instance doesn't happen. | | ttl_days | core | int64 | Input only. The time-to-live (TTL) interval for this resource (in days). For example: ttlDays:7, means 7 days from the current time. The expiration time can't exceed 365 days from the time that the backup is created. | | type | core | string | Output only. The type of this backup. The type can be "AUTOMATED", "ON_DEMAND", or "FINAL". Possible values: ['SQL_BACKUP_TYPE_UNSPECIFIED', 'AUTOMATED', 'ON_DEMAND', 'FINAL']. Values descriptions: ['This is an unknown backup type.', 'The backup schedule triggers a backup automatically.', 'The user triggers a backup manually.', "The backup that's created when the instance is deleted."] | | zone_id | core | string |