Table: scaleway_rdb_database - Query Scaleway RDB Databases using SQL

A Scaleway RDB Database is a managed relational database service that offers automated backups, high availability, and the ability to scale capacity up or down based on demand. It supports multiple database engines including MySQL, PostgreSQL, and Redis. With Scaleway RDB Database, you can focus on your application logic rather than managing database infrastructure.

Table Usage Guide

The scaleway_rdb_database table provides insights into RDB Databases within Scaleway. As a Database Administrator, explore database-specific details through this table, including configurations, settings, and status. Utilize it to uncover information about databases, such as their current operational state, the engine used, and the associated instance information.

Examples

Basic info

Explore which Scaleway databases are managed and identify their respective sizes and locations. This can help in assessing resource allocation and optimizing database management across different projects.

select
  name,
  instance_id,
  size,
  managed,
  region,
  project
from
  scaleway_rdb_database;

select
  name,
  instance_id,
  size,
  managed,
  region,
  project
from
  scaleway_rdb_database;

List managed databases

Explore which databases are managed within your Scaleway RDB project. This query helps you to pinpoint specific locations and assess the elements within your project, providing insights into your data management and storage.

select
  name,
  instance_id,
  size,
  managed,
  region,
  project
from
  scaleway_rdb_database
where
  managed;

select
  name,
  instance_id,
  size,
  managed,
  region,
  project
from
  scaleway_rdb_database
where
  managed = 1;

Get count of databases by instance

Explore the distribution of databases across different instances to understand how data is organized and managed within your Scaleway RDB environment. This can help optimize resource allocation and management strategies.

select
  instance_id,
  count(name)
from
  scaleway_rdb_database
group by
  instance_id;

select
  instance_id,
  count(name)
from
  scaleway_rdb_database
group by
  instance_id;

Schema for scaleway_rdb_database

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
instance_id	text		An unique identifier of the instance.
managed	boolean	!=, =	Indicates whether database is managed, or not.
name	text	=	The user-defined name of the database.
organization	text		The ID of the organization where the instance resides.
owner	text	=	Specifies the name of the owner of the database.
project	text		The ID of the project where the instance resides.
region	text	=	Specifies the region where the instance resides.
size	bigint		The size of the database.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.

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_rdb_database