Table: alicloud_ecs_snapshot

The Alibaba Cloud snapshot service allows you to create crash-consistent snapshots for all disk categories. Crash-consistent snapshots are an effective solution to disaster recovery and are used to back up data, create custom images, and implement disaster recovery for applications.

Examples

List of snapshots which are not encrypted

select
  name,
  snapshot_id,
  arn,
  encrypted
from
  alicloud_ecs_snapshot
where
  not encrypted;

List of unused snapshots

select
  name,
  snapshot_id,
  type
from
  alicloud_ecs_snapshot
where
  usage = 'none';

Find the snapshot count per disk

select
  source_disk_id,
  count(*) as snapshot
from
  alicloud_ecs_snapshot
group by
  source_disk_id;

List of snapshots without owner tag key

select
  name,
  snapshot_id,
  tags
from
  alicloud_ecs_snapshot
where
  tags ->> 'owner' is null;

List of snapshots older than 90 days

select
  name,
  snapshot_id,
  type,
  creation_time,
  age(creation_time),
  retention_days
from
  alicloud_ecs_snapshot
where
  creation_time <= (current_date - interval '90' day)
order by
  creation_time;

Query examples

Control examples

.inspect alicloud_ecs_snapshot

ECS Disk Snapshot.

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.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
arn	text	The Alibaba Cloud Resource Name (ARN) of the snapshot.
creation_time	timestamp with time zone	The time when the snapshot was created.
description	text	A user provided, human readable description for this resource.
encrypted	boolean	Indicates whether the snapshot was encrypted.
instant_access	boolean	Indicates whether the instant access feature is enabled.
instant_access_retention_days	bigint	Indicates the retention period of the instant access feature. After the retention per iod ends, the snapshot is automatically released.
kms_key_id	text	The ID of the KMS key used by the data disk.
last_modified_time	timestamp with time zone	The time when the snapshot was last changed.
name	text	A friendly name for the resource.
product_code	text	The product code of the Alibaba Cloud Marketplace image.
progress	text	The progress of the snapshot creation task. Unit: percent (%).
region	text	The region ID where the resource is located.
remain_time	bigint	The remaining time required to create the snapshot (in seconds).
resource_group_id	text	The ID of the resource group to which the snapshot belongs.
retention_days	bigint	The number of days that an automatic snapshot can be retained.
serial_number	text	The serial number of the snapshot.
snapshot_id	text	An unique identifier for the resource.
source_disk_id	text	The ID of the source disk. This parameter is retained even after the source disk of the snapshot is released.
source_disk_size	text	The capacity of the source disk (in GiB).
source_disk_type	text	The category of the source disk.
status	text	Specifies the current state of the resource.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags attached with the resource.
title	text	Title of the resource.
type	text	The type of the snapshot. Default value: all. Possible values are: auto, user, and all.
usage	text	Indicates whether the snapshot has been used to create images or disks.

turbot/alicloud