Sqladmin Backup

Docs > DDSQL Reference > Data Directory > Sqladmin Backup

This table represents the sqladmin_backup resource from Google Cloud Platform.

gcp.sqladmin_backup

Fields

ID	Type	Data Type	Description
_key	core	string
ancestors	core	array<string>
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<string>
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
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
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."]