Table: ibm_is_region - Query IBM Cloud Regions using SQL

IBM Cloud Regions are geographically dispersed data centers where cloud resources are hosted. Each region is designed to be isolated from the others, ensuring a high level of fault tolerance and stability. Regions are grouped into geographic areas, providing users with the flexibility to host their resources close to their business or customers.

Table Usage Guide

The ibm_is_region table offers insights into the regions within IBM Cloud infrastructure. As a cloud architect or system administrator, you can explore region-specific details through this table, including the name, status, and geographical location of each region. Use it to understand the geographic distribution of your IBM Cloud resources, to plan for disaster recovery, or to make informed decisions when deploying new resources.

Examples

Basic info

Explore the status and endpoints of different regions within your IBM cloud infrastructure. This can help you understand the overall health and accessibility of your resources across different geographical locations.

select
  name,
  endpoint,
  status,
  href
from
  ibm_is_region;

select
  name,
  endpoint,
  status,
  href
from
  ibm_is_region;

List all European regions

Uncover the details of all IBM cloud regions located in Europe, including their status and endpoint information. This can be useful for managing resources or troubleshooting issues specific to these regions.

select
  name,
  endpoint,
  status,
  href
from
  ibm_is_region
where
  name like 'eu-%'

select
  name,
  endpoint,
  status,
  href
from
  ibm_is_region
where
  name like 'eu-%'

Schema for ibm_is_region

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The ID fof the account.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
endpoint	text		The API endpoint for this region.
href	text		The URL for this region.
name	text	=	The unique user-defined name for this region.
region	text		The region of this region.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		The status of this region.
tags	jsonb		A map of tags for the resource.
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)" -- ibm

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

steampipe_export_ibm --config '<your_config>' ibm_is_region