Skip to content
Book a demoStart free
Connectors

SimFin connector

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

SimFin connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your SimFin 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 SimFin company fundamentals, financial statements, and prices into BigQuery with Kaivo to analyse company financials and market data.

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

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

common_shares_outstanding (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
end_date STRING
pid FLOAT64
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
companies (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id FLOAT64
industry_name STRING
isin STRING
name STRING
sector_code FLOAT64
sector_name STRING
ticker STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Company Info (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company_description STRING
end_fy FLOAT64
id FLOAT64
industry_name STRING
isin STRING
market STRING
name STRING
num_employees FLOAT64
sector_code FLOAT64
sector_name STRING
ticker STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
filings_by_company (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company__id FLOAT64
company__industry_name STRING
company__isin STRING
company__name STRING
company__sector_code FLOAT64
company__sector_name STRING
company__ticker STRING
filing_date STRING
filing_identifier STRING
filing_type STRING
fyear FLOAT64
period STRING
source_link STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
filings_list (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company__id FLOAT64
company__industry_name STRING
company__isin STRING
company__name STRING
company__sector_code FLOAT64
company__sector_name STRING
company__ticker STRING
filing_date STRING
filing_identifier STRING
filing_type STRING
fyear FLOAT64
period STRING
source_link STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Financial Statements (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
statement 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.
data_model FLOAT64
included_in_bulk_download BOOL
value_check 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.
abnormal_gains_lossesx FLOAT64
accounts_notes_receivable FLOAT64
accounts_payable FLOAT64
accounts_receivable_net FLOAT64
accrued_taxes FLOAT64
acquisition_of_fixed_assets_intangibles FLOAT64
additional_paid_in_capital FLOAT64
cash_cash_equivalents FLOAT64
cash_from_repayment_of_debt FLOAT64
cash_from_repurchase_of_equity FLOAT64
cash_return_on_invested_capital FLOAT64
cash_from_financing_activities FLOAT64
cash_from_investing_activities FLOAT64
cash_from_operating_activities FLOAT64
cash_cash_equivalents_short_term_investments FLOAT64
change_in_fixed_assets_intangibles FLOAT64
change_in_working_capital FLOAT64
commissions_fees_earned FLOAT64
commissions_fees_paid FLOAT64
common_stock FLOAT64
cost_of_revenue FLOAT64
current_ratio FLOAT64
customer_acceptances_liabilities FLOAT64
data_model FLOAT64
debt_ratio FLOAT64
deferred_revenue_long_termx FLOAT64
deferred_revenue_short_termx FLOAT64
deferred_tax_assets_long_termx FLOAT64
deferred_tax_assets_short_termx FLOAT64
deferred_tax_liabilities_long_termx FLOAT64
deferred_tax_liabilities_short_termx FLOAT64
depreciation_amortization FLOAT64
derivative_hedging_assets_short_termx FLOAT64
dividend_payout_ratio FLOAT64
dividends_paid FLOAT64
dividends_per_share FLOAT64
ebitda FLOAT64
earnings_per_share_basic FLOAT64
earnings_per_share_diluted FLOAT64
effect_of_foreign_exchange_rates FLOAT64
equity_before_minority_interest FLOAT64
equity_per_share FLOAT64
fiscal_period STRING
fiscal_year FLOAT64
foreign_exchange_gain_lossx FLOAT64
free_cash_flow FLOAT64
free_cash_flow_per_share FLOAT64
free_cash_flow_to_net_income FLOAT64
free_cash_flow_to_net_income_adjustedx FLOAT64
general_administrative FLOAT64
goodwill FLOAT64
gross_profit FLOAT64
gross_profit_margin FLOAT64
income_loss_including_minority_interest FLOAT64
income_loss_from_continuing_operations FLOAT64
income_tax_expense_benefit_net FLOAT64
income_taxes_receivable FLOAT64
increase_in_capital_stock FLOAT64
intangible_assets FLOAT64
interest_expense_net FLOAT64
interest_income FLOAT64
investment_income_lossx FLOAT64
liabilities_from_derivatives_hedging_short_termx FLOAT64
liabilities_to_equity_ratio FLOAT64
long_term_capital_leases FLOAT64
long_term_debt FLOAT64
long_term_investments_receivables FLOAT64
minority_interest FLOAT64
miscellaneous_long_term_assets FLOAT64
miscellaneous_long_term_liabilities FLOAT64
miscellaneous_short_term_assets FLOAT64
miscellaneous_short_term_liabilities FLOAT64
net_cash_before_disc_operations_and_fx FLOAT64
net_cash_before_fx FLOAT64
net_cash_from_acquisitions_divestitures FLOAT64
net_cash_from_discontinued_operations_financingx FLOAT64
net_change_in_deposits FLOAT64
net_change_in_investments FLOAT64
net_change_in_loans_interbank FLOAT64
net_change_in_long_term_investment FLOAT64
net_change_in_operating_capital FLOAT64
net_changes_in_cash FLOAT64
net_debt_ebit FLOAT64
net_debt_ebitda FLOAT64
net_fixed_assets FLOAT64
net_income FLOAT64
net_income_adjustedx FLOAT64
net_income_available_to_common_shareholders FLOAT64
net_income_starting_line FLOAT64
net_loans FLOAT64
net_profit_margin FLOAT64
net_profit_margin_adjustedx FLOAT64
net_revenue FLOAT64
net_revenue_after_provisions FLOAT64
net_interest_income FLOAT64
non_cash_items FLOAT64
non_operating_income_lossx FLOAT64
operating_expenses FLOAT64
operating_income_lossx FLOAT64
operating_margin FLOAT64
other_assets FLOAT64
other_equity FLOAT64
other_financing_activities FLOAT64
other_investing_activities FLOAT64
other_liabilities FLOAT64
other_long_term_assets FLOAT64
other_long_term_liabilities FLOAT64
other_non_cash_adjustments FLOAT64
other_non_interest_income FLOAT64
other_non_operating_income_lossx FLOAT64
other_operating_expense FLOAT64
other_payables_accruals FLOAT64
other_short_term_assets FLOAT64
other_short_term_liabilities FLOAT64
payables_accruals FLOAT64
pension_liabilities FLOAT64
preferred_dividends FLOAT64
prepaid_expenses FLOAT64
pretax_income_lossx FLOAT64
pretax_income_loss_adjusted FLOAT64
property_plant_equipment FLOAT64
property_plant_equipment_net FLOAT64
provision_for_loan_losses FLOAT64
publish_date STRING
repayments_of_long_term_debt FLOAT64
report_date STRING
research_development FLOAT64
reserve_for_loan_losses FLOAT64
restated FLOAT64
retained_earnings FLOAT64
return_on_invested_capital FLOAT64
return_on_invested_capital_adjustedx FLOAT64
return_on_assets FLOAT64
return_on_assets_adjustedx FLOAT64
return_on_equity FLOAT64
return_on_equity_adjustedx FLOAT64
revenue FLOAT64
sales_per_share FLOAT64
selling_marketing FLOAT64
selling_general_administrative FLOAT64
share_capital_additional_paid_in_capital FLOAT64
short_term_borrowings_repos FLOAT64
short_term_capital_leases FLOAT64
short_term_debt FLOAT64
short_term_investments FLOAT64
short_and_long_term_investments FLOAT64
source STRING
stock_based_compensation FLOAT64
ttm FLOAT64
total_assets FLOAT64
total_current_assets FLOAT64
total_current_liabilities FLOAT64
total_debt FLOAT64
total_deposits FLOAT64
total_equity FLOAT64
total_interest_expense FLOAT64
total_interest_income FLOAT64
total_liabilities FLOAT64
total_liabilities_equity FLOAT64
total_loans FLOAT64
total_non_interest_expense FLOAT64
total_non_interest_income FLOAT64
total_noncurrent_assets FLOAT64
total_noncurrent_liabilities FLOAT64
treasury_stock FLOAT64
value_check FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Price Data (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
adjusted_closing_price FLOAT64
common_shares_outstanding FLOAT64
date STRING
dividend_paid FLOAT64
highest_price FLOAT64
last_closing_price FLOAT64
lowest_price FLOAT64
opening_price FLOAT64
trading_volume FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
weighted_shares_outstanding (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
basic FLOAT64
diluted FLOAT64
end_date STRING
fyear FLOAT64
period STRING
pid FLOAT64
_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 SimFin 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 SimFin?

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

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

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

Use Financial Statements with Company Info to study revenue, earnings, and margins.

Use Price Data adjusted prices to chart performance over time.

Combine common_shares_outstanding and weighted_shares_outstanding for per-share metrics.

Use filings_by_company to track a company’s disclosures over time.

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