Skip to content
Book a demoStart free
Connectors

Recharge connector

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

Recharge connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Recharge 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 e-commerce data instead of moving it.

Sync your Recharge subscriptions, customers, and charges into BigQuery with Kaivo to analyse recurring revenue and retention alongside the rest of your data.

CategoryE-commerce
AuthenticationAPI key
SetupSelf-service

Getting started with the Recharge connector

Section titled “Getting started with the Recharge connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Recharge 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.

Authenticate with your Access Token.

Field Description
Access Token
The Access Token for the Recharge API.

|

When you set up the connector, you provide:

Field Description
Start Date
Any data before this date will not be fetched.

|

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

addresses (22 columns), Addresses Stream: https://developer.rechargepayments.com/2021-11/addresses/list_addresses
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
address1 STRING
address2 STRING
cart_note STRING
city STRING
company STRING
country STRING
customer_id INT64
created_at TIMESTAMP
discount_id INT64
first_name STRING
last_name STRING
phone STRING
province STRING
updated_at TIMESTAMP
zip STRING
country_code STRING
order_note STRING
payment_method_id INT64
presentment_currency STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: addresses__shipping_lines_override

Section titled “Subtable: addresses__shipping_lines_override”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
price STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: addresses__shipping_lines_conserved

Section titled “Subtable: addresses__shipping_lines_conserved”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
code STRING
price STRING
title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
bundle_selections (9 columns), Bundle Selections Stream: https://developer.rechargepayments.com/2021-11/bundle_selections/bundle_selection_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
bundle_variant INT64
purchase_item_id INT64
created_at TIMESTAMP
external_product_id STRING
external_variant_id STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
collection_id STRING
collection_source STRING
created_at TIMESTAMP
external_product_id STRING
external_variant_id STRING
price STRING
quantity INT64
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
charges (89 columns), Charges Stream: https://developer.rechargepayments.com/2021-11/charges/charge_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
address_id INT64
billing_address__id INT64
billing_address__address1 STRING
billing_address__address2 STRING
billing_address__cart_note STRING
billing_address__city STRING
billing_address__company STRING
billing_address__country STRING
billing_address__country_code STRING
billing_address__customer_id INT64
billing_address__created_at TIMESTAMP
billing_address__discount_id INT64
billing_address__first_name STRING
billing_address__last_name STRING
billing_address__phone STRING
billing_address__province STRING
billing_address__updated_at TIMESTAMP
billing_address__zip STRING
charge_attempts INT64
currency STRING
customer__email STRING
customer__external_customer_id__ecommerce STRING
customer__hash STRING
customer__id INT64
external_order_id__ecommerce STRING
external_transaction_id__payment_processor STRING
external_variant_id_not_found BOOL
external_variant_not_found BOOL
has_uncommitted_changes BOOL
last_charge_attempt TIMESTAMP
merged_at TIMESTAMP
orders_count INT64
payment_processor STRING
total_duties STRING
total_weight_grams INT64
taxable BOOL
taxes_included BOOL
created_at TIMESTAMP
customer_hash STRING
customer_id INT64
email STRING
error STRING
error_type STRING
first_name STRING
last_name STRING
last_charge_attempt_date TIMESTAMP
has_uncommited_changes BOOL
note STRING
number_times_tried INT64
processed_at TIMESTAMP
processor_name STRING
retry_date TIMESTAMP
scheduled_at STRING
shipments_count INT64
shipping_address__id INT64
shipping_address__address1 STRING
shipping_address__address2 STRING
shipping_address__cart_note STRING
shipping_address__city STRING
shipping_address__company STRING
shipping_address__country STRING
shipping_address__country_code STRING
shipping_address__customer_id INT64
shipping_address__created_at TIMESTAMP
shipping_address__discount_id INT64
shipping_address__first_name STRING
shipping_address__last_name STRING
shipping_address__phone STRING
shipping_address__province STRING
shipping_address__updated_at TIMESTAMP
shipping_address__zip STRING
shopify_order_id STRING
shopify_variant_id_not_found STRING
status STRING
subtotal_price STRING
tags STRING
tax_lines STRING
total_discounts STRING
total_line_items_price STRING
total_price STRING
total_refunds STRING
total_tax STRING
total_weight INT64
transaction_id STRING
type STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: charges__billing_address__note_attributes

Section titled “Subtable: charges__billing_address__note_attributes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: charges__billing_address__shipping_lines_override

Section titled “Subtable: charges__billing_address__shipping_lines_override”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
code STRING
value INT64
value_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: charges__shipping_address__note_attributes

Section titled “Subtable: charges__shipping_address__note_attributes”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: charges__shipping_address__shipping_lines_override

