Table: heroku_region - Query Heroku Regions using SQL
Heroku Regions are geographical areas in which Heroku infrastructure is located. Each region is completely isolated from other regions and has its own set of resources. Regions are designed to allow developers to deploy and run applications closer to their user base for improved latency.
Table Usage Guide
The heroku_region
table provides insights into the geographical areas where Heroku infrastructure is located. As a developer or system administrator, you can explore region-specific details through this table, including unique identifiers, names, and descriptions. Utilize it to understand the infrastructure distribution and to plan for application deployment for improved latency.
Important Notes
- Get queries require a region
id
. - Pagination is not currently supported for this resource type in the SDK.
Examples
List all regions
Explore the different regions where Heroku services are available, allowing you to understand the geographical distribution and plan your deployments accordingly.
select *from heroku_regionorder by name;
select *from heroku_regionorder by name;
List all US regions
Explore which Heroku regions are located within the United States. This is useful for understanding the geographical distribution of your Heroku resources.
select *from heroku_regionwhere country = 'United States'order by name;
select *from heroku_regionwhere country = 'United States'order by name;
Schema for heroku_region
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form. | |
account_id | text | =, !=, ~~, ~~*, !~~, !~~* | Unique identifier of an account. |
country | text | Country where the region exists. | |
created_at | timestamp with time zone | When region was created. | |
description | text | Description of region. | |
id | text | = | Unique identifier of region. |
locale | text | Area in the country where the region exists. | |
name | text | Unique name of region. | |
private_capable | boolean | Whether or not region is available for creating a Private Space. | |
provider | jsonb | Provider of underlying substrate. | |
sp_connection_name | text | =, !=, ~~, ~~*, !~~, !~~* | Steampipe connection name. |
sp_ctx | jsonb | Steampipe context in JSON form. | |
updated_at | timestamp with time zone | When region was updated. |
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)" -- heroku
You can pass the configuration to the command with the --config
argument:
steampipe_export_heroku --config '<your_config>' heroku_region