Table: openstack_snapshot

A snapshot is the backup of a volume.

Examples

Basic snapshot info

select
  id,
  name,
  description,
  created_at,
  updated_at,
  volume_id,
  status,
  size
from
  openstack_snapshot;

Snapshot by ID

select
  id,
  name,
  description,
  created_at,
  updated_at,
  volume_id,
  status,
  size
from
  openstack_snapshot
where
  id = '91f4432d-5da5-475d-84b9-c68789dddb70';

All snapshots bigger than 1 GB

select
  id,
  name,
  description,
  created_at,
  updated_at,
  volume_id,
  status,
  size
from
  openstack_snapshot
where
  size > 1;

All available snapshots

select
  id,
  name,
  description,
  created_at,
  updated_at,
  volume_id,
  status,
  size
from
  openstack_snapshot
where
  status = 'available';

All snapshots not updated in the last 14 days

select
  id,
  name,
  description,
  created_at,
  updated_at,
  volume_id,
  status,
  size
from
  openstack_snapshot
where
  date_part(
    'day',
    current_date :: timestamp - updated_at :: timestamp
  ) >= 14;

Schema for openstack_snapshot

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		The date when this snapshot was last updated.
description	text		Human-readable description for the snapshot.
id	text	=	Unique identifier.
metadata	text		User-defined key-value pairs.
name	text		Human-readable display name for the snapshot.
size	bigint		Size of the snapshot in GB.
status	text		Current status of the snapshot.
updated_at	timestamp with time zone		The date when this snapshot was created.
volume_id	text		ID of the Volume from which this Snapshot was created.