Table: aws_lightsail_disks
This table shows data for Lightsail Disks.
https://docs.aws.amazon.com/lightsail/2016-11-28/api-reference/API_Disk.html (opens in a new tab)
The primary key for this table is arn.
Relations
The following tables depend on aws_lightsail_disks:
Columns
| Name | Type |
|---|---|
| _cq_id | uuid |
| _cq_parent_id | uuid |
| account_id | utf8 |
| region | utf8 |
| arn (PK) | utf8 |
| tags | json |
| add_ons | json |
| attached_to | utf8 |
| attachment_state | utf8 |
| auto_mount_status | utf8 |
| created_at | timestamp[us, tz=UTC] |
| gb_in_use | int64 |
| iops | int64 |
| is_attached | bool |
| is_system_disk | bool |
| location | json |
| name | utf8 |
| path | utf8 |
| resource_type | utf8 |
| size_in_gb | int64 |
| state | utf8 |
| support_code | utf8 |
Example Queries
These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.
Unused Lightsail disks
SELECT
'Unused Lightsail disks' AS title,
account_id,
arn AS resource_id,
'fail' AS status
FROM
aws_lightsail_disks
WHERE
is_attached = false;