Table: scaleway_instance_snapshot - Query Scaleway Instance Snapshots using SQL

Scaleway Instance Snapshots are a resource within Scaleway's cloud services that allow users to create a point-in-time copy of their instances. This is particularly useful for creating backups, migrating data, or testing changes without affecting the original instance. These snapshots contain all the information necessary to restore your instance (system settings, applications, and data) from the moment the snapshot was taken.

Table Usage Guide

The scaleway_instance_snapshot table provides insights into Instance Snapshots within Scaleway's cloud services. As a system administrator or DevOps engineer, explore snapshot-specific details through this table, including snapshot state, size, creation date, and the associated instance. Utilize it to manage and understand your instance backups, verify snapshot details, and ensure the integrity and safety of your data.

Examples

Basic info

Explore which Scaleway instance snapshots are currently active, by assessing their state and size. This can help manage resources and plan projects more efficiently.

select
  name,
  id,
  state,
  size,
  zone,
  project
from
  scaleway_instance_snapshot;

select
  name,
  id,
  state,
  size,
  zone,
  project
from
  scaleway_instance_snapshot;

List snapshots older than 90 days

Assess the elements within your Scaleway instances by identifying snapshots that have been stored for more than 90 days. This can be useful for managing storage and ensuring efficient use of resources.

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

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

List large snapshots (> 100GB or 100000000000 Bytes)

Discover the segments that contain large snapshots, specifically those exceeding 100GB. This can be beneficial in managing storage space and optimizing resource allocation within your project.

select
  name,
  id,
  state,
  size,
  zone,
  project
from
  scaleway_instance_snapshot
where
  size > 100000000000;

select
  name,
  id,
  state,
  size,
  zone,
  project
from
  scaleway_instance_snapshot
where
  size > 100000000000;

Schema for scaleway_instance_snapshot

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
creation_date	timestamp with time zone		The time when the snapshot was created.
id	text	=	An unique identifier of the snapshot.
modification_date	timestamp with time zone		The time when the snapshot was last modified.
name	text	=	The user-defined name of the snapshot.
organization	text		The ID of the organization where the snapshot resides.
project	text		The ID of the project where the snapshot resides.
size	bigint		The size of the snapshot (in bytes).
snapshot_base_volume	jsonb		Specifies the volume on which the snapshot is based on.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text		The current state of the snapshot.
title	text		Title of the resource.
volume_type	text		Specifies the snapshot volume type .
zone	text	=	Specifies the zone where the snapshot 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_snapshot