Table: planetscale_region - Query PlanetScale Regions using SQL

PlanetScale Regions are the geographical locations available for deploying databases in the PlanetScale service. Each region is identified by a unique slug and has a display name. The enabled status indicates whether the region is currently available for use.

Table Usage Guide

The planetscale_region table provides insights into the regions available within PlanetScale. As a database administrator or developer, explore region-specific details through this table, including the unique slug, display name, and enabled status. Utilize it to understand the geographical distribution of your databases and plan for future deployments.

Examples

List all regions

Explore all the geographical regions in which PlanetScale operates, to better understand its global distribution and reach. This knowledge can be useful for planning resource allocation and optimizing service performance.

select
  *
from
  planetscale_region;

select
  *
from
  planetscale_region;

Schema for planetscale_region

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
enabled	boolean		True if the region is enabled.
location	text		Location for the region.
name	text		Display name of the region.
organization_name	text	=, !=, ~~, ~~, !~~, !~~	The name of the organization.
slug	text		Slug of the region.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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

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

steampipe_export_planetscale --config '<your_config>' planetscale_region