Control: Old snapshots should be deleted if not required
Description
Old snapshots are likely unneeded and costly to maintain.
Usage
Run the control in your terminal:
powerpipe control run gcp_thrifty.control.compute_snapshot_max_age
Snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe control run gcp_thrifty.control.compute_snapshot_max_age --share
Steampipe Tables
Params
Args | Name | Default | Description | Variable |
---|---|---|---|---|
$1 | compute_snapshot_age_max_days |
| The maximum number of days snapshots can be retained. |
SQL
select self_link as resource, case when date_part('day', now()-creation_timestamp) > $1 then 'alarm' else 'ok' end as status, name || ' created on ' || creation_timestamp || ' (' || date_part('day', now()-creation_timestamp) || ' days).' as reason , location, projectfrom gcp_compute_snapshot;