Stripe connector

Set up the Stripe connector in Kaivo: authentication, configuration, the 47 BigQuery tables it syncs, and answers to common questions.

Written By Lauri Raivio

Last updated 16 days ago

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

Sign up for Kaivo and create a workspace.
Connect your Stripe account.
Choose which tables to sync.
Wait for the initial sync to finish.
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.

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.

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.

Was this helpful?

Still need help? Share an idea

What is the Stripe connector

Getting started with the Stripe connector

Authenticating Stripe

Configuring the Stripe connector

Tables and columns synced from Stripe

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

How the Stripe sync works

Frequently asked questions

How long does the initial sync take for Stripe?

Can I sync only some tables or columns?

What happens when Stripe's schema changes?

How do I handle GDPR or data deletion requests?

Common use cases for Stripe data

Revenue and MRR tracking

Churn and retention

Payout reconciliation

Dispute monitoring

Failed payment analysis

Use Stripe data in your AI and BI tools

Claude

Power BI

Data Studio

Tableau

Google Sheets

Excel

Metabase

Related connectors