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