Skip to content
Book a demoStart free
Connectors

Countercyclical connector

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

Countercyclical connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Countercyclical 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 Countercyclical investments, valuations, and memos into BigQuery with Kaivo to track your portfolio and research in one place.

CategoryFinance & Payments
AuthenticationAPI key
SetupSelf-service

Getting started with the Countercyclical connector

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

Tables and columns synced from Countercyclical

Section titled “Tables and columns synced from Countercyclical”

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

Investments (88 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
address STRING
banner_image STRING
ceo STRING
cik STRING
clearbit__type STRING
clearbit__description STRING
clearbit__category__gics_code STRING
clearbit__category__industry STRING
clearbit__category__industry_group STRING
clearbit__category__naics_code STRING
clearbit__category__sector STRING
clearbit__category__sic_code STRING
clearbit__category__sub_industry STRING
clearbit__crunchbase__handle STRING
clearbit__domain STRING
clearbit__email_provider BOOL
clearbit__facebook__handle STRING
clearbit__facebook__likes FLOAT64
clearbit__founded_year FLOAT64
clearbit__geo__city STRING
clearbit__geo__country STRING
clearbit__geo__country_code STRING
clearbit__geo__lat FLOAT64
clearbit__geo__lng FLOAT64
clearbit__geo__postal_code STRING
clearbit__geo__state STRING
clearbit__geo__state_code STRING
clearbit__geo__street_address STRING
clearbit__geo__street_name STRING
clearbit__geo__street_number STRING
clearbit__id STRING
clearbit__identifiers__us_cik STRING
clearbit__identifiers__us_ein STRING
clearbit__indexed_at STRING
clearbit__legal_name STRING
clearbit__linkedin__handle STRING
clearbit__location STRING
clearbit__logo STRING
clearbit__metrics__alexa_global_rank FLOAT64
clearbit__metrics__alexa_us_rank FLOAT64
clearbit__metrics__annual_revenue FLOAT64
clearbit__metrics__employees FLOAT64
clearbit__metrics__employees_range STRING
clearbit__metrics__estimated_annual_revenue STRING
clearbit__metrics__fiscal_year_end FLOAT64
clearbit__metrics__market_cap FLOAT64
clearbit__metrics__traffic_rank STRING
clearbit__name STRING
clearbit__phone STRING
clearbit__ticker STRING
clearbit__time_zone STRING
clearbit__twitter__avatar STRING
clearbit__twitter__bio STRING
clearbit__twitter__followers FLOAT64
clearbit__twitter__following FLOAT64
clearbit__twitter__handle STRING
clearbit__twitter__id STRING
clearbit__twitter__location STRING
clearbit__twitter__site STRING
clearbit__utc_offset FLOAT64
country STRING
created_at STRING
edited_name STRING
employees FLOAT64
exchange STRING
figi STRING
financing_type STRING
founding_date STRING
headquarters STRING
id STRING
industry STRING
ipo_date STRING
is_archived BOOL
is_favorite BOOL
is_locked BOOL
issuance STRING
lei STRING
market_type STRING
name STRING
sector STRING
ticker_symbol STRING
updated_at STRING
visibility STRING
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: Investments__clearbit__category__naics6_codes

Section titled “Subtable: Investments__clearbit__category__naics6_codes”
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: Investments__clearbit__category__naics6_codes2022

Section titled “Subtable: Investments__clearbit__category__naics6_codes2022”
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: Investments__clearbit__category__sic4_codes

Section titled “Subtable: Investments__clearbit__category__sic4_codes”
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: Investments__clearbit__domain_aliases

Section titled “Subtable: Investments__clearbit__domain_aliases”
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: Investments__clearbit__site__email_addresses

Section titled “Subtable: Investments__clearbit__site__email_addresses”
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: Investments__clearbit__site__phone_numbers

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

Section titled “Subtable: Investments__clearbit__tech_categories”
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.
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.
Memos (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
archived BOOL
avatar STRING
background_color STRING
banner STRING
banner_visible BOOL
body STRING
created_at STRING
document_type STRING
emoji STRING
favorited BOOL
foreground_color STRING
icon STRING
id STRING
locked BOOL
publicly_visible BOOL
sources_visible BOOL
title STRING
toc_visible BOOL
updated_at STRING
views FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Valuations (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
background_color STRING
created_at STRING
delineation STRING
discount_rate STRING
emoji STRING
ending_quarter STRING
ending_year STRING
growth_metric STRING
growth_rate STRING
id STRING
is_favorite BOOL
name STRING
share_token STRING
starting_quarter STRING
starting_year STRING
status STRING
terminal_period FLOAT64
terminal_rate 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.
line_item STRING
value FLOAT64
year 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 Countercyclical 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 Countercyclical?

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

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

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

Use Valuations with discountRate and quarter fields to follow how your valuations change over time.

Report on Investments by country and sector to see your holdings at a glance.

Bring Memos into BigQuery to search and reference your investment write-ups.

Join Investments with Valuations to see the analysis behind each position.

Use Countercyclical data in your AI and BI tools

Section titled “Use Countercyclical data in your AI and BI tools”

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