Table: heroku_key - Query Heroku API Keys using SQL

Heroku API Keys are used to authenticate requests to the Heroku Platform API. These keys are tied to a Heroku user and provide a method for the user to interact with the Heroku platform programmatically. API Keys are a critical component of maintaining and managing applications on the Heroku platform.

Table Usage Guide

The heroku_key table provides insights into API Keys within Heroku. As a developer or system administrator, explore key-specific details through this table, including key fingerprints, public keys, and associated metadata. Utilize it to manage and audit API Keys, such as those associated with specific users or applications, and to ensure the security and integrity of your Heroku applications.

Important Notes

Get queries require a key id.
Pagination is not currently supported for this resource type in the SDK.

Examples

List all keys

Explore the full range of keys available within your Heroku application. This can help you manage and monitor access to your application effectively.

select
  *
from
  heroku_key;

select
  *
from
  heroku_key;

Keys older than 90 days

Explore which Heroku keys are older than 90 days. This is useful for maintaining security and ensuring keys are updated regularly.

select
  comment,
  created_at,
  date_part('day', now() - created_at) as age_in_days
from
  heroku_key
where
  created_at < now() - interval '90 days';

select
  comment,
  created_at,
  julianday('now') - julianday(created_at) as age_in_days
from
  heroku_key
where
  julianday('now') - julianday(created_at) > 90;

Schema for heroku_key

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
comment	text		Comment on the key.
created_at	timestamp with time zone		When key was created.
email	text		Deprecated. Please refer to 'comment' instead.
fingerprint	text		A unique identifying string based on contents.
id	text	=	Unique identifier of this key.
public_key	text		Full public_key as uploaded.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
updated_at	timestamp with time zone		When key 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_key