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, e.g. connection_name. | |
enabled | boolean | True if the region is enabled. | |
location | text | Location for the region. | |
name | text | Display name of the region. | |
slug | text | Slug of the region. |
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