Table: stripe_account - Query Stripe Accounts using SQL

Stripe Account is a resource within the Stripe payment processing platform that represents an account on Stripe. These accounts can be associated with individual users or businesses and contain information about the account's details, balances, capabilities, and settings. They are integral to managing and understanding the financial transactions occurring on your Stripe platform.

Table Usage Guide

The stripe_account table provides insights into the accounts within your Stripe platform. As a financial analyst or platform administrator, explore account-specific details through this table, including balances, capabilities, and settings. Utilize it to uncover information about each account, such as the account type, its capabilities, and the currencies it can handle.

Examples

List all accounts

Explore all your Stripe accounts to gain a comprehensive overview and better manage your online transactions. This could be particularly useful for businesses with multiple accounts, helping to streamline their financial operations.

select
  *
from
  stripe_account;

select
  *
from
  stripe_account;

Are card payments active for this account?

Explore whether card payments are enabled for a given account. This can be useful for businesses to ensure they can process card payments and maintain smooth operations.

select
  id,
  (capabilities -> 'card_payments') :: bool as card_payments
from
  stripe_account;

select
  id,
  json_extract(capabilities, '$.card_payments') as card_payments
from
  stripe_account;

Schema for stripe_account

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Stripe account ID.
business_profile	jsonb		Business information about the account.
business_type	text		The business type.
capabilities	jsonb		A hash containing the set of capabilities that was requested for this account and their associated states. Keys are names of capabilities. You can see the full list here. Values may be active, inactive, or pending.
charges_enabled	boolean		Whether the account can create live charges.
company	jsonb		Information about the company or business. This field is available for any business_type.
country	text		The account’s country.
created	timestamp with time zone		Time at which the account was created.
default_currency	text		Three-letter ISO currency code representing the default currency for the account.
deleted	boolean		True if the customer is marked as deleted.
details_submitted	boolean		Whether account details have been submitted. Standard accounts cannot receive payouts before this is true.
email	text		An email address associated with the account. You can treat this as metadata: it is not used for authentication or messaging account holders.
external_accounts	jsonb		External accounts (bank accounts and debit cards) currently attached to this account.
id	text		Unique identifier for the account.
individual	jsonb		Information about the person represented by the account. This field is null unless business_type is set to individual.
metadata	jsonb		Set of key-value pairs that you can attach to an account. This can be useful for storing additional information about the account in a structured format.
payouts_enabled	boolean		Whether Stripe can send payouts to this account.
requirements	jsonb		Information about the requirements for the account, including what information needs to be collected, and by when.
settings	jsonb		Options for customizing how the account functions within Stripe.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tos_acceptance	jsonb		Details on the acceptance of the Stripe Services Agreement.
type	text		The Stripe account type. Can be standard, express, or custom.

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)" -- stripe

You can pass the configuration to the command with the --config argument:

steampipe_export_stripe --config '<your_config>' stripe_account