alicloud_accountalicloud_action_trailalicloud_cas_certificatealicloud_cms_monitor_hostalicloud_cs_kubernetes_clusteralicloud_cs_kubernetes_cluster_nodealicloud_ecs_auto_provisioning_groupalicloud_ecs_autoscaling_groupalicloud_ecs_diskalicloud_ecs_disk_metric_read_iopsalicloud_ecs_disk_metric_read_iops_dailyalicloud_ecs_disk_metric_read_iops_hourlyalicloud_ecs_disk_metric_write_iopsalicloud_ecs_disk_metric_write_iops_dailyalicloud_ecs_disk_metric_write_iops_hourlyalicloud_ecs_imagealicloud_ecs_instancealicloud_ecs_instance_metric_cpu_utilization_dailyalicloud_ecs_instance_metric_cpu_utilization_hourlyalicloud_ecs_key_pairalicloud_ecs_launch_templatealicloud_ecs_network_interfacealicloud_ecs_regionalicloud_ecs_security_groupalicloud_ecs_snapshotalicloud_ecs_zonealicloud_kms_keyalicloud_kms_secretalicloud_oss_bucketalicloud_ram_access_keyalicloud_ram_credential_reportalicloud_ram_groupalicloud_ram_password_policyalicloud_ram_policyalicloud_ram_rolealicloud_ram_security_preferencealicloud_ram_useralicloud_rds_backupalicloud_rds_databasealicloud_rds_instancealicloud_rds_instance_metric_connectionsalicloud_rds_instance_metric_connections_dailyalicloud_rds_instance_metric_cpu_utilizationalicloud_rds_instance_metric_cpu_utilization_dailyalicloud_rds_instance_metric_cpu_utilization_hourlyalicloud_security_center_field_statisticsalicloud_security_center_versionalicloud_slb_load_balanceralicloud_vpcalicloud_vpc_dhcp_options_setalicloud_vpc_eipalicloud_vpc_flow_logalicloud_vpc_nat_gatewayalicloud_vpc_network_aclalicloud_vpc_route_entryalicloud_vpc_route_tablealicloud_vpc_ssl_vpn_client_certalicloud_vpc_ssl_vpn_serveralicloud_vpc_vpn_connectionalicloud_vpc_vpn_customer_gatewayalicloud_vpc_vpn_gatewayalicloud_vpc_vswitch
Table: alicloud_rds_backup
ApsaraDB RDS Backup is a policy expression that defines when and how you want to back up your DB Instances.
Examples
Basic info
select backup_id, db_instance_id, backup_status, backup_mode, backup_size, backup_start_timefrom alicloud_rds_backup;
Count backup by instance
select db_instance_id, count(backup_id) as backup_countfrom alicloud_rds_backupgroup by db_instance_id;
List manual backups
select backup_id, db_instance_id, backup_status, backup_mode, backup_size, backup_start_timefrom alicloud_rds_backupwhere backup_mode = 'Manual';
List backups of type incremental
select backup_id, db_instance_id, backup_status, backup_type, backup_size, backup_start_time, backup_end_timefrom alicloud_rds_backupwhere backup_type = 'IncrementalBackup';
List backups by location
select backup_id, db_instance_id, backup_status, backup_type, backup_size, backup_start_time, backup_end_time, backup_locationfrom alicloud_rds_backupwhere backup_location = 'OSS';
List backups that were created in the last 30 days
select backup_id, db_instance_id, backup_status, backup_type, backup_size, backup_start_time, backup_end_time, backup_locationfrom alicloud_rds_backupwhere backup_end_time >= now() - interval '30' day;
Query examples
.inspect alicloud_rds_backup
ApsaraDB RDS Backup is a policy expression that defines when and how you want to back up your DB Instances.
Name | Type | Description |
---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. |
account_id | text | The Alicloud Account ID in which the resource is located. |
backup_db_names | text | The name of the database that has been backed up. |
backup_download_url | text | The internet download URL of the backup set. If the download URL is unavailable, this parameter is an empty string. |
backup_end_time | timestamp with time zone | The end of the backup time range. The time is in the yyyy-MM-ddTHH:mm:ssZ format and displayed in UTC. |
backup_extraction_status | text | The backup extraction status. |
backup_id | text | The ID of the backup set. |
backup_initiator | text | The initiator of the backup task. |
backup_intranet_download_url | text | The internal download URL of the backup set. |
backup_location | text | The location where backup is available. |
backup_method | text | The backup method. Valid values: Snapshot, Physical and Logical. |
backup_mode | text | The backup mode. |
backup_size | bigint | The size of the backup set. Unit: bytes. |
backup_start_time | timestamp with time zone | The beginning of the backup time range. The time is in the yyyy-MM-ddTHH:mm:ssZ format and displayed in UTC. |
backup_status | text | The status of the backup. Valid values: Success, Failed. |
backup_type | text | The backup type. |
consistent_time | timestamp with time zone | The point in time at which the data in the data backup is consistent. |
copy_only_backup | text | The backup mode of the data backup. Valid values: 0, 1. |
db_instance_id | text | The ID of the single instance to query. |
encryption | text | The encryption information of the data backup. |
host_instance_id | text | The number of the instance that generates the data backup. This parameter is used to indicate whether the instance that generates the data backup file is a primary instance or a secondary instance. |
is_avail | text | Indicates whether the data backup is available. Valid values: 0, 1. |
meta_status | text | The status of the data backup file that is used to restore individual databases or tables. |
slave_status | text | The slave status of the backup. |
storage_class | text | The storage class of the data backup. Valid values: 0(regular storage), 1 (archive storage). |
store_status | text | Indicates whether the data backup can be deleted. Valid values: Enabled, Disabled. |
title | text | Title of the resource. |
total_backup_size | text | The total backup size. |