Table: scaleway_instance_image - Query Scaleway Instance Images using SQL

Scaleway Instance Images are pre-configured operating system environments that can be used as a base to create new instances in Scaleway's cloud computing service. These images include a variety of Linux distributions, developer tools, and container technologies. They allow users to quickly launch and scale applications in the cloud.

Table Usage Guide

The scaleway_instance_image table provides insights into Instance Images within Scaleway's cloud computing service. As a cloud architect or developer, explore image-specific details through this table, including their IDs, names, and the architectures they support. Utilize it to uncover information about images, such as their creation dates, modification dates, and the public visibility status.

Examples

Basic info

Explore the details of your Scaleway instances, such as their names, IDs, states, creation dates, and associated projects and organizations. This helps you to effectively manage and monitor your Scaleway resources.

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_image;

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_image;

List custom (user-defined) images

Discover the segments that are utilizing custom images in your cloud infrastructure. This can assist in identifying areas for optimization and potential security risks.

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_image
where
  not public;

select
  name,
  id,
  state,
  creation_date,
  zone,
  project,
  organization
from
  scaleway_instance_image
where
  public = 0;

List images older than 90 days

Determine the areas in which images from Scaleway instances have been stored for more than 90 days. This can be useful in identifying outdated or potentially unnecessary data, enabling more efficient resource management and cost savings.

select
  name,
  id,
  state,
  extract(
    day
    from
      current_timestamp - creation_date
  ) as age,
  zone,
  project,
  organization
from
  scaleway_instance_image
where
  extract(
    day
    from
      current_timestamp - creation_date
  ) > 90;

select
  name,
  id,
  state,
  julianday('now') - julianday(creation_date) as age,
  zone,
  project,
  organization
from
  scaleway_instance_image
where
  julianday('now') - julianday(creation_date) > 90;

Schema for scaleway_instance_image

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
arch	text		The architecture the image is compatible with. Possible values are 'x86_64' and 'arm'.
creation_date	timestamp with time zone		The time when the image was created.
default_boot_script	jsonb		Describes the default bootscript for this image.
extra_volumes	jsonb		Describes the extra volumes for this image.
from_server	text		The ID of the server the image if based from.
id	text	=	An unique identifier of the image.
name	text	=	The user-defined name of the image.
organization	text		The ID of the organization where the image resides.
project	text		The ID of the project where the image resides.
public	boolean	!=, =	Indicates whether the image is public, or not.
root_volume	jsonb		Describes the root volume in this image.
state	text		The current state of the image.
title	text		Title of the resource.
zone	text	=	Specifies the zone where the image resides.

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)" -- scaleway

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

steampipe_export_scaleway --config '<your_config>' scaleway_instance_image