Load Stripe data into BigQuery

You can load data from Stripe to BigQuery using the Stripe connector with the BigQuery Data Transfer Service. By using the Stripe connector, you can schedule recurring transfer jobs that add your latest data from Stripe to BigQuery.

Limitations

Stripe data transfers are subject to the following limitations:

• A Stripe data transfer loads currencies according to Stripe's minor units. For more information, see Minor units in API amounts.
• The Stripe connector only transfers pre-generated reports for each Stripe account. The Stripe connector doesn't generate new reports based on new Stripe data.
  • To transfer up-to-date reports, generate the reports manually in the Stripe dashboard before starting the Stripe data transfer.
  • For more information, see Stripe reporting.
• The Stripe connector doesn't support webhook-based events, real-time updates, or Stripe Sigma.
• Stripe data transfers from Stripe regions that are in preview might encounter issues with data transfers:
  • Filtering options are restricted or unavailable in Stripe preview regions.
  • Conditional data transfers and queries aren't supported in Stripe preview regions.
  • You might encounter long data transfer runtimes when transferring data from Stripe preview regions.
• The Stripe connector supports some objects with the StartDate filter.
  • The required format for the StartDate filter is YYYY-MM-DD. If no start date is provided, the connector defaults to three years before the current date. If a date before January 1, 2011 is provided, then the connector automatically uses January 1, 2011.
  • For a list of supported objects, see Objects with StartDate filter support.
• A single transfer configuration can only support one data transfer run at a given time. If a second data transfer is scheduled to run before the first transfer is completed, then only the first data transfer completes while any other data transfers that overlap with the first transfer is skipped.
  • To avoid skipped transfers within a single transfer configuration, we recommend that you increase the duration of time between large data transfers by configuring the Repeat frequency.

Before you begin

The following sections describe the steps that you need to take before you create a Stripe data transfer.

Stripe prerequisites

• You must have a Stripe developer account to authorize a Stripe data transfer. To register a Stripe account, see Stripe registration.
• Configure your Stripe platform application with the following steps:
  1. Navigate to the Developers section in the Stripe dashboard.
  2. Under Connect, configure your platform to support Standard and Express accounts.
• The following information is needed to create a Stripe data transfer:
  • Note your Stripe account ID. For more information, see Create an account.
  • Note your secret key or restricted key. For more information, see API keys.
• If you plan on transferring data from connected accounts, ensure that your platform is configured for Stripe Connect and has access to the necessary account capabilities. For more information about Stripe Connect, see Platforms and marketplaces with Stripe Connect.
  • For more information about connected accounts, see Connect account types.

Required BigQuery roles

To get the permissions that you need to create a transfer, ask your administrator to grant you the BigQuery Admin (roles/bigquery.admin) IAM role on the project. For more information about granting roles, see Manage access to projects, folders, and organizations.

This predefined role contains the permissions required to create a transfer. To see the exact permissions that are required, expand the Required permissions section:

You might also be able to get these permissions with custom roles or other predefined roles.

BigQuery prerequisites

• Verify that you have completed all actions required to enable the BigQuery Data Transfer Service.
• Create a BigQuery dataset to store your data.
• If you intend to set up transfer run notifications for Pub/Sub, ensure that you have the pubsub.topics.setIamPolicy Identity and Access Management (IAM) permission. Pub/Sub permissions are not required if you only set up email notifications. For more information, see BigQuery Data Transfer Service run notifications.

Stripe account types

The Stripe connector supports both Stripe platform accounts and Stripe connected accounts. For more information, see Connect account types.

Connect to platform accounts

To run a Stripe data transfer from only one platform account, do the following when you set up the transfer configuration:

• Enter the platform account ID for the platform account in the Account Id field.
• Enter the secret or restricted key for the platform account in the Secret/API Key field.
• For SyncAllConnectedAccounts, select False.

To run a Stripe data transfer for multiple accounts, for example, for a platform account linked with connected accounts, do the following when you set up the transfer configuration:

• Enter the platform account ID for the platform account in the Account Id field.
• Enter the secret or restricted key for the platform account in the Secret/API Key field.
• For SyncAllConnectedAccounts, select True.

Connect to connected accounts

Connected accounts are Stripe accounts linked to Stripe using Stripe Connect.

To run a Stripe data transfer from a connected account, do the following when you set up the transfer configuration:

• Enter the platform account ID for the connected account in the Account Id field.
• Enter the secret or restricted key for the platform account to which the connected account is connected to in the Secret/API Key field.
• For SyncAllConnectedAccounts, select False.

Set up a Stripe data transfer

Add Stripe data into BigQuery by setting up a transfer configuration using one of the following options:

bq mk
    --transfer_config
    --project_id=PROJECT_ID
    --data_source=DATA_SOURCE
    --display_name=DISPLAY_NAME
    --target_dataset=DATASET
    --params='PARAMETERS'

  bq mk \
      --transfer_config \
      --target_dataset=mydataset \
      --data_source=stripe \
      --display_name='My Transfer' \
      --params= ' {
  "assets" : [ "Customers" , "Accounts", "BalanceSummaryReport"] ,
  "connector.accountId" : "acct_000000000000",
  "connector.secretKey" : "sk_test_000000000",
  "connector.syncAllConnectedAccounts" : "true",
  "connector.startDate": "2025-05-20"
  }'

To manually run a data transfer outside of your regular schedule, you can start a backfill run.

Data type mapping

The following table maps Stripe data types to the corresponding BigQuery data types.

Objects with StartDate filter support

The following Stripe objects support the StartDate filter, which lets you load time-based data:

• Accounts
• ApplicationFees
• BalanceTransactions
• Cardholders
• Charges
• Coupons
• Customers
• Disputes
• EarlyFraudWarnings
• Events
• FileLinks
• Files
• InvoiceItems
• Invoices
• IssuingCards
• IssuingDisputes
• PaymentIntent
• Payouts
• Plans
• Prices
• Products
• PromotionCodes
• Refunds
• Reviews
• ShippingRates
• Subscriptions
• TaxRates
• TopUps
• Transfers
• ValueListItems
• ValueLists

Troubleshoot transfer setup

If you are having issues setting up your data transfer, see Stripe transfer issues.

Pricing

There is no cost to transfer Stripe data into BigQuery while this feature is in Preview.

What's next

• For an overview of the BigQuery Data Transfer Service, see Introduction to BigQuery Data Transfer Service.
• For information on using transfers including getting information about a transfer configuration, listing transfer configurations, and viewing a transfer's run history, see Working with transfers.
• Learn how to load data with cross-cloud operations.