Table: heroku_account - Query Heroku Accounts using SQL

Heroku is a cloud platform as a service (PaaS) that lets companies build, deliver, monitor, and scale apps. The platform is flexible for developers, intuitive for teams, and built with love for the users. It is designed for developers to build and run applications entirely in the cloud.

Table Usage Guide

The heroku_account table provides insights into Heroku Accounts within the Heroku platform. As a DevOps engineer, explore account-specific details through this table, including email, identity provider, last login, created and updated times. Utilize it to uncover information about accounts, such as those with specific identity providers, the last login times, and the creation and update times.

Examples

Get account information

Explore the details of your Heroku account to gain insights into various aspects such as billing, usage, and settings. This can be useful for auditing, optimizing costs, and ensuring the account is configured correctly.

select
  *
from
  heroku_account;

select
  *
from
  heroku_account;

Check two factor authentication

Analyze the settings to understand which Heroku accounts have two-factor authentication enabled. This is useful for ensuring security best practices are being followed within your organization.

select
  email,
  two_factor_authentication
from
  heroku_account;

select
  email,
  two_factor_authentication
from
  heroku_account;

Schema for heroku_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	Unique identifier of an account.
acknowledged_msa	boolean		Whether account has acknowledged the MSA terms of service.
acknowledged_msa_at	timestamp with time zone		When account has acknowledged the MSA terms of service.
allow_tracking	boolean		Whether to allow third party web activity tracking.
beta	boolean		Whether allowed to utilize beta Heroku features.
country_of_residence	text		Country where account owner resides.
created_at	timestamp with time zone		When account was created.
default_organization	jsonb		Team selected by default.
default_team	jsonb		Team selected by default.
delinquent_at	timestamp with time zone		When account became delinquent.
email	text		Unique email address of account.
federated	boolean		Whether the user is federated and belongs to an Identity Provider.
id	text		Unique identifier of an account.
identity_provider	jsonb		Identity Provider details for federated users.
italian_customer_terms	text		Whether account has acknowledged the Italian customer terms of service.
italian_partner_terms	text		Whether account has acknowledged the Italian provider terms of service.
last_login	timestamp with time zone		When account last authorized with Heroku.
name	text		Full name of the account owner.
sms_number	text		SMS number of account.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
suspended_at	timestamp with time zone		When account was suspended.
two_factor_authentication	boolean		Whether two-factor auth is enabled on the account.
updated_at	timestamp with time zone		When account 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_account