Skip to content
Book a demoStart free
Connectors

Paystack connector

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

Paystack connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Paystack 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 Paystack payment data into BigQuery with Kaivo to analyse transactions, subscriptions, and disputes alongside the rest of your finance data.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Paystack connector

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

Field Description
Secret Key
The Paystack API key (usually starts with ‘sk_live_’; find yours here).

|

When you set up the connector, you provide:

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

|

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

customers (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
customer_code STRING
domain STRING
email STRING
first_name STRING
id INT64
integration INT64
last_name STRING
phone STRING
risk_action STRING
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
disputes (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
attachments STRING
bin STRING
category STRING
created_at TIMESTAMP
currency STRING
domain STRING
due_at TIMESTAMP
evidence STRING
id INT64
last4 STRING
note STRING
refund_amount INT64
resolution STRING
resolved_at TIMESTAMP
status STRING
transaction_reference 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.
by STRING
created_at TIMESTAMP
status 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.
body STRING
created_at TIMESTAMP
sender STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount INT64
created_at TIMESTAMP
currency STRING
description STRING
domain STRING
due_date TIMESTAMP
has_invoice BOOL
id INT64
integration INT64
invoice_number INT64
offline_reference STRING
paid BOOL
paid_at TIMESTAMP
pdf_url STRING
request_code STRING
status 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.
amount INT64
name STRING
quantity 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.
channel STRING
sent_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.
amount INT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
refunds (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount INT64
created_at TIMESTAMP
currency STRING
customer_note STRING
deducted_amount INT64
domain STRING
fully_deducted INT64
id INT64
integration INT64
merchant_note STRING
refunded_at TIMESTAMP
refunded_by STRING
status STRING
transaction INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
settlements (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP
deductions INT64
domain STRING
effective_amount INT64
id INT64
integration INT64
settled_by STRING
settlement_date TIMESTAMP
status STRING
total_amount INT64
total_fees INT64
total_processed INT64
updated_at TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subscriptions (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount INT64
created_at TIMESTAMP
cron_expression STRING
domain STRING
email_token STRING
id INT64
integration INT64
invoice_limit INT64
next_payment_date TIMESTAMP
open_invoice STRING
payments_count INT64
quantity INT64
split_code STRING
start INT64
status STRING
subscription_code STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transactions (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__referrer STRING
amount INT64
channel STRING
created_at TIMESTAMP
created_at TIMESTAMP
currency STRING
domain STRING
fees INT64
fees_split STRING
gateway_response STRING
id INT64
ip_address STRING
log__attempts INT64
log__errors INT64
log__mobile BOOL
log__start_time INT64
log__success BOOL
log__time_spent INT64
message STRING
order_id INT64
paid_at TIMESTAMP
paid_at TIMESTAMP
reference STRING
requested_amount INT64
source__type STRING
source__entry_point STRING
source__identifier STRING
source__source STRING
status 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
message STRING
time 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transfers (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
amount INT64
created_at TIMESTAMP
currency STRING
domain STRING
id INT64
integration INT64
reason STRING
reference STRING
recipient__type STRING
recipient__active BOOL
recipient__created_at TIMESTAMP
recipient__currency STRING
recipient__description STRING
recipient__details__account_name STRING
recipient__details__account_number STRING
recipient__details__bank_code STRING
recipient__details__bank_name STRING
recipient__domain STRING
recipient__id INT64
recipient__integration INT64
recipient__name STRING
recipient__recipient_code STRING
recipient__updated_at TIMESTAMP
source STRING
status STRING
transfer_code STRING
updated_at TIMESTAMP
_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 Paystack 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 Paystack?

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

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

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

Use transactions and settlements to track payment volume and payouts over time.

Bring subscriptions into BigQuery to monitor recurring revenue and churn.

Use disputes and refunds to watch chargeback and refund rates.

Join transactions with customers to measure repeat payments and lifetime value.

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