Skip to content
Book a demoStart free
Connectors

Paddle connector

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

Paddle connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Paddle 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.

Sync your Paddle billing data into BigQuery with Kaivo to analyse subscriptions, transactions, and revenue.

CategoryFinance & Payments, E-commerce
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Paddle 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 API Key.

Field Description
API Key
Your Paddle API key. Navigate to Paddle > Developer tools > Authentication > Generate API key.

|

When you set up the connector, you provide:

Field Description
Environment
The Paddle API environment. Use Live for production and Sandbox for testing.

| | Start Date |

Any data before this date will not be fetched.

|

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

adjustments (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
action STRING
created_at STRING
currency_code STRING
customer_id STRING
id STRING
payout_totals__chargeback_fee__amount STRING
payout_totals__chargeback_fee__original__amount STRING
payout_totals__chargeback_fee__original__currency_code STRING
payout_totals__currency_code STRING
payout_totals__earnings STRING
payout_totals__fee STRING
payout_totals__subtotal STRING
payout_totals__tax STRING
payout_totals__total STRING
reason STRING
status STRING
subscription_id STRING
totals__currency_code STRING
totals__earnings STRING
totals__fee STRING
totals__subtotal STRING
totals__tax STRING
totals__total STRING
transaction_id STRING
updated_at 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.
type STRING
amount STRING
id STRING
item_id STRING
totals__subtotal STRING
totals__tax STRING
totals__total 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.
tax_rate STRING
totals__subtotal STRING
totals__tax STRING
totals__total STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
businesses (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company_number STRING
created_at STRING
customer_id STRING
id STRING
name STRING
status STRING
tax_identifier STRING
updated_at 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.
email STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customer_addresses (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
city STRING
country_code STRING
created_at STRING
customer_id STRING
first_line STRING
id STRING
postal_code STRING
region STRING
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
customers (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
email STRING
id STRING
locale STRING
marketing_consent BOOL
name STRING
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
discounts (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
amount STRING
code STRING
created_at STRING
enabled_for_checkout BOOL
expires_at STRING
id STRING
maximum_recurring_intervals FLOAT64
recur BOOL
status STRING
times_used FLOAT64
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
event_types (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
group STRING
name STRING
uuid 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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (42 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
data__type STRING
data__description STRING
data__amount STRING
data__billing_cycle__frequency FLOAT64
data__billing_cycle__interval STRING
data__city STRING
data__code STRING
data__company_number STRING
data__country_code STRING
data__created_at STRING
data__customer_id STRING
data__email STRING
data__enabled_for_checkout BOOL
data__expires_at STRING
data__first_line STRING
data__id STRING
data__image_url STRING
data__locale STRING
data__marketing_consent BOOL
data__maximum_recurring_intervals FLOAT64
data__name STRING
data__postal_code STRING
data__product_id STRING
data__quantity__maximum FLOAT64
data__quantity__minimum FLOAT64
data__recur BOOL
data__region STRING
data__status STRING
data__tax_category STRING
data__tax_identifier STRING
data__tax_mode STRING
data__trial_period__frequency FLOAT64
data__trial_period__interval STRING
data__trial_period__requires_payment_method BOOL
data__unit_price__amount STRING
data__unit_price__currency_code STRING
data__updated_at STRING
event_id STRING
event_type STRING
occurred_at 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.
email STRING
name 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: events__data__unit_price_overrides

Section titled “Subtable: events__data__unit_price_overrides”
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.
ip_addresses (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
uuid 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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
prices (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
billing_cycle__frequency FLOAT64
billing_cycle__interval STRING
created_at STRING
id STRING
name STRING
product_id STRING
quantity__maximum FLOAT64
quantity__minimum FLOAT64
status STRING
tax_mode STRING
trial_period__frequency FLOAT64
trial_period__interval STRING
unit_price__amount STRING
unit_price__currency_code STRING
updated_at 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.
products (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_at STRING
id STRING
image_url STRING
name STRING
status STRING
tax_category STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
reports (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at STRING
expires_at STRING
id STRING
status STRING
updated_at 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
operator STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
status STRING
customer_id STRING
address_id STRING
business_id STRING
currency_code STRING
created_at STRING
updated_at STRING
started_at STRING
first_billed_at STRING
next_billed_at STRING
paused_at STRING
canceled_at STRING
collection_mode STRING
current_billing_period__starts_at STRING
current_billing_period__ends_at STRING
billing_cycle__frequency FLOAT64
billing_cycle__interval STRING
management_urls__update_payment_method STRING
management_urls__cancel 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.
status STRING
quantity FLOAT64
recurring BOOL
created_at STRING
updated_at STRING
previously_billed_at STRING
next_billed_at STRING
price__type STRING
price__description STRING
price__id STRING
price__product_id STRING
price__name STRING
price__tax_mode STRING
price__billing_cycle__frequency FLOAT64
price__billing_cycle__interval STRING
price__unit_price__amount STRING
price__unit_price__currency_code STRING
price__status STRING
price__quantity__minimum FLOAT64
price__quantity__maximum FLOAT64
price__created_at STRING
price__updated_at STRING
product__type STRING
product__description STRING
product__id STRING
product__name STRING
product__tax_category STRING
product__image_url STRING
product__status STRING
product__created_at STRING
product__updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: subscriptions__items__price__unit_price_overrides

Section titled “Subtable: subscriptions__items__price__unit_price_overrides”
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.
transactions (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
status STRING
customer_id STRING
address_id STRING
business_id STRING
origin STRING
collection_mode STRING
subscription_id STRING
invoice_id STRING
invoice_number STRING
currency_code STRING
discount_id STRING
created_at STRING
updated_at STRING
billed_at STRING
revised_at STRING
checkout__url 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.
quantity FLOAT64
_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.

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

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

It depends on how much history is in your Paddle 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 Paddle’s schema changes?

Section titled “What happens when Paddle’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 Paddle, 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 Paddle 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 Paddle connector in Kaivo and all of its synced data is deleted with it.

Use subscriptions and transactions to track recurring revenue and churn over time.

Join transactions with adjustments and discounts to reconcile revenue.

Use customers and businesses to measure lifetime value.

Use products and prices to see what drives revenue.

Once Paddle 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 Paddle 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 Paddle connector pricing and plan details.