Skip to content
Book a demoStart free
Connectors

Segment connector

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

Segment connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Segment 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 marketing and sales data instead of moving it.

Sync your Segment workspace metadata into BigQuery with Kaivo to audit sources, destinations, and usage across your data pipeline.

CategoryMarketing & Sales, Tech
AuthenticationAPI key
SetupSelf-service

Getting started with the Segment connector

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

Field Description
API Token
API token to use. Generate it in Segment’s Workspace settings.

|

When you set up the connector, you provide:

Field Description
Region
The Segment API region your workspace is hosted in.

| | Start Date |

Any data before this date will not be fetched.

|

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

audit_events (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
catalog_destinations (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
logos__default STRING
logos__mark STRING
name STRING
partner_owned BOOL
slug STRING
status STRING
supported_features__browser_unbundling BOOL
supported_features__browser_unbundling_public BOOL
supported_features__cloud_mode_instances STRING
supported_features__device_mode_instances STRING
supported_features__replay BOOL
supported_methods__alias BOOL
supported_methods__group BOOL
supported_methods__identify BOOL
supported_methods__pageview BOOL
supported_methods__track BOOL
supported_platforms__browser BOOL
supported_platforms__cloud_app_object BOOL
supported_platforms__mobile BOOL
supported_platforms__server BOOL
supported_platforms__warehouse BOOL
website STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • catalog_destinations__actions (10 columns)
  • catalog_destinations__actions__fields (16 columns)
  • catalog_destinations__actions__fields__choices (5 columns)
  • catalog_destinations__categories (4 columns)
  • catalog_destinations__components (6 columns)
  • catalog_destinations__contacts (8 columns)
  • catalog_destinations__options (8 columns)
  • catalog_destinations__options__default_value (4 columns)
  • catalog_destinations__presets (875 columns)
  • catalog_destinations__presets__fields__additional_fields__aarray_path (4 columns)
  • catalog_destinations__presets__fields__addresses__aarray_path (4 columns)
  • catalog_destinations__presets__fields__cart_line__aarray_path (4 columns)
  • catalog_destinations__presets__fields__cart_lines__aarray_path (4 columns)
  • catalog_destinations__presets__fields__checkout_line_items__aarray_path (4 columns)
  • catalog_destinations__presets__fields__collection_product_variants__aarray_path (4 columns)
  • catalog_destinations__presets__fields__companies__aarray_path (4 columns)
  • catalog_destinations__presets__fields__contents__aarray_path (4 columns)
  • catalog_destinations__presets__fields__devices__aarray_path (4 columns)
  • catalog_destinations__presets__fields__discount_applications__aarray_path (4 columns)
  • catalog_destinations__presets__fields__discount_codes__aarray_path (4 columns)
  • catalog_destinations__presets__fields__ecommerce_products__aarray_path (4 columns)
  • catalog_destinations__presets__fields__elements__aarray_path (4 columns)
  • catalog_destinations__presets__fields__email_marketing_consent__aarray_path (4 columns)
  • catalog_destinations__presets__fields__filters__aarray_path (4 columns)
  • catalog_destinations__presets__fields__items__aarray_path (4 columns)
  • catalog_destinations__presets__fields__line_items__aarray_path (4 columns)
  • catalog_destinations__presets__fields__line_items__aarray_path (4 columns)
  • catalog_destinations__presets__fields__metafield__aarray_path (4 columns)
  • catalog_destinations__presets__fields__product_variant__untranslated_title__aif__exists (4 columns)
  • catalog_destinations__presets__fields__products__aarray_path (4 columns)
  • catalog_destinations__presets__fields__search_results__aarray_path (4 columns)
  • catalog_destinations__presets__fields__sms_marketing_consent__aarray_path (4 columns)
  • catalog_destinations__presets__fields__utms__aarray_path (4 columns)
  • catalog_destinations__previous_names (4 columns)
  • catalog_destinations__region_endpoints (4 columns)
  • catalog_destinations__supported_regions (4 columns)
catalog_sources (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
is_cloud_event_source BOOL
logos__alt STRING
logos__default STRING
logos__mark STRING
name STRING
partner_owned BOOL
slug STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • catalog_sources__categories (4 columns)
  • catalog_sources__options (8 columns)
catalog_warehouses (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
id STRING
logos__alt STRING
logos__default STRING
logos__mark STRING
name STRING
slug STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • catalog_warehouses__options (6 columns)
destinations (129 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__description STRING
metadata__id STRING
metadata__logos__default STRING
metadata__logos__mark STRING
metadata__name STRING
metadata__partner_owned BOOL
metadata__slug STRING
metadata__status STRING
metadata__supported_features__browser_unbundling BOOL
metadata__supported_features__browser_unbundling_public BOOL
metadata__supported_features__cloud_mode_instances STRING
metadata__supported_features__device_mode_instances STRING
metadata__supported_features__replay BOOL
metadata__supported_methods__alias BOOL
metadata__supported_methods__group BOOL
metadata__supported_methods__identify BOOL
metadata__supported_methods__pageview BOOL
metadata__supported_methods__track BOOL
metadata__supported_platforms__browser BOOL
metadata__supported_platforms__cloud_app_object BOOL
metadata__supported_platforms__mobile BOOL
metadata__supported_platforms__server BOOL
metadata__supported_platforms__warehouse BOOL
metadata__website STRING
enabled BOOL
id STRING
name STRING
settings__account STRING
settings__account_id STRING
settings__activator STRING
settings__allow_ad_personalization_signals BOOL
settings__allow_google_signals BOOL
settings__anonymize_ip BOOL
settings__api_base STRING
settings__api_key STRING
settings__app_id STRING
settings__automatic_configuration BOOL
settings__classic BOOL
settings__collect_context BOOL
settings__conversion_linker BOOL
settings__cookie_domain STRING
settings__cookie_expiration_in_seconds FLOAT64
settings__cookie_flags STRING
settings__cookie_path STRING
settings__cookie_prefix STRING
settings__cookie_update BOOL
settings__default_ads_storage_consent_state STRING
settings__default_analytics_storage_consent_state STRING
settings__default_page_conversion STRING
settings__disable_ad_personalization BOOL
settings__domain STRING
settings__double_click BOOL
settings__enable_consent_mode BOOL
settings__enable_server_identify BOOL
settings__enhanced_ecommerce BOOL
settings__enhanced_link_attribution BOOL
settings__floodlight_account_id STRING
settings__identify_category STRING
settings__identify_event_name STRING
settings__include_search BOOL
settings__init_with_existing_traits BOOL
settings__is_bulk_api_enabled BOOL
settings__key_for_external_id STRING
settings__limited_data_use BOOL
settings__measurement_id STRING
settings__mobile_api_key STRING
settings__mobile_tracking_id STRING
settings__name_tracker BOOL
settings__non_interaction BOOL
settings__oauth__access_token STRING
settings__oauth__app_id STRING
settings__oauth__app_name STRING
settings__oauth__created_at STRING
settings__oauth__created_by STRING
settings__oauth__display_name STRING
settings__optimize STRING
settings__page_view BOOL
settings__partner_id STRING
settings__pixel_id STRING
settings__prefer_anonymous_id BOOL
settings__report_uncaught_exceptions BOOL
settings__sample_rate FLOAT64
settings__secret_key STRING
settings__send_page_view BOOL
settings__send_user_id BOOL
settings__serverside_classic BOOL
settings__serverside_tracking_id STRING
settings__set_all_mapped_props BOOL
settings__site_speed_sample_rate FLOAT64
settings__standard_events__book_bookkeeping_call_completed STRING
settings__standard_events__book_a_demo_cta_click STRING
settings__standard_events__book_accountant_call_cta_click STRING
settings__standard_events__booked_demo STRING
settings__standard_events__calendly_appointment_booked STRING
settings__standard_events__ltd_free_registration_completed STRING
settings__standard_events__ltd_pro_registration_completed STRING
settings__standard_events__ltd_sub_created_pro STRING
settings__standard_events__ltd_sub_created_unlimited STRING
settings__standard_events__ltd_sub_created_yearly_pro STRING
settings__standard_events__ltd_sub_created_yearly_unlimited STRING
settings__standard_events__ltd_unlimited_registration_completed STRING
settings__standard_events__ltd_yearly_pro_registration_completed STRING
settings__standard_events__ltd_yearly_unlimited_registration_completed STRING
settings__standard_events__main_cta_click STRING
settings__standard_events__registration_started STRING
settings__standard_events__sa_webinar_tracking STRING
settings__standard_events__st_free_registration_completed STRING
settings__standard_events__st_pro_registration_completed STRING
settings__standard_events__st_sub_created_pro STRING
settings__standard_events__st_sub_created_unlimited STRING
settings__standard_events__st_sub_created_yearly_pro STRING
settings__standard_events__st_sub_created_yearly_unlimited STRING
settings__standard_events__st_unlimited_registration_completed STRING
settings__standard_events__st_yearly_pro_registration_completed STRING
settings__standard_events__st_yearly_unlimited_registration_completed STRING
settings__tag_id STRING
settings__top_level_context_mapping BOOL
settings__track_categorized_pages BOOL
settings__track_named_pages BOOL
settings__tracking_id STRING
settings__type_override BOOL
settings__use_google_amp_client_id BOOL
settings__user_deletion STRING
settings__user_id_as_external_id BOOL
settings__value_identifier STRING
settings__wait_time_to_update_consent_stage FLOAT64
source_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • destinations__metadata__actions (10 columns)
  • destinations__metadata__actions__fields (16 columns)
  • destinations__metadata__actions__fields__choices (5 columns)
  • destinations__metadata__categories (4 columns)
  • destinations__metadata__components (6 columns)
  • destinations__metadata__contacts (7 columns)
  • destinations__metadata__options (8 columns)
  • destinations__metadata__options__default_value (4 columns)
  • destinations__metadata__presets (7 columns)
  • destinations__metadata__previous_names (4 columns)
  • destinations__metadata__region_endpoints (4 columns)
  • destinations__metadata__supported_regions (4 columns)
  • destinations__settings__blacklist_pii_properties (4 columns)
  • destinations__settings__click_conversions (6 columns)
  • destinations__settings__ignored_referrers (4 columns)
  • destinations__settings__page_load_conversions (6 columns)
  • destinations__settings__reset_custom_dimensions_on_page (4 columns)
  • destinations__settings__rich_link_properties (4 columns)
  • destinations__settings__standard_events_custom_properties (4 columns)
  • destinations__settings__whitelist_pii_properties (4 columns)
labels (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
key STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
reverse_etl_models (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
enabled BOOL
id STRING
name STRING
query STRING
query_identifier_column STRING
schedule_config__interval STRING
schedule_config__timezone STRING
schedule_strategy STRING
source_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • reverse_etl_models__schedule_config__days (4 columns)
  • reverse_etl_models__schedule_config__hours (4 columns)
sources (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__description STRING
metadata__id STRING
metadata__is_cloud_event_source BOOL
metadata__logos__alt STRING
metadata__logos__default STRING
metadata__logos__mark STRING
metadata__name STRING
metadata__partner_owned BOOL
metadata__slug STRING
metadata__status STRING
enabled BOOL
id STRING
name STRING
settings__location STRING
settings__website_url STRING
slug STRING
workspace_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • sources__metadata__categories (4 columns)
  • sources__metadata__options (8 columns)
  • sources__labels (5 columns)
  • sources__write_keys (4 columns)
spaces (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
slug STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
transformations (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
destination_id STRING
destination_metadata_id STRING
drop BOOL
enabled BOOL
id STRING
if STRING
name STRING
source_id STRING
workspace_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • transformations__allow_properties (4 columns)
  • transformations__property_drops (4 columns)
  • transformations__property_renames (4 columns)
  • transformations__property_value_transformations (4 columns)
usage_api_calls_daily (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
api_calls STRING
timestamp STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
usage_mtu_daily (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
anonymous STRING
anonymous_identified STRING
identified STRING
never_identified STRING
period_end FLOAT64
period_start FLOAT64
timestamp STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • users__permissions (5 columns)
  • users__permissions__resources (5 columns)
  • users__permissions__resources__labels (4 columns)
warehouses (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__description STRING
metadata__id STRING
metadata__logos__alt STRING
metadata__logos__default STRING
metadata__logos__mark STRING
metadata__name STRING
metadata__slug STRING
enabled BOOL
id STRING
settings__ciphertext STRING
settings__encrypted BOOL
settings__gc_project STRING
settings__location STRING
settings__name STRING
workspace_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • warehouses__metadata__options (6 columns)

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

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

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

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

Use sources and destinations to document how data flows through Segment.

Bring usage_api_calls_daily and usage_mtu_daily into BigQuery to monitor volume and cost.

Join warehouses and transformations to review how your pipeline is set up.

Use audit_events to track who changed what across your workspace.

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