turbot/digitalocean

steampipe plugin install digitaloceansteampipe plugin install digitalocean

Table: digitalocean_image

A DigitalOcean image can be used to create a Droplet and may come in a number of flavors. Currently, there are five types of images: snapshots, backups, applications, distributions, and custom images.

Examples

List all images

select
*
from
digitalocean_image;

List custom images

select
slug,
distribution,
error_message
from
digitalocean_image
where
not public;

Get Image by ID

select
id,
slug,
name,
distribution
from
digitalocean_image
where
id = 29280599;

Get Image by Slug

select
id,
slug,
name,
distribution
from
digitalocean_image
where
id = 'freebsd-11-x64-zfs';

Public images by distribution

select
distribution,
count(id)
from
digitalocean_image
group by
distribution
order by
count desc;

List all backups

select
name,
size_gigabytes,
type
from
digitalocean_image
where
type = 'backup';

.inspect digitalocean_image

A DigitalOcean image can be used to create a Droplet and may come in a number of flavors. Currently, there are five types of images: snapshots, backups, applications, distributions, and custom images.

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
created_attimestamp without time zoneTime when the image was created.
descriptiontextAn optional free-form text field to describe an image.
distributiontextThis attribute describes the base distribution used for this image. For custom images, this is user defined.
error_messagetextA string containing information about errors that may occur when importing a custom image.
idbigintA unique number that can be used to identify and reference a specific image.
min_disk_sizebigintThe minimum disk size in GB required for a Droplet to use this image.
nametextThe display name that has been given to an image. This is what is shown in the control panel and is generally a descriptive title for the image in question.
publicbooleanThis is a boolean value that indicates whether the image in question is public or not. An image that is public is available to all accounts. A non-public image is only accessible from your account.
regionsjsonbArray of region slugs where the image is available.
size_gigabytesbigintThe size of the image in gigabytes.
slugtextA uniquely identifying string that is associated with each of the DigitalOcean-provided public images. These can be used to reference a public image as an alternative to the numeric id.
statustextA status string indicating the state of a custom image. This may be "NEW", "available", "pending", or "deleted".
tagsjsonbA map of tags for the resource.
tags_srcjsonbAn array containing the names of the tags the image has been tagged with.
titletextTitle of the resource.
typetextDescribes the kind of image. It may be one of "snapshot", "backup", or "custom".
urntextThe uniform resource name (URN) for the volume.