Table: heroku_domain - Query Heroku Domains using SQL

A Heroku Domain is the custom domain that can be added to a Heroku app, which allows the app to be accessed via a custom URL. This domain is associated with a DNS record that points at the Heroku-provided DNS target. It provides a way to give your application a custom URL, instead of using the default Herokuapp.com address.

Table Usage Guide

The heroku_domain table provides insights into the custom domains used within Heroku applications. As a DevOps engineer, explore domain-specific details through this table, including the domain name, created and updated timestamps, and the associated Heroku app. Utilize it to manage and monitor the domain configurations of your Heroku applications, ensuring they are correctly set up and functioning as expected.

Important Notes

List queries require an app_name.
Get queries require an app_name and a domain id.
Pagination is not currently supported for this resource type in the SDK.

Examples

List all domains

Explore all domains associated with a specific application to understand their status and type. This is helpful in managing and monitoring the application's network configuration.

select
  id,
  status,
  kind,
  hostname
from
  heroku_domain
where
  app_name = 'steampipe';

select
  id,
  status,
  kind,
  hostname
from
  heroku_domain
where
  app_name = 'steampipe';

List all custom domains

Discover the segments that include all custom domains associated with a specific application. This can be particularly useful in managing and monitoring your application's custom domains.

select
  id,
  status,
  kind,
  hostname
from
  heroku_domain
where
  app_name = 'steampipe'
  and kind = 'custom';

select
  id,
  status,
  kind,
  hostname
from
  heroku_domain
where
  app_name = 'steampipe'
  and kind = 'custom';

Schema for heroku_domain

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
acm_status	text		status of this record's ACM.
acm_status_reason	text		Reason for the status of this record's ACM.
app	jsonb		App that owns the domain.
app_name	text	=	ACM status of this app.
cname	text		Canonical name record, the address to point a domain at.
created_at	timestamp with time zone		When release was created.
hostname	text		Full hostname.
id	text	=	Unique identifier of this domain.
kind	text		Type of domain name.
sni_endpoint	jsonb		SNI endpoint the domain is associated with.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
status	text		Current status of the release.
updated_at	timestamp with time zone		When release 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_domain