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