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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
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.
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