steampipe plugin install heroku

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_region
order by
name;
select
*
from
heroku_region
order 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_region
where
country = 'United States'
order by
name;
select
*
from
heroku_region
where
country = 'United States'
order by
name;

Schema for heroku_region

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*Unique identifier of an account.
countrytextCountry where the region exists.
created_attimestamp with time zoneWhen region was created.
descriptiontextDescription of region.
idtext=Unique identifier of region.
localetextArea in the country where the region exists.
nametextUnique name of region.
private_capablebooleanWhether or not region is available for creating a Private Space.
providerjsonbProvider of underlying substrate.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneWhen 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