turbot/alicloud

GitHub
steampipe plugin install alicloudsteampipe plugin install alicloud
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_time
from
alicloud_rds_backup;

Count backup by instance

select
db_instance_id,
count(backup_id) as backup_count
from
alicloud_rds_backup
group by
db_instance_id;

List manual backups

select
backup_id,
db_instance_id,
backup_status,
backup_mode,
backup_size,
backup_start_time
from
alicloud_rds_backup
where
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_time
from
alicloud_rds_backup
where
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_location
from
alicloud_rds_backup
where
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_location
from
alicloud_rds_backup
where
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.

NameTypeDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe Alicloud Account ID in which the resource is located.
backup_db_namestextThe name of the database that has been backed up.
backup_download_urltextThe internet download URL of the backup set. If the download URL is unavailable, this parameter is an empty string.
backup_end_timetimestamp with time zoneThe end of the backup time range. The time is in the yyyy-MM-ddTHH:mm:ssZ format and displayed in UTC.
backup_extraction_statustextThe backup extraction status.
backup_idtextThe ID of the backup set.
backup_initiatortextThe initiator of the backup task.
backup_intranet_download_urltextThe internal download URL of the backup set.
backup_locationtextThe location where backup is available.
backup_methodtextThe backup method. Valid values: Snapshot, Physical and Logical.
backup_modetextThe backup mode.
backup_sizebigintThe size of the backup set. Unit: bytes.
backup_start_timetimestamp with time zoneThe beginning of the backup time range. The time is in the yyyy-MM-ddTHH:mm:ssZ format and displayed in UTC.
backup_statustextThe status of the backup. Valid values: Success, Failed.
backup_typetextThe backup type.
consistent_timetimestamp with time zoneThe point in time at which the data in the data backup is consistent.
copy_only_backuptextThe backup mode of the data backup. Valid values: 0, 1.
db_instance_idtextThe ID of the single instance to query.
encryptiontextThe encryption information of the data backup.
host_instance_idtextThe 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_availtextIndicates whether the data backup is available. Valid values: 0, 1.
meta_statustextThe status of the data backup file that is used to restore individual databases or tables.
slave_statustextThe slave status of the backup.
storage_classtextThe storage class of the data backup. Valid values: 0(regular storage), 1 (archive storage).
store_statustextIndicates whether the data backup can be deleted. Valid values: Enabled, Disabled.
titletextTitle of the resource.
total_backup_sizetextThe total backup size.