Stripe connector

Kaivo is a fully managed data platform that syncs your Stripe data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your payment and finance data instead of moving it.

What is the Stripe connector

Sync your Stripe payments, charges, invoices, and subscriptions into BigQuery with Kaivo to report on revenue, churn, and cash flow alongside your business.

Category	Finance & Payments
Authentication	API key
Setup	Self-service

Getting started with the Stripe connector

1. Sign up for Kaivo and create a workspace.
2. Connect your Stripe account.
3. Choose which tables to sync.
4. Wait for the initial sync to finish.
5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticating Stripe

Authenticate with your Secret Key.

Field	Description
Secret Key
Stripe API key (usually starts with ‘sk_live_’; find yours here).

|

Configuring the Stripe connector

When you set up the connector, you provide:

Field	Description
Account ID
Your Stripe account ID (starts with ‘acct_’, find yours here).

| | Replication start date |

Any data before this date will not be fetched.

|

Tables and columns synced from Stripe

Kaivo syncs 47 tables from Stripe into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

accounts (168 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
business_profile__annual_revenue__amount	INT64	The annual revenue amount.
business_profile__annual_revenue__currency	STRING	The currency in which the annual revenue is denominated.
business_profile__annual_revenue__fiscal_year_end	STRING	The fiscal year end date for the annual revenue.
business_profile__estimated_worker_count	INT64	The estimated number of workers in the business.
business_profile__mcc	STRING	Merchant Category Code representing the type of business.
business_profile__name	STRING	The name of the business.
business_profile__product_description	STRING	Description of the products/services offered by the business.
business_profile__support_address__city	STRING
business_profile__support_address__country	STRING
… and 158 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• accounts__external_accounts__data (4 columns)
• accounts__individual__full_name_aliases (4 columns)
• accounts__individual__full_requirements__alternatives__alternative_fields_due (4 columns)
• accounts__individual__full_requirements__alternatives__original_fields_due (4 columns)
• accounts__individual__full_requirements__errors (6 columns)
• accounts__individual__full_requirements__eventually_due (4 columns)
• accounts__individual__full_requirements__past_due (4 columns)
• accounts__individual__full_requirements__pending_verification (4 columns)
• accounts__individual__requirements__alternatives__alternative_fields_due (4 columns)
• accounts__individual__requirements__alternatives__original_fields_due (4 columns)
• accounts__individual__requirements__currently_due (4 columns)
• accounts__individual__requirements__errors (6 columns)
• accounts__individual__requirements__eventually_due (4 columns)
• accounts__individual__requirements__past_due (4 columns)
• accounts__individual__requirements__pending_verification (4 columns)
• accounts__requirements__alternatives (4 columns)
• accounts__requirements__currently_due (4 columns)
• accounts__requirements__errors (6 columns)
• accounts__requirements__eventually_due (4 columns)
• accounts__requirements__past_due (4 columns)
• accounts__requirements__pending_verification (4 columns)
• accounts__future_requirements__alternatives (3 columns)
• accounts__future_requirements__alternatives__alternative_fields_due (4 columns)
• accounts__future_requirements__alternatives__original_fields_due (4 columns)
• accounts__future_requirements__currently_due (4 columns)
• accounts__future_requirements__errors (6 columns)
• accounts__future_requirements__eventually_due (4 columns)
• accounts__future_requirements__past_due (4 columns)
• accounts__future_requirements__pending_verification (4 columns)

application_fees (22 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the application fee.
object	STRING	Type of object, which should have a value of ‘application_fee’.
account	STRING	The ID of the Stripe account that received the application fee.
amount	FLOAT64	The total amount in cents that was collected by the application fee.
amount_refunded	FLOAT64	The total amount in cents that was refunded for the application fee.
application	STRING	The ID of the application that the fee was collected for.
balance_transaction	STRING	The ID of the balance transaction associated with the application fee.
charge	STRING	The ID of the charge that the application fee was collected from.
created	FLOAT64	The timestamp when the application fee was created.
… and 12 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• application_fees__refunds__data (4 columns)

application_fees_refunds (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the application fee refund
object	STRING	The object type, which will be ‘fee_refund’
amount	FLOAT64	The amount refunded in the application fee
balance_transaction	STRING	The balance transaction ID associated with the refund
created	FLOAT64	Timestamp for when the refund was created
updated	INT64	Timestamp for when the refund was last updated
currency	STRING	The currency of the refunded amount
fee	STRING	The application fee ID associated with the refund
metadata__fee	STRING	Metadata related to the refunded fee
… and 1 more columns

authorizations (91 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount	INT64	The amount of the authorization.
amount_details__atm_fee	INT64	The ATM fee included in the authorization amount.
approved	BOOL	Indicates if the authorization is approved.
authorization_method	STRING	The method used for authorization.
card__brand	STRING
card__cancellation_reason	STRING
card__cardholder__billing__address__city	STRING
card__cardholder__billing__address__country	STRING
card__cardholder__billing__address__line1	STRING
… and 81 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• authorizations__balance_transactions (17 columns)
• authorizations__balance_transactions__fee_details (8 columns)
• authorizations__balance_transactions__sourced_transfers (4 columns)
• authorizations__card__cardholder__requirements__past_due (4 columns)
• authorizations__card__cardholder__spending_controls__allowed_categories (4 columns)
• authorizations__card__cardholder__spending_controls__blocked_categories (4 columns)
• authorizations__card__cardholder__spending_controls__spending_limits (3 columns)
• authorizations__card__cardholder__preferred_locales (4 columns)
• authorizations__card__spending_controls__allowed_categories (4 columns)
• authorizations__card__spending_controls__blocked_categories (4 columns)
• authorizations__card__spending_controls__spending_limits (3 columns)
• authorizations__request_history (11 columns)
• authorizations__transactions (27 columns)
• authorizations__transactions__purchase_details__flight__segments (9 columns)

balance_transactions (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
fee	INT64
currency	STRING
source	STRING
available_on	INT64
status	STRING
description	STRING
net	INT64
exchange_rate	FLOAT64
type	STRING
… and 6 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• balance_transactions__fee_details (8 columns)
• balance_transactions__sourced_transfers (4 columns)

bank_accounts (17 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the bank account.
object	STRING	Type of object, in this case, ‘bank_account’.
account_holder_name	STRING	The name of the account holder associated with the bank account.
account_holder_type	STRING	The type of account holder (individual or company) for the bank account.
account_type	STRING	The type of bank account (checking or savings).
bank_name	STRING	The name of the bank associated with the bank account.
country	STRING	The country where the bank account is located.
currency	STRING	The currency associated with the bank account.
customer	STRING	ID of the customer associated with the bank account.
… and 7 more columns

cardholders (28 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing__address__city	STRING
billing__address__country	STRING
billing__address__line1	STRING
billing__address__line2	STRING
billing__address__postal_code	STRING
billing__address__state	STRING
company__tax_id_provided	BOOL
created	INT64
updated	INT64
… and 18 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• cardholders__requirements__past_due (4 columns)
• cardholders__spending_controls__allowed_categories (4 columns)
• cardholders__spending_controls__blocked_categories (4 columns)
• cardholders__spending_controls__spending_limits (3 columns)
• cardholders__preferred_locales (4 columns)

cards (59 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
brand	STRING
cancellation_reason	STRING
cardholder__billing__address__city	STRING
cardholder__billing__address__country	STRING
cardholder__billing__address__line1	STRING
cardholder__billing__address__line2	STRING
cardholder__billing__address__postal_code	STRING
cardholder__billing__address__state	STRING
cardholder__company__tax_id_provided	BOOL
… and 49 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• cards__cardholder__requirements__past_due (4 columns)
• cards__cardholder__spending_controls__allowed_categories (4 columns)
• cards__cardholder__spending_controls__blocked_categories (4 columns)
• cards__cardholder__spending_controls__spending_limits (3 columns)
• cards__cardholder__preferred_locales (4 columns)
• cards__spending_controls__allowed_categories (4 columns)
• cards__spending_controls__blocked_categories (4 columns)
• cards__spending_controls__spending_limits (3 columns)

charges (290 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
fraud_details__stripe_report	STRING	The ID of the fraud report from Stripe.
transfer_group	STRING	The transfer group of the charge.
on_behalf_of	STRING	The ID of the account on behalf of which the charge is made.
review	STRING	A boolean indicating if the charge is under review.
failure_message	STRING	The failure error message for the charge.
receipt_email	STRING	The email address to send receipt of the charge.
statement_descriptor	STRING	The statement descriptor for the charge.
source__type	STRING
source__address_zip	STRING
… and 280 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• charges__refunds__data (4 columns)
• charges__amount_updates (4 columns)

checkout_sessions (93 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the session.
object	STRING	Type of object.
after_expiration__recovery__allow_promotion_codes	BOOL	Flag indicating whether to allow promotion codes during recovery.
after_expiration__recovery__enabled	BOOL	Flag indicating whether recovery is enabled.
after_expiration__recovery__expires_at	INT64	Timestamp indicating the expiration time for recovery.
after_expiration__recovery__url	STRING	URL for the recovery process.
allow_promotion_codes	BOOL	Flag indicating whether promotion codes are allowed.
amount_subtotal	INT64	Subtotal amount for the session.
amount_total	INT64	Total amount for the session.
… and 83 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• checkout_sessions__customer_details__tax_ids (5 columns)
• checkout_sessions__payment_method_options__acss_debit__mandate_options__default_for (4 columns)
• checkout_sessions__payment_method_types (4 columns)
• checkout_sessions__shipping_address_collection__allowed_countries (4 columns)
• checkout_sessions__total_details__breakdown__discounts (4 columns)
• checkout_sessions__total_details__breakdown__taxes (17 columns)
• checkout_sessions__custom_fields (15 columns)
• checkout_sessions__custom_fields__dropdown__options (3 columns)
• checkout_sessions__invoice_creation__invoice_data__account_tax_ids (4 columns)
• checkout_sessions__invoice_creation__invoice_data__custom_fields (5 columns)
• checkout_sessions__shipping_cost__taxes (20 columns)
• checkout_sessions__shipping_options (5 columns)

checkout_sessions_line_items (41 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier of the line item.
checkout_session_id	STRING	The unique identifier of the checkout session.
checkout_session_expires_at	INT64	The expiration timestamp of the checkout session.
checkout_session_created	INT64	The timestamp when the checkout session was created.
checkout_session_updated	INT64	The timestamp when the checkout session was last updated.
object	STRING	The type of object, in this case, it will be ‘checkout_sessions_line_items’.
amount_subtotal	INT64	The subtotal amount of the line item before any discounts or taxes.
amount_tax	INT64	The total tax amount applied to the line item.
amount_discount	INT64	The total discount amount applied to the line item.
… and 31 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• checkout_sessions_line_items__discounts (28 columns)
• checkout_sessions_line_items__discounts__discount__coupon__applies_to__products (4 columns)
• checkout_sessions_line_items__taxes (17 columns)

coupons (19 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
times_redeemed	INT64	Number of times the coupon has been redeemed.
percent_off_precise	FLOAT64	Precise percentage discount value.
livemode	BOOL	Indicates if the coupon is in live mode.
object	STRING	Type of object, in this case, ‘coupon’.
redeem_by	STRING	Timestamp by which the coupon must be redeemed.
duration	STRING	Specifies the duration that the coupon remains valid for, e.g., once, repeating.
id	STRING	Unique identifier for the coupon.
valid	BOOL	Indicates if the coupon is currently valid for use.
currency	STRING	Currency of the amount_off value.
… and 9 more columns

credit_notes (33 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier of the credit note.
object	STRING	The object type.
amount	INT64	The total amount of the credit note.
amount_shipping	INT64	The amount charged for shipping.
created	INT64	The timestamp when the credit note was created.
updated	INT64	The timestamp when the credit note was last updated.
currency	STRING	The currency of the credit note.
customer	STRING	The customer associated with the credit note.
customer_balance_transaction	STRING	The balance transaction associated with the customer.
… and 23 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• credit_notes__discount_amounts (4 columns)
• credit_notes__lines__data (16 columns)
• credit_notes__lines__data__discount_amounts (5 columns)
• credit_notes__lines__data__tax_amounts (8 columns)
• credit_notes__lines__data__tax_rates (17 columns)
• credit_notes__shipping_cost__taxes (21 columns)
• credit_notes__tax_amounts (8 columns)

customer_balance_transactions (15 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier of the balance transaction
object	STRING	Type of object, in this case, ‘balance_transaction’
amount	FLOAT64	The transaction amount in the smallest currency unit
created	INT64	The date and time when the transaction was created
updated	INT64	The date and time when the transaction was created
credit_note	STRING	Credit note related to the balance transaction
currency	STRING	The currency code of the transaction amount
customer	STRING	ID of the customer associated with the transaction
description	STRING	Description of the balance transaction
… and 5 more columns

customers (65 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
invoice_settings__default_payment_method	STRING
invoice_settings__footer	STRING
name	STRING
tax_exempt	STRING
next_invoice_sequence	INT64
balance	INT64
phone	STRING
address__city	STRING
address__country	STRING
… and 55 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• customers__preferred_locales (4 columns)
• customers__invoice_settings__custom_fields (4 columns)
• customers__cards (26 columns)
• customers__subscriptions__data (4 columns)

disputes (49 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The ID of the dispute.
object	STRING	Type of object being returned.
amount	INT64	The amount of the dispute.
charge	STRING	The charge ID associated with the dispute.
created	INT64	The timestamp when the dispute was created.
updated	INT64	The timestamp when the dispute was last updated.
currency	STRING	The currency of the dispute amount.
evidence__refund_policy	STRING
evidence__shipping_address	STRING
… and 39 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• disputes__balance_transactions (4 columns)

early_fraud_warnings (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the fraud warning.
object	STRING	Defines the object type as ‘early_fraud_warning’.
actionable	BOOL	Boolean indicating if action is required based on the fraud warning.
charge	STRING	ID of the charge associated with the fraud warning.
created	FLOAT64	Timestamp when the fraud warning was created.
updated	INT64	Timestamp when the fraud warning was last updated.
fraud_type	STRING	Type of fraud warning detected.
livemode	BOOL	Boolean indicating if the fraud warning is in live mode.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

events (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created	INT64	The timestamp representing when the event was created.
id	STRING	The unique identifier of the event.
api_version	STRING	The version of the Stripe API that generated the event.
object	STRING	The object type representing the event.
livemode	BOOL	Indicates whether the event occurred in live mode or test mode.
pending_webhooks	INT64	The number of webhooks pending to be sent related to the event.
request	JSON	The API request information associated with the event.
type	STRING	The type of event that occurred.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

external_account_bank_accounts (17 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the bank account.
object	STRING	The object type, which is typically ‘bank_account’.
account_holder_name	STRING	The name of the account holder.
account_holder_type	STRING	The type of account holder, such as individual or company.
account_type	STRING	The type of bank account, such as checking or savings.
bank_name	STRING	The name of the bank.
country	STRING	The country where the bank account is located.
currency	STRING	The currency of the bank account.
fingerprint	STRING	A unique identifier for the bank account.
… and 7 more columns

external_account_cards (27 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the card.
object	STRING	Indicates the object type such as ‘card’.
address_city	STRING	The city part of the cardholder’s billing address.
address_country	STRING	The country part of the cardholder’s billing address.
address_line1	STRING	The first line of the cardholder’s billing address.
address_line1_check	STRING	If `address_line1` was provided, indicates if it has been checked for address_line1 true/false.
address_line2	STRING	The second line of the cardholder’s billing address.
address_state	STRING	The state part of the cardholder’s billing address.
address_zip	STRING	The ZIP or postal code of the cardholder’s billing address.
… and 17 more columns

file_links (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the file link.
expires_at	INT64	Timestamp indicating the date and time when the file link will expire.
file	STRING	Information about the file linked.
url	STRING	The URL that can be used to access/download the file linked.
object	STRING	Indicates the object type, which should be ‘file_link’.
created	INT64	Timestamp representing the date and time when the file link was created.
expired	BOOL	Boolean indicating whether the file link is expired or not.
livemode	BOOL	Boolean indicating whether the file link is in live mode or test mode.
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

files (15 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the file
purpose	STRING	Purpose of the file
type	STRING	Type of the file
object	STRING	Type of object represented by the file
created	INT64	Timestamp indicating when the file was created
expires_at	INT64	Timestamp indicating when the file will expire
filename	STRING	Name of the file
links__object	STRING	Type of object containing the linked data entries
links__has_more	BOOL	Boolean indicating whether there are more linked data entries
… and 5 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• files__links__data (11 columns)

invoice_items (69 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount	INT64	The amount associated with the invoice item
plan__nickname	STRING	The nickname of the plan
plan__object	STRING	The object type of the plan
plan__aggregate_usage	STRING	The usage aggregation rule for the plan
plan__created	INT64	The creation timestamp of the plan
plan__statement_description	STRING	The description on customer’s statement for the plan
plan__product	STRING	The product associated with the plan
plan__statement_descriptor	STRING	The statement descriptor of the plan
plan__interval_count	INT64	The number of intervals between plan charges
… and 59 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• invoice_items__plan__tiers (6 columns)
• invoice_items__price__tiers (4 columns)
• invoice_items__discounts (4 columns)
• invoice_items__tax_rates (17 columns)

invoice_line_items (70 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the invoice line item.
invoice	STRING	The ID of the invoice associated with the line item.
invoice_id	STRING	The ID of the invoice associated with the line item.
subscription_item	STRING	The item details associated with the subscription.
description	STRING	A brief description of the invoice line item.
object	STRING	The object type, which is ‘invoiceitem’.
discountable	BOOL	Indicates whether the item is eligible for discounts.
quantity	INT64	The quantity of the item being billed.
amount	INT64	The total amount of the invoice line item, including any taxes and discounts.
… and 60 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• invoice_line_items__margins (4 columns)
• invoice_line_items__plan__tiers (6 columns)
• invoice_line_items__proration_details__credited_items__invoice_line_items (4 columns)
• invoice_line_items__price__tiers (4 columns)
• invoice_line_items__discount_amounts (5 columns)
• invoice_line_items__discounts (4 columns)
• invoice_line_items__tax_rates (17 columns)
• invoice_line_items__tax_amounts (8 columns)

invoices (139 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created	INT64	The timestamp when the invoice was created
updated	INT64	Timestamp for when the invoice was last updated
next_payment_attempt	FLOAT64	Timestamp for the next payment attempt
tax	INT64	The total tax amount on the invoice
charge	STRING	The charge associated with the invoice
description	STRING	The description of the invoice
receipt_number	STRING	The receipt number associated with the invoice
attempt_count	INT64	The number of attempts made to pay the invoice
payment	STRING	The payment details associated with the invoice
… and 129 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• invoices__customer_tax_ids (5 columns)
• invoices__discounts (20 columns)
• invoices__total_discount_amounts (5 columns)
• invoices__shipping_cost__taxes (4 columns)
• invoices__custom_fields (5 columns)
• invoices__total_tax_amounts (21 columns)
• invoices__payment_settings__payment_method_types (4 columns)
• invoices__default_tax_rates (17 columns)
• invoices__account_tax_ids (4 columns)

payment_intents (204 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING
object	STRING
amount	INT64
amount_capturable	INT64
amount_received	INT64
application	STRING
application_fee_amount	INT64
canceled_at	INT64
cancellation_reason	STRING
… and 194 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• payment_intents__charges__data (4 columns)
• payment_intents__last_payment_error__payment_method__card__networks__available (4 columns)
• payment_intents__payment_method_types (4 columns)

payment_methods (58 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
acss_debit__bank_name	STRING
acss_debit__fingerprint	STRING
acss_debit__institution_number	STRING
acss_debit__last4	STRING
acss_debit__transit_number	STRING
allow_redisplay	STRING
au_becs_debit__bsb_number	STRING
au_becs_debit__fingerprint	STRING
au_becs_debit__last4	STRING
… and 48 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• payment_methods__card__networks__available (4 columns)

payout_balance_transactions (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
payout	STRING
fee	INT64
currency	STRING
source	STRING
available_on	INT64
status	STRING
description	STRING
net	INT64
exchange_rate	FLOAT64
… and 8 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• payout_balance_transactions__fee_details (8 columns)

payouts (44 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
failure_code	STRING	The failure code for a failed payout.
id	STRING	The ID of the payout.
statement_description	STRING	The description that will appear on the bank statement.
amount	INT64	The amount of the payout in the smallest currency unit.
balance_transaction	STRING	The ID of the balance transaction that describes the impact on your account balance.
created	INT64	The date the payout was created.
updated	INT64	The date the payout was last updated.
amount_reversed	INT64	The amount that was reversed (negative) from this payout.
source_type	STRING	The type of the source transaction (charge, payment, refund).
… and 34 more columns

persons (51 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the person
object	STRING	Object type for the person data
phone	STRING	Phone number
email	STRING	Email address
address_kana	STRING	Japanese Kana writing for address
address_kanji	STRING	Japanese Kanji writing for address
first_name_kana	STRING	Japanese Kana writing for first name
gender	STRING	Gender of the person
full_name_aliases	STRING	Alternate full name entries
… and 41 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• persons__future_requirements__alternatives (6 columns)
• persons__future_requirements__alternatives__alternative_fields_due (4 columns)
• persons__future_requirements__alternatives__original_fields_due (4 columns)
• persons__future_requirements__currently_due (6 columns)
• persons__future_requirements__errors (6 columns)
• persons__future_requirements__eventually_due (6 columns)
• persons__future_requirements__past_due (6 columns)
• persons__future_requirements__pending_verification (6 columns)
• persons__requirements__alternatives (6 columns)
• persons__requirements__alternatives__alternative_fields_due (4 columns)
• persons__requirements__alternatives__original_fields_due (4 columns)
• persons__requirements__currently_due (6 columns)
• persons__requirements__errors (6 columns)
• persons__requirements__eventually_due (6 columns)
• persons__requirements__past_due (6 columns)
• persons__requirements__pending_verification (6 columns)

plans (25 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
nickname	STRING	A short phrase used to identify the plan.
object	STRING	Type of object. Value is ‘plan’.
aggregate_usage	STRING	Determines how usage is calculated for the subscription.
created	INT64	Timestamp representing the creation date of the plan.
updated	INT64	Timestamp representing the last update of the plan.
statement_description	STRING	Description to be shown on customer statements.
product	STRING	The product associated with the plan.
statement_descriptor	STRING	The statement descriptor to be shown on credit card statements.
interval_count	INT64	Number of intervals between each subscription billing.
… and 15 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• plans__tiers (8 columns)

prices (27 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the price.
object	STRING	Type of object, in this case, ‘price’.
active	BOOL	Indicates if the price is currently active or not.
billing_scheme	STRING	Defines how the price interacts with the subscription’s billing periods.
created	INT64	Timestamp representing when the price was created.
updated	INT64	Timestamp representing when the price was last updated.
currency	STRING	The currency of the price.
custom_unit_amount	STRING	Custom unit amount for the price if set.
livemode	BOOL	Indicates if the price is in live mode.
… and 17 more columns

products (23 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the product.
object	STRING	Indicates the type of object, in this case, a product.
active	BOOL	Indicates if the product is active or not.
caption	STRING	A short description or title for the product.
created	INT64	Timestamp indicating the creation date of the product.
description	STRING	A detailed description of the product.
livemode	BOOL	Indicates if the product is in live mode or test mode.
name	STRING	Name of the product.
package_dimensions__width	FLOAT64	Width dimension of the product package.
… and 13 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• products__attributes (4 columns)
• products__deactivate_on (4 columns)
• products__images (4 columns)
• products__features (4 columns)

promotion_codes (30 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the promotion code.
code	STRING	The unique code string associated with the promotion code.
coupon__id	STRING	The unique identifier for the coupon.
coupon__amount_off	INT64	The amount which will be discounted from the total if the coupon is applied.
coupon__currency	STRING	The currency in which the discount amount is specified.
coupon__duration	STRING	Indicates how long the discount will last (e.g, once, forever).
coupon__duration_in_months	INT64	Optional. The number of months the coupon will last.
coupon__name	STRING	The name of the coupon.
coupon__percent_off	FLOAT64	The percentage to be discounted if the coupon is applied.
… and 20 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• promotion_codes__coupon__applies_to__products (4 columns)

refunds (21 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the refund.
object	STRING	Indicates the type of object, which should be ‘refund’.
amount	INT64	The amount refunded in the smallest currency unit (e.g. cents).
balance_transaction	STRING	ID of the balance transaction that describes the impact on your account balance.
charge	STRING	ID of the charge that was refunded.
created	INT64	Timestamp representing when the refund was created.
updated	INT64	Timestamp representing when the refund was last updated.
currency	STRING	The currency of the refund.
payment_intent	STRING	ID of the payment intent associated with the refund.
… and 11 more columns

reviews (24 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_zip	STRING	The ZIP code associated with the billing address.
charge	STRING	The charge associated with the payment.
closed_reason	STRING	The reason for closing the transaction.
created	INT64	The timestamp when the review was created.
updated	INT64	The timestamp when the review was last updated.
id	STRING	The unique identifier for the review.
ip_address	STRING	The IP address of the reviewer.
ip_address_location__city	STRING	The city of the reviewer’s IP address location.
ip_address_location__country	STRING	The country of the reviewer’s IP address location.
… and 14 more columns

setup_attempts (321 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application	STRING	The application associated with the setup attempt.
created	INT64	The timestamp when the setup attempt was created.
customer	STRING	The customer associated with the setup attempt.
id	STRING	The unique identifier for the setup attempt.
livemode	BOOL	Indicates if the setup attempt is in live mode.
object	STRING	The object type, typically ‘setup_attempt’.
on_behalf_of	STRING	The entity on whose behalf the setup attempt is being made.
payment_method	STRING	The payment method associated with the setup attempt.
payment_method_details__bancontact__bank_code	STRING	The bank code associated with the Bancontact payment method.
… and 311 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• setup_attempts__setup_error__payment_intent__charges__data (4 columns)
• setup_attempts__setup_error__payment_intent__last_payment_error__payment_method__card__networks__available (4 columns)
• setup_attempts__setup_error__payment_intent__payment_method_types (4 columns)
• setup_attempts__setup_error__payment_method__card__networks__available (4 columns)
• setup_attempts__setup_error__setup_intent__flow_directions (4 columns)
• setup_attempts__setup_error__setup_intent__payment_method_types (4 columns)
• setup_attempts__flow_directions (4 columns)

setup_intents (25 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING
object	STRING
application	STRING
cancellation_reason	STRING
created	INT64
updated	INT64
customer	STRING
description	STRING
last_setup_error	STRING
… and 15 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• setup_intents__flow_directions (4 columns)
• setup_intents__payment_method_types (4 columns)

shipping_rates (16 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the shipping rate
object	STRING	Type of object, in this case, it will always be ‘shipping_rate’
active	BOOL	Specifies if the shipping rate is currently active or not
created	INT64	Timestamp indicating when the shipping rate was created
delivery_estimate	STRING	Estimated delivery time for the shipping rate
display_name	STRING	Name displayed for the shipping rate
fixed_amount__amount	INT64	Fixed amount for the shipping rate
fixed_amount__currency	STRING	Currency of the fixed amount
livemode	BOOL	Indicates if the shipping rate is in live mode
… and 6 more columns

subscription_items (68 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
canceled_at	STRING	Timestamp indicating when the subscription was canceled.
current_period_end	STRING	Timestamp indicating when the current billing period ends.
plan__nickname	STRING	Nickname of the plan.
plan__object	STRING	Type of object, in this case, ‘plan’.
plan__aggregate_usage	STRING	Type of usage aggregation for the subscription.
plan__created	INT64	Timestamp indicating when the plan was created.
plan__statement_description	STRING	Description to be shown on the customer’s statement for the plan.
plan__product	STRING	ID of the product associated with the plan.
plan__statement_descriptor	STRING	Descriptor shown on the customer’s credit card statement for the plan.
… and 58 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• subscription_items__plan__tiers (6 columns)
• subscription_items__tax_rates (17 columns)
• subscription_items__price__tiers (4 columns)

subscription_schedule (30 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique ID of the subscription schedule.
object	STRING	The object type, which is ‘subscription_schedule’.
application	STRING	The ID of the application associated with the subscription schedule.
canceled_at	STRING	The date and time when the subscription schedule was canceled.
completed_at	STRING	The date and time when the subscription schedule was completed.
created	INT64	The date and time when the subscription schedule was created.
updated	INT64	The date and time when the subscription schedule was last updated.
current_phase__end_date	INT64	The end date of the current phase.
current_phase__start_date	INT64	The start date of the current phase.
… and 20 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• subscription_schedule__phases (18 columns)
• subscription_schedule__phases__add_invoice_items (5 columns)
• subscription_schedule__phases__add_invoice_items__tax_rates (17 columns)
• subscription_schedule__phases__default_tax_rates (17 columns)
• subscription_schedule__phases__items (6 columns)
• subscription_schedule__phases__items__tax_rates (3 columns)

subscriptions (99 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
canceled_at	FLOAT64	The timestamp at which the subscription was canceled.
cancel_at	FLOAT64	The timestamp at which the subscription will be canceled.
livemode	BOOL	Indicates if the subscription is in live mode.
start_date	INT64	The start date of the subscription.
items__object	STRING	Type of object, in this case, ‘items’.
items__has_more	BOOL	Indicates if there are more items in the subscription.
items__total_count	FLOAT64	The total count of items in the subscription.
items__url	STRING	The URL to access the subscription items.
id	STRING	The unique identifier of the subscription.
… and 89 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• subscriptions__items__data (4 columns)
• subscriptions__plan__tiers (6 columns)
• subscriptions__payment_settings__payment_method_types (4 columns)
• subscriptions__default_tax_rates (17 columns)
• subscriptions__pending_update__subscription_items (34 columns)
• subscriptions__pending_update__subscription_items__price__tiers (4 columns)
• subscriptions__pending_update__subscription_items__tax_rates (17 columns)

top_ups (18 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	Unique identifier for the top-up
amount	INT64	The amount of the top-up in the smallest currency unit, e.g., 100 cents for $1
currency	STRING	The currency in which the top-up was made, e.g., USD, EUR
description	STRING	A brief description of the purpose of the top-up
status	STRING	Current status of the top-up, e.g., succeeded, failed
object	STRING	Type of object, in this case, ‘top-up’
balance_transaction	STRING	ID of the balance transaction that describes the impact of this top-up on your account balance
created	INT64	Timestamp indicating when the top-up was created
updated	INT64	Timestamp indicating when the top-up was last updated
… and 8 more columns

transactions (28 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount	INT64	The transaction amount in the specified currency.
amount_details__atm_fee	INT64	The fee charged by the ATM for the transaction.
authorization	STRING	The authorization code for the transaction.
balance_transaction	STRING	The ID of the balance transaction associated with this payment.
card	STRING	Information about the payment card used for the transaction.
cardholder	STRING	Details about the cardholder, such as name and address.
created	INT64	The timestamp when the transaction was created.
updated	INT64	The timestamp when the transaction record was last updated.
currency	STRING	The currency in which the transaction was made.
… and 18 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• transactions__purchase_details__flight__segments (9 columns)

transfer_reversals (11 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount	INT64	The amount of the transfer reversal, in cents.
balance_transaction	STRING	The balance transaction associated with this transfer reversal.
created	INT64	Timestamp representing when the transfer reversal was created.
currency	STRING	The currency of the transfer reversal amount.
destination_payment_refund	STRING	The ID of the payment refund to which this transfer reversal is linked.
id	STRING	Unique identifier for the transfer reversal.
object	STRING	Indicates the object type, which should be ‘transfer_reversal’.
source_refund	STRING	The ID of the refund on the source transfer that created this reversal.
transfer	STRING	The ID of the transfer for which this is a reversal.
… and 1 more columns

transfers (29 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
reversals__object	STRING	The object type, in this case, ‘list’
reversals__has_more	BOOL	Indicates if there are more reversals to retrieve
reversals__total_count	FLOAT64	Total count of reversals
reversals__url	STRING	URL to retrieve all reversals for the transfer
id	STRING	The unique identifier of the transfer
statement_description	STRING	The description appearing on the recipient’s bank statement
amount	INT64	The amount of the transfer
balance_transaction	STRING	The balance transaction associated with the transfer
reversed	BOOL	Indicates if the transfer was fully or partially reversed
… and 19 more columns

Nested subtables

Repeating fields are split into their own tables, listed here with their column counts.

• transfers__reversals__data (4 columns)

usage_records (10 columns)

Column	Type	Description
_kaivo_id	STRING	Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id	STRING	The unique identifier for the usage record
invoice	STRING	The ID of the invoice associated with this usage record
livemode	BOOL	Indicates whether this usage record is in live mode or test mode
object	STRING	Represents the type of object, in this case, ‘usage_record’
period__start	INT64	The start date of the usage period
period__end	INT64	The end date of the usage period
subscription_item	STRING	The item within the subscription that this usage record is associated with
total_usage	INT64	The total quantity of units used for this usage record
_kaivo_extracted_at	TIMESTAMP	Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

How the Stripe sync works

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Stripe supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

Frequently asked questions

How long does the initial sync take for Stripe?

It depends on how much history is in your Stripe account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Can I sync only some tables or columns?

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Stripe’s schema changes?

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Stripe, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Stripe instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Stripe connector in Kaivo and all of its synced data is deleted with it.

Common use cases for Stripe data

Revenue and MRR tracking

Combine invoices, invoice_items, and subscriptions to track recurring revenue, expansion, and contraction month over month.

Churn and retention

Analyse customers alongside their subscriptions and invoices to measure churn, surface at-risk accounts, and track lifetime value.

Payout reconciliation

Join balance_transactions and payouts to reconcile gross charges, Stripe fees, and net bank deposits down to the transaction.

Dispute monitoring

Track disputes against charges over time to monitor chargeback and win rates and the revenue at risk from fraud.

Failed payment analysis

Use charges and payment_intents to surface declined payments and failure reasons, so you can recover revenue and tune retry logic.

Use Stripe data in your AI and BI tools

Once Stripe data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Stripe data.

Claude

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Power BI

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Data Studio

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

Tableau

The premium analytics standard, with native BigQuery integration. Setup guide →

Google Sheets

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Excel

Connect via Power Query’s BigQuery connector. Setup guide →

Metabase

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Stripe connector pricing and plan details.

Related connectors

• Chargebee: Sync Chargebee to BigQuery.
• ChartMogul: Sync ChartMogul to BigQuery.
• Fennoa: Sync Fennoa to BigQuery.
• Fortnox: Sync Fortnox to BigQuery.
• FreshBooks: Sync FreshBooks to BigQuery.
• PayPal Enterprise Payments: Sync PayPal Enterprise Payments to BigQuery.