Table: linode_image - Query Linode Images using SQL

Linode Images allows users to capture and deploy disk images. These images can be used to create Linode instances or to resize existing Linodes. Linode Images are a great way to back up your data or to create templates for regularly-used configurations.

Table Usage Guide

The linode_image table provides insights into custom images within Linode. As a DevOps engineer, explore image-specific details through this table, including labels, descriptions, and associated metadata. Utilize it to uncover information about images, such as their creation date, size, type, and whether they are public or private.

Examples

All images

Explore all available system images on your Linode account. This is useful to manage and keep track of the different operating systems and configurations you have available for deployment.

select
  *
from
  linode_image;

select
  *
from
  linode_image;

Ubuntu images

Explore which Linode images are related to Ubuntu. This query is useful for identifying all Ubuntu-related images in your Linode environment, helping you manage your resources more effectively.

select
  *
from
  linode_image
where
  id like '%ubuntu%';

select
  *
from
  linode_image
where
  id like '%ubuntu%';

Image information for each instances

Gain insights into the specific image details associated with each instance, enabling you to understand the underlying configurations. This is useful for ensuring that instances are running on the correct images, thereby improving system consistency and reliability.

select
  i.label as instance_label,
  im.*
from
  linode_instance as i,
  linode_image as im
where
  i.image = im.id;

select
  i.label as instance_label,
  im.*
from
  linode_instance as i
  join linode_image as im on i.image = im.id;

Schema for linode_image

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created	timestamp with time zone		When this Image was created.
created_by	text		The name of the User who created this Image, or 'linode' for official Images.
deprecated	boolean	=	Whether or not this Image is deprecated. Will only be true for deprecated public Images.
description	text		A detailed description of this Image.
expiry	timestamp with time zone		Only Images created automatically (from a deleted Linode; type=automatic) will expire.
filter	text	=	Raw Linode list filter string in JSON format.
id	text	=	The unique ID of this Image.
image_type	text	=	How the Image was created: manual, automatic.
is_public	boolean	=	True if the Image is public.
label	text	=	A short description of the Image.
size	bigint	=	The minimum size this Image needs to deploy. Size is in MB.
vendor	text		The upstream distribution vendor. None for private Images.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- linode

You can pass the configuration to the command with the --config argument:

steampipe_export_linode --config '<your_config>' linode_image