Section titled “Subtable: charges__shipping_address__shipping_lines_override”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
collections (10 columns), Collections Stream: https://developer.rechargepayments.com/2021-11/collections/collections_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
description STRING
title STRING
type STRING
created_at TIMESTAMP
updated_at TIMESTAMP
sort_order STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
credit_adjustments (11 columns), Credit Adjustments Stream: https://developer.rechargepayments.com/2021-11/credits/credit_adjustment_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
credit_account_id INT64
amount STRING
created_at TIMESTAMP
currency_code STRING
ending_balance STRING
note STRING
type STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (38 columns), Customers Stream: https://developer.rechargepayments.com/2021-11/customers/customers_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
accepts_marketing INT64
billing_address1 STRING
billing_address2 STRING
billing_city STRING
billing_company STRING
billing_country STRING
billing_first_name STRING
billing_last_name STRING
billing_phone STRING
billing_province STRING
billing_zip STRING
created_at TIMESTAMP
email STRING
first_charge_processed_at TIMESTAMP
first_name STRING
has_card_error_in_dunning BOOL
has_valid_payment_method BOOL
hash STRING
last_name STRING
number_active_subscriptions INT64
number_subscriptions INT64
processor_type STRING
reason_payment_method_not_valid STRING
shopify_customer_id STRING
status STRING
stripe_customer_token STRING
updated_at TIMESTAMP
apply_credit_to_next_recurring_charge BOOL
apply_credit_to_next_checkout_charge BOOL
external_customer_id__ecommerce STRING
has_payment_method_in_dunning BOOL
phone STRING
subscriptions_active_count INT64
subscriptions_total_count INT64
tax_exempt BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
discounts (28 columns), Discounts Stream: https://developer.rechargepayments.com/2021-11/discounts/discounts_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
applies_to STRING
applies_to_id INT64
applies_to_product_type STRING
applies_to_resource STRING
channel_settings__api__can_apply BOOL
channel_settings__checkout_page__can_apply BOOL
channel_settings__customer_portal__can_apply BOOL
channel_settings__merchant_portal__can_apply BOOL
code STRING
created_at TIMESTAMP
discount_type STRING
duration STRING
duration_usage_limit INT64
ends_at TIMESTAMP
external_discount_id STRING
external_discount_source STRING
first_time_customer_restriction STRING
once_per_customer BOOL
prerequisite_subtotal_min FLOAT64
starts_at TIMESTAMP
status STRING
times_used FLOAT64
updated_at TIMESTAMP
usage_limit FLOAT64
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (15 columns), Events Stream: https://developer.rechargepayments.com/2021-11/events/events_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
customer_id INT64
object_id INT64
created_at TIMESTAMP
description STRING
object_type STRING
source__account_id INT64
source__api_token_id INT64
source__account_email STRING
source__api_token_name STRING
source__origin STRING
source__user_type STRING
verb STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
metafields (12 columns), Metafields Stream: https://developer.rechargepayments.com/2021-11/metafields
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created_at TIMESTAMP
description STRING
key STRING
namespace STRING
owner_id STRING
owner_resource STRING
updated_at TIMESTAMP
value STRING
value_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
onetimes (17 columns), Onetimes Stream: https://developer.rechargepayments.com/2021-11/onetimes/onetimes_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
address_id STRING
created_at TIMESTAMP
customer_id STRING
next_charge_scheduled_at TIMESTAMP
price STRING
product_title STRING
quantity INT64
recharge_product_id INT64
shopify_product_id INT64
shopify_variant_id INT64
sku STRING
status STRING
updated_at TIMESTAMP
variant_title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payment_methods (24 columns), Payment Methods Stream: https://developer.rechargepayments.com/2021-11/payment_methods/payment_methods_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_address__address1 STRING
billing_address__address2 STRING
billing_address__city STRING
billing_address__company STRING
billing_address__country STRING
billing_address__country_code STRING
billing_address__first_name STRING
billing_address__last_name STRING
billing_address__phone STRING
billing_address__province STRING
billing_address__zip STRING
created_at TIMESTAMP
customer_id FLOAT64
default BOOL
id FLOAT64
payment_details JSON
payment_type STRING
processor_customer_token STRING
processor_name STRING
processor_payment_method_token STRING
status STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
plans (24 columns), Plans Stream: https://developer.rechargepayments.com/2021-11/plans/plans_list
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
channel_settings__api__display BOOL
channel_settings__checkout_page__display BOOL
channel_settings__customer_portal__display BOOL
channel_settings__merchant_portal__display BOOL
created_at TIMESTAMP
deleted_at TIMESTAMP
discount_amount INT64
discount_type STRING
external_product_id__ecommerce STRING
sort_order INT64
subscription_preferences__charge_interval_frequency INT64
subscription_preferences__cutoff_day_of_month INT64
subscription_preferences__cutoff_day_of_week INT64
subscription_preferences__expire_after_specific_number_of_charges INT64
subscription_preferences__interval_unit STRING
subscription_preferences__order_day_of_month INT64
subscription_preferences__order_day_of_week INT64
subscription_preferences__order_interval_frequency INT64
title STRING
type STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
shop (3 columns), Shop Stream: https://developer.rechargepayments.com/v1-shopify?python#shop Shop endpoint is not available in 2021-11 API version
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
address_id INT64
cancellation_reason STRING
cancellation_reason_comments STRING
cancelled_at TIMESTAMP
charge_interval_frequency STRING
created_at TIMESTAMP
commit_update BOOL
customer_id INT64
email STRING
expire_after_specific_number_of_charges INT64
external_product_id__ecommerce STRING
external_variant_id__ecommerce STRING
presentment_currency STRING
has_queued_charges INT64
is_prepaid BOOL
is_skippable BOOL
is_swappable BOOL
max_retries_reached INT64
next_charge_scheduled_at STRING
order_day_of_month INT64
order_day_of_week INT64
order_interval_frequency STRING
order_interval_unit STRING
price FLOAT64
product_title STRING
quantity INT64
recharge_product_id INT64
shopify_product_id INT64
shopify_variant_id INT64
sku STRING
sku_override BOOL
status STRING
updated_at TIMESTAMP
variant_title STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Recharge 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.

How long does the initial sync take for Recharge?

Section titled “How long does the initial sync take for Recharge?”

It depends on how much history is in your Recharge 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.

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 Recharge’s schema changes?

Section titled “What happens when Recharge’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 Recharge, 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?

Section titled “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 Recharge 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 Recharge connector in Kaivo and all of its synced data is deleted with it.

Track subscriptions and charges to monitor recurring revenue and growth over time.

Analyse cancellations to measure churn and find at-risk customers.

Combine customers with their charges to measure lifetime value.

Join Recharge data with your store orders in BigQuery for a full revenue picture.

Once Recharge 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 Recharge data.

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

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

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

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

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

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

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

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