Table: scaleway_registry_image - Query Scaleway Registry Images using SQL

A Scaleway Registry Image is a resource in the Scaleway Container Registry, which is a fully-managed service to store and manage your Docker images. It allows you to store your images centrally for fast and reliable deployments in your applications. Each image in the registry includes a unique tag, status, visibility settings, and other metadata.

Table Usage Guide

The scaleway_registry_image table provides insights into registry images within Scaleway's Container Registry. As a DevOps engineer, explore image-specific details through this table, including the image tags, visibility settings, status, and other metadata. Utilize it to manage and streamline your Docker image deployments and ensure the security and efficiency of your containerized applications.

Examples

Basic info

Explore which Scaleway registry images are active and when they were created to manage storage effectively. This helps in understanding the overall usage and aids in resource optimization.

select
  name,
  id,
  status,
  created_at,
  tags,
  size
from
  scaleway_registry_image;

select
  name,
  id,
  status,
  created_at,
  tags,
  size
from
  scaleway_registry_image;

List images updated in last 10 days for a repository

Determine the images in a repository that have been updated recently, allowing you to stay informed about the latest changes and developments within your project.

select
  name,
  id,
  status,
  created_at,
  updated_at tags,
  size
from
  scaleway_registry_image
where
  updated_at >= now() - interval '10' day

select
  name,
  id,
  status,
  created_at,
  updated_at,
  tags,
  size
from
  scaleway_registry_image
where
  updated_at >= datetime('now', '-10 days')

List images with a public visibility

Discover the segments that have images with public visibility, allowing you to assess potential security risks and manage access controls more effectively. This is useful for maintaining data privacy and ensuring only appropriate images are publicly accessible.

select
  name,
  id,
  status,
  created_at,
  updated_at tags,
  visibility
from
  scaleway_registry_image
where
  visibility = 'public'

select
  name,
  id,
  status,
  created_at,
  updated_at,
  tags,
  visibility
from
  scaleway_registry_image
where
  visibility = 'public'

Schema for scaleway_registry_image

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
created_at	timestamp with time zone		The time when the image was created.
id	text	=	A unique identifier of the instance.
name	text	=	The image name, unique in a namespace
namespace_id	text	=	The unique ID of the namespace the image belongs to.
organization	text		The ID of the organization where the Image resides.
project	text		The ID of the project where the Image resides.
size	bigint		Image size in bytes, calculated from the size of image layers. One layer used in two tags of the same image is counted once but one layer used in two images is counted twice.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The current status of the Image.
tags	jsonb		A list of tags attached with the docker image.
title	text		Title of the resource.
updated_at	timestamp with time zone		The time when the image was updated.
visibility	text		A `public` image is pullable from internet without authentication, opposed to a `private` image. `inherit` will use the namespace `is_public` parameter.

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_registry_image