Skip to content
Book a demoStart free
Connectors

Lago connector

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

Lago connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Lago 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 Lago billing data into BigQuery with Kaivo to analyse usage-based billing, subscriptions, and revenue.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Lago 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 Lago API key. Find it in your Lago account under API keys.

|

When you set up the connector, you provide:

Field Description
API URL
Base URL for the Lago API. Change this only for self-hosted Lago instances.

|

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

add_ons (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
amount_cents FLOAT64
amount_currency STRING
code STRING
created_at STRING
lago_id 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.
billable_metrics (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active_subscriptions_count FLOAT64
aggregation_type STRING
code STRING
created_at STRING
draft_invoices_count FLOAT64
field_name STRING
lago_id STRING
name STRING
plans_count FLOAT64
recurring BOOL
_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.
coupons (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_cents FLOAT64
amount_currency STRING
code STRING
coupon_type STRING
created_at STRING
expiration STRING
expiration_at STRING
frequency STRING
lago_id STRING
limited_billable_metrics BOOL
limited_plans BOOL
name STRING
percentage_rate STRING
reusable BOOL
terminated_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.
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.
customer_usage (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_cents FLOAT64
currency STRING
customer_id STRING
from_datetime STRING
issuing_date STRING
subscription_id STRING
taxes_amount_cents FLOAT64
to_datetime STRING
total_amount_cents 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.
amount_cents FLOAT64
amount_currency STRING
billable_metric__aggregation_type STRING
billable_metric__code STRING
billable_metric__lago_id STRING
billable_metric__name STRING
charge__charge_model STRING
charge__lago_id STRING
events_count FLOAT64
units STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_usage__charges_usage__filters

Section titled “Subtable: customer_usage__charges_usage__filters”
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: customer_usage__charges_usage__grouped_usage

Section titled “Subtable: customer_usage__charges_usage__grouped_usage”
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.
customer_usage_past (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_cents FLOAT64
currency STRING
customer_id STRING
from_datetime STRING
issuing_date STRING
lago_invoice_id STRING
subscription_id STRING
taxes_amount_cents FLOAT64
to_datetime STRING
total_amount_cents FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: customer_usage_past__charges_usage

Section titled “Subtable: customer_usage_past__charges_usage”
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.
customers (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_type STRING
address_line1 STRING
applicable_timezone STRING
billing_configuration__payment_provider STRING
billing_configuration__payment_provider_code STRING
city STRING
country STRING
created_at STRING
currency STRING
email STRING
external_id STRING
finalize_zero_amount_invoice STRING
lago_id STRING
legal_name STRING
legal_number STRING
name STRING
phone STRING
sequential_id FLOAT64
skip_invoice_custom_sections BOOL
slug STRING
state STRING
updated_at STRING
zipcode 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: customers__billing_configuration__provider_payment_methods

Section titled “Subtable: customers__billing_configuration__provider_payment_methods”
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.

Subtable: customers__integration_customers

Section titled “Subtable: customers__integration_customers”
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.
fees (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount_cents FLOAT64
amount_currency STRING
amount_details__plan_amount_cents FLOAT64
created_at STRING
external_customer_id STRING
external_subscription_id STRING
from_date STRING
invoiceable BOOL
item__type STRING
item__description STRING
item__code STRING
item__invoice_display_name STRING
item__item_type STRING
item__lago_item_id STRING
item__name STRING
lago_customer_id STRING
lago_id STRING
lago_invoice_id STRING
lago_subscription_id STRING
pay_in_advance BOOL
payment_status STRING
precise_amount STRING
precise_coupons_amount_cents STRING
precise_total_amount STRING
precise_unit_amount STRING
self_billed BOOL
taxes_amount_cents FLOAT64
taxes_precise_amount STRING
taxes_rate FLOAT64
to_date STRING
total_amount_cents FLOAT64
total_amount_currency STRING
units 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.
invoices (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
coupons_amount_cents FLOAT64
created_at STRING
credit_notes_amount_cents FLOAT64
currency STRING
customer__account_type STRING
customer__address_line1 STRING
customer__applicable_timezone STRING
customer__billing_configuration__payment_provider STRING
customer__billing_configuration__payment_provider_code STRING
customer__city STRING
customer__country STRING
customer__created_at STRING
customer__currency STRING
customer__email STRING
customer__external_id STRING
customer__finalize_zero_amount_invoice STRING
customer__lago_id STRING
customer__legal_name STRING
customer__legal_number STRING
customer__name STRING
customer__phone STRING
customer__sequential_id FLOAT64
customer__skip_invoice_custom_sections BOOL
customer__slug STRING
customer__state STRING
customer__updated_at STRING
customer__zipcode STRING
fees_amount_cents FLOAT64
file_url STRING
invoice_type STRING
issuing_date STRING
lago_id STRING
net_payment_term FLOAT64
number STRING
payment_due_date STRING
payment_overdue BOOL
payment_status STRING
prepaid_credit_amount_cents FLOAT64
progressive_billing_credit_amount_cents FLOAT64
self_billed BOOL
sequential_id FLOAT64
status STRING
sub_total_excluding_taxes_amount_cents FLOAT64
sub_total_including_taxes_amount_cents FLOAT64
taxes_amount_cents FLOAT64
total_amount_cents FLOAT64
total_due_amount_cents FLOAT64
updated_at STRING
version_number 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.
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: invoices__customer__billing_configuration__provider_payment_methods

Section titled “Subtable: invoices__customer__billing_configuration__provider_payment_methods”
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.

Subtable: invoices__customer__integration_customers

Section titled “Subtable: invoices__customer__integration_customers”
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.
plans (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
active_subscriptions_count FLOAT64
amount_cents FLOAT64
amount_currency STRING
code STRING
created_at STRING
customers_count FLOAT64
draft_invoices_count FLOAT64
interval STRING
lago_id STRING
name STRING
pay_in_advance BOOL
trial_period 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.
billable_metric_code STRING
charge_model STRING
created_at STRING
invoiceable BOOL
lago_billable_metric_id STRING
lago_id STRING
min_amount_cents FLOAT64
pay_in_advance BOOL
properties__amount STRING
prorated BOOL
_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.
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.
subscriptions (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
billing_time STRING
created_at STRING
current_billing_period_ending_at STRING
current_billing_period_started_at STRING
external_customer_id STRING
external_id STRING
lago_customer_id STRING
lago_id STRING
name STRING
plan_code STRING
started_at STRING
status STRING
subscription_at STRING
trial_ended_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
wallets (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
balance_cents FLOAT64
consumed_credits STRING
created_at STRING
credits_balance STRING
credits_ongoing_balance STRING
credits_ongoing_usage_balance STRING
currency STRING
external_customer_id STRING
invoice_requires_successful_payment BOOL
lago_customer_id STRING
lago_id STRING
last_balance_sync_at STRING
last_consumed_credit_at STRING
name STRING
ongoing_balance_cents FLOAT64
ongoing_usage_balance_cents FLOAT64
rate_amount STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: wallets__recurring_transaction_rules

Section titled “Subtable: wallets__recurring_transaction_rules”
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 Lago 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 Lago?

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

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

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

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

Join billable_metrics with customer_usage and fees to analyse usage-based charges.

Use customers and wallets to measure balances and lifetime value.

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