Skip to content
Book a demoStart free
Connectors

Mode connector

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

Mode connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Mode 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 data from Mode instead of moving it.

Sync your Mode analytics metadata into BigQuery with Kaivo to audit reports, queries, and usage across your workspace.

CategoryTech
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Mode 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 Secret.

Field Description
API Secret
Your Mode API secret — the private key used as the password for Basic auth, shown only once when the token is created.

|

Prerequisites

Mode’s API is only available to members of a Mode Business Workspace on a paid plan — other plans can’t access it.

  1. In Mode, go to Workspace Settings → Features → API Keys and create an API key. Copy the Token (used as the username) and the Secret (used as the password) — the secret is shown only once.
  2. Your Workspace name is the lowercase segment in your workspace URL (app.mode.com/<workspace>).

Need help? Reach our team via the chat in the bottom-right corner.

When you set up the connector, you provide:

Field Description
API Token
Your Mode API token — the public key used as the username for Basic auth. Create one under Workspace Settings → Features → API Keys.

| | Workspace |

Your Mode workspace name (all lowercase), as it appears in your workspace URL: app.mode.com/.

|

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

charts (150 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__create__action STRING
_forms__create__input__visualization__color_palette_token__type STRING
_forms__create__input__visualization__view__type STRING
_forms__create__input__visualization__view__value STRING
_forms__create__input__visualization__view_vegas__type STRING
_forms__create__input__visualization__view_vegas__value STRING
_forms__create__input__visualization__view_version__type STRING
_forms__create__input__visualization__view_version__value FLOAT64
_forms__create__method STRING
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__visualization__color_palette_token__type STRING
_forms__edit__input__visualization__color_palette_token__value STRING
_forms__edit__input__visualization__view__type STRING
_forms__edit__input__visualization__view__value STRING
_forms__edit__input__visualization__view_vegas__type STRING
_forms__edit__input__visualization__view_vegas__value STRING
_forms__edit__input__visualization__view_version__type STRING
_forms__edit__input__visualization__view_version__value FLOAT64
_forms__edit__method STRING
_links__color_palette__href STRING
_links__creator__href STRING
_links__preview__href STRING
_links__preview__templated BOOL
_links__report_run_viz_web__href STRING
_links__report_run_viz_web__templated BOOL
_links__report_viz_web__href STRING
_links__self__href STRING
color_palette_token STRING
created_at STRING
switch_view_token STRING
token STRING
updated_at STRING
view_vegas__description STRING
view_vegas__caption__is_hidden BOOL
view_vegas__caption__is_title_hidden BOOL
view_vegas__caption__position STRING
view_vegas__caption__text STRING
view_vegas__chart_type STRING
view_vegas__encoding__marks__channel STRING
view_vegas__encoding__marks__properties__type__automatic BOOL
view_vegas__encoding__marks__properties__type__value STRING
view_vegas__encoding__totals__grand__column BOOL
view_vegas__encoding__totals__grand__row BOOL
view_vegas__encoding__totals__subtotal__column BOOL
view_vegas__encoding__totals__subtotal__row BOOL
view_vegas__field_colors__a_dis_names__color_palette_token STRING
view_vegas__field_colors__a_dis_names__map__description FLOAT64
view_vegas__field_formats__a_con_values__axis_format__binned_axis_label__type STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__type STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__col_type STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__decimal_style STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__display_unit STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__grouping FLOAT64
view_vegas__field_formats__a_con_values__axis_format__scale__default__separator STRING
view_vegas__field_formats__a_con_values__axis_format__scale__default__shortcut_type STRING
view_vegas__field_formats__a_con_values__axis_format__scale__interpolation__type STRING
view_vegas__field_formats__a_con_values__axis_format__scale__range__is_independent BOOL
view_vegas__field_formats__a_con_values__axis_format__title__show BOOL
view_vegas__field_formats__a_con_values__pane_format__default__type STRING
view_vegas__field_formats__a_con_values__pane_format__default__col_type STRING
view_vegas__field_formats__a_con_values__pane_format__default__decimal_style STRING
view_vegas__field_formats__a_con_values__pane_format__default__display_unit STRING
view_vegas__field_formats__a_con_values__pane_format__default__grouping FLOAT64
view_vegas__field_formats__a_con_values__pane_format__default__separator STRING
view_vegas__field_formats__a_con_values__pane_format__default__shortcut_type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__binned_axis_label__type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__col_type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__decimal_style STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__display_unit STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__grouping FLOAT64
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__separator STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__default__shortcut_type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__interpolation__type STRING
view_vegas__field_formats__a_con_count_descriptionx__axis_format__scale__range__is_independent BOOL
view_vegas__field_formats__a_con_count_descriptionx__axis_format__title__show BOOL
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__type STRING
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__col_type STRING
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__decimal_style STRING
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__display_unit STRING
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__grouping FLOAT64
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__separator STRING
view_vegas__field_formats__a_con_count_descriptionx__pane_format__default__shortcut_type STRING
view_vegas__field_formats__a_dis_names__legend_format__position STRING
view_vegas__field_formats__a_dis_names__legend_format__show BOOL
view_vegas__field_formats__a_dis_names__legend_format__show_title BOOL
view_vegas__field_formats__a_dis_codex__header_format__default__type STRING
view_vegas__field_formats__a_dis_codex__header_format__default__col_type STRING
view_vegas__field_formats__a_dis_codex__header_format__default__horizontal_alignment STRING
view_vegas__field_formats__a_dis_codex__header_format__title__location STRING
view_vegas__field_formats__a_dis_codex__header_format__title__show BOOL
view_vegas__field_formats___idx__pane_format__default__type STRING
view_vegas__field_formats___idx__pane_format__default__col_type STRING
view_vegas__field_formats___idx__pane_format__default__decimal_style STRING
view_vegas__field_formats___idx__pane_format__default__display_unit STRING
view_vegas__field_formats___idx__pane_format__default__grouping FLOAT64
view_vegas__field_formats___idx__pane_format__default__horizontal_alignment STRING
view_vegas__field_formats___idx__pane_format__default__separator STRING
view_vegas__field_formats___namex__pane_format__default__type STRING
view_vegas__field_formats___namex__pane_format__default__col_type STRING
view_vegas__field_formats___namex__pane_format__default__horizontal_alignment STRING
view_vegas__field_formats___primary_contactx__pane_format__default__type STRING
view_vegas__field_formats___primary_contactx__pane_format__default__col_type STRING
view_vegas__field_formats___primary_contactx__pane_format__default__horizontal_alignment STRING
view_vegas__field_formats___region_idx__pane_format__default__type STRING
view_vegas__field_formats___region_idx__pane_format__default__col_type STRING
view_vegas__field_formats___region_idx__pane_format__default__decimal_style STRING
view_vegas__field_formats___region_idx__pane_format__default__display_unit STRING
view_vegas__field_formats___region_idx__pane_format__default__grouping FLOAT64
view_vegas__field_formats___region_idx__pane_format__default__horizontal_alignment STRING
view_vegas__field_formats___region_idx__pane_format__default__separator STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__type STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__col_type STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__decimal_style STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__display_unit STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__grouping FLOAT64
view_vegas__field_formats___sales_rep_idx__pane_format__default__horizontal_alignment STRING
view_vegas__field_formats___sales_rep_idx__pane_format__default__separator STRING
view_vegas__format__colors__theme STRING
view_vegas__format__drilldown_enabled BOOL
view_vegas__format__flat_table__general__col_gridlines BOOL
view_vegas__format__flat_table__general__color_scheme STRING
view_vegas__format__flat_table__general__data_profiling_enabled BOOL
view_vegas__format__flat_table__general__density STRING
view_vegas__format__flat_table__general__page_size FLOAT64
view_vegas__format__flat_table__general__row_gridlines BOOL
view_vegas__format__flat_table__general__row_numbers BOOL
view_vegas__format__flat_table__general__sizing_style STRING
view_vegas__format__legend__enabled BOOL
view_vegas__format__legend__position STRING
view_vegas__format__legend__title_enabled BOOL
view_vegas__format__null_to_zero BOOL
view_vegas__format__pie_labels_not_percentages BOOL
view_vegas__format__show_values BOOL
view_vegas__format__use_muze_renderer BOOL
view_vegas__format__x_axis__compact BOOL
view_vegas__format__x_axis__date_format STRING
view_vegas__format__x_axis__show_axis_labels BOOL
view_vegas__format__x_axis__title_enabled BOOL
view_vegas__format__y2_axis__scale_type STRING
view_vegas__format__y2_axis__title_enabled BOOL
view_vegas__format__y_axis__scale_type STRING
view_vegas__format__y_axis__title_enabled BOOL
view_vegas__is_auto_update_disabled BOOL
view_vegas__title STRING
view_version FLOAT64
_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.

  • charts___forms__create__input__visualization__view_version__options (4 columns)
  • charts___forms__edit__input__visualization__view_version__options (4 columns)
  • charts__view_vegas__encoding__column (4 columns)
  • charts__view_vegas__encoding__filter (4 columns)
  • charts__view_vegas__encoding__groups (4 columns)
  • charts__view_vegas__encoding__marks__properties__angle__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__baseline__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__color__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__detail__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__label__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__size__values (4 columns)
  • charts__view_vegas__encoding__marks__properties__text__values (6 columns)
  • charts__view_vegas__encoding__marks__properties__tooltip__values (4 columns)
  • charts__view_vegas__encoding__marks__series (9 columns)
  • charts__view_vegas__encoding__marks__series__properties__angle__values (4 columns)
  • charts__view_vegas__encoding__marks__series__properties__baseline__values (4 columns)
  • charts__view_vegas__encoding__marks__series__properties__color__values (6 columns)
  • charts__view_vegas__encoding__marks__series__properties__detail__values (4 columns)
  • charts__view_vegas__encoding__marks__series__properties__label__values (4 columns)
  • charts__view_vegas__encoding__marks__series__properties__size__values (4 columns)
  • charts__view_vegas__encoding__marks__series__properties__text__values (6 columns)
  • charts__view_vegas__encoding__marks__series__properties__tooltip__values (4 columns)
  • charts__view_vegas__encoding__row (4 columns)
  • charts__view_vegas__encoding__sorts (4 columns)
  • charts__view_vegas__encoding__value (4 columns)
  • charts__view_vegas__encoding__x (6 columns)
  • charts__view_vegas__encoding__x2 (4 columns)
  • charts__view_vegas__encoding__y (6 columns)
  • charts__view_vegas__encoding__y2 (4 columns)
  • charts__view_vegas__field_colors__a_dis_names__palette (4 columns)
  • charts__view_vegas__format__colors__custom (4 columns)
  • charts__view_vegas__format__flat_table__columns (5 columns)
data_sources (47 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_forms__edit__action STRING
_forms__edit__content_type STRING
_forms__edit__input__data_source__tablesx__description__type STRING
_forms__edit__input__data_source__tablesx__columnsx__data_type__type STRING
_forms__edit__input__data_source__tablesx__columnsx__is_nullable__type STRING
_forms__edit__input__data_source__tablesx__columnsx__is_nullable__value BOOL
_forms__edit__input__data_source__tablesx__columnsx__name__type STRING
_forms__edit__input__data_source__tablesx__columnsx__primary_key__type STRING
_forms__edit__input__data_source__tablesx__columnsx__primary_key__value BOOL
_forms__edit__input__data_source__tablesx__name__type STRING
_forms__edit__input__data_source__tablesx__schema__type STRING
_forms__edit__method STRING
_links__account__href STRING
_links__creator__href STRING
_links__permissions__href STRING
_links__self__href STRING
_links__web__href STRING
_links__web_home__href STRING
account_id FLOAT64
account_username STRING
adapter STRING
adapter_version STRING
asleep BOOL
bridged BOOL
created_at STRING
database STRING
display_name STRING
has_expensive_schema_updates BOOL
host STRING
id FLOAT64
ldap BOOL
name STRING
organization_plan_code STRING
organization_token STRING
port FLOAT64
provider STRING
public BOOL
queryable BOOL
soft_deleted BOOL
ssl BOOL
token STRING
updated_at STRING
username STRING
vendor 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.

  • data_sources___forms__edit__input__data_source__tablesx__columnsx__is_nullable__options (4 columns)
  • data_sources___forms__edit__input__data_source__tablesx__columnsx__primary_key__options (4 columns)
datasets (66 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report__description__type STRING
_forms__edit__input__report__description__value STRING
_forms__edit__input__report__account_id__type STRING
_forms__edit__input__report__account_id__value FLOAT64
_forms__edit__input__report__name__type STRING
_forms__edit__input__report__name__value STRING
_forms__edit__input__report__space_token__type STRING
_forms__edit__input__report__space_token__value STRING
_forms__edit__method STRING
_forms__update_settings__action STRING
_forms__update_settings__input__report__drill_anywhere_enabled__type STRING
_forms__update_settings__input__report__drill_anywhere_enabled__value BOOL
_forms__update_settings__input__report__manual_run_disabled__type STRING
_forms__update_settings__input__report__manual_run_disabled__value BOOL
_forms__update_settings__method STRING
_links__account__href STRING
_links__creator__href STRING
_links__dataset_dependencies__href STRING
_links__last_run__href STRING
_links__last_successful_run__href STRING
_links__queries__href STRING
_links__report_index_web__href STRING
_links__report_pins__href STRING
_links__report_run__href STRING
_links__report_run__templated BOOL
_links__report_runs__href STRING
_links__report_schedules__href STRING
_links__self__href STRING
_links__space__href STRING
_links__space_links__href STRING
_links__web__href STRING
_links__web_edit__href STRING
account_id FLOAT64
account_username STRING
collection_name STRING
collection_token STRING
created_at STRING
drilldowns_enabled BOOL
edited_at STRING
id FLOAT64
is_sample BOOL
last_run_at STRING
last_saved_at STRING
last_successful_run_token STRING
last_successfully_run_at STRING
manual_run_disabled BOOL
max_query_count FLOAT64
name STRING
public BOOL
query_count FLOAT64
query_preview STRING
run_privately BOOL
runs_count FLOAT64
schedules_count FLOAT64
space_token STRING
switch_view_token STRING
token STRING
updated_at STRING
view_count FLOAT64
_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.

  • datasets___forms__update_settings__input__report__drill_anywhere_enabled__options (4 columns)
  • datasets___forms__update_settings__input__report__manual_run_disabled__options (4 columns)
datasets_runs (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__cancel__action STRING
_forms__cancel__method STRING
_links__account__href STRING
_links__executed_by__href STRING
_links__latest_successful_report_run_api_url__href STRING
_links__query_runs__href STRING
_links__report__href STRING
_links__self__href STRING
_links__share__href STRING
completed_at STRING
created_at STRING
is_latest_report_run BOOL
is_latest_successful_report_run BOOL
report_has_failures_since_last_success BOOL
state STRING
token STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
datasets_schedules (46 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report_schedule__cron__day_of_month__type STRING
_forms__edit__input__report_schedule__cron__day_of_week__type STRING
_forms__edit__input__report_schedule__cron__freq__type STRING
_forms__edit__input__report_schedule__cron__freq__value STRING
_forms__edit__input__report_schedule__cron__hour__type STRING
_forms__edit__input__report_schedule__cron__hour__value FLOAT64
_forms__edit__input__report_schedule__cron__minute__type STRING
_forms__edit__input__report_schedule__cron__minute__value FLOAT64
_forms__edit__input__report_schedule__cron__time_zone__type STRING
_forms__edit__input__report_schedule__cron__time_zone__value STRING
_forms__edit__input__report_schedule__name__type STRING
_forms__edit__input__report_schedule__name__value STRING
_forms__edit__input__report_schedule__timeout__type STRING
_forms__edit__input__report_schedule__timeout__value FLOAT64
_forms__edit__method STRING
_links__account__href STRING
_links__creator__href STRING
_links__report__href STRING
_links__report_runs__href STRING
_links__report_subscriptions__href STRING
_links__report_web__href STRING
_links__self__href STRING
created_at STRING
frequency STRING
hour STRING
last_scheduled_run STRING
minute STRING
name STRING
next_scheduled_run STRING
report_name STRING
report_token STRING
report_type STRING
retry_count FLOAT64
retry_delay FLOAT64
retry_state STRING
subscribed BOOL
subscriber_count FLOAT64
time_zone STRING
timeout FLOAT64
token STRING
updated_at 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.

  • datasets_schedules___forms__edit__input__report_schedule__cron__day_of_month__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__day_of_month__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__day_of_week__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__day_of_week__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__freq__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__freq__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__hour__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__hour__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__minute__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__minute__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__time_zone__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__cron__time_zone__options__list (4 columns)
  • datasets_schedules___forms__edit__input__report_schedule__timeout__options (3 columns)
  • datasets_schedules___forms__edit__input__report_schedule__timeout__options__list (4 columns)
definitions (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__definition__description__type STRING
_forms__edit__input__definition__description__value STRING
_forms__edit__input__definition__data_source_id__type STRING
_forms__edit__input__definition__data_source_id__value FLOAT64
_forms__edit__input__definition__name__type STRING
_forms__edit__input__definition__name__value STRING
_forms__edit__input__definition__source__type STRING
_forms__edit__input__definition__source__value STRING
_forms__edit__method STRING
_forms__execute__action STRING
_forms__execute__input__definition__source__type STRING
_forms__execute__input__definition__source__value STRING
_forms__execute__input__limit__type STRING
_forms__execute__input__limit__value BOOL
_forms__execute__method STRING
_links__creator__href STRING
_links__self__href STRING
_links__web_edit__href STRING
created_at STRING
data_source_id FLOAT64
id FLOAT64
last_saved_at STRING
name STRING
source STRING
token STRING
updated_at 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.

  • definitions___forms__execute__input__limit__options (4 columns)
field_descriptions (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__update__action STRING
_forms__update__input__desc__type STRING
_forms__update__method STRING
_links__self__href STRING
name STRING
token STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
groups (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__creator__href STRING
_links__group_memberships__href STRING
_links__membership_by_id__href STRING
_links__membership_by_id__templated BOOL
_links__memberships_preview__href STRING
_links__self__href STRING
_links__web__href STRING
group_type STRING
managed BOOL
member_count FLOAT64
name STRING
spaces_count FLOAT64
state STRING
token STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
groups_memberships (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__creator__href STRING
_links__member__href STRING
_links__self__href STRING
_links__user_group__href STRING
member_token STRING
token STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
memberships (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_links__groups__href STRING
_links__organization__href STRING
_links__self__href STRING
_links__user__href STRING
_links__web_self__href STRING
_links__web_self_download_profile__href STRING
activated_at STRING
admin BOOL
member_token STRING
member_username STRING
state STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
queries (32 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__content_type STRING
_forms__edit__input__query__data_source_id__type STRING
_forms__edit__input__query__data_source_id__value FLOAT64
_forms__edit__input__query__name__type STRING
_forms__edit__input__query__name__value STRING
_forms__edit__input__query__raw_query__type STRING
_forms__edit__input__query__raw_query__value STRING
_forms__edit__method STRING
_links__charts__href STRING
_links__creator__href STRING
_links__new_chart__href STRING
_links__new_query_table__href STRING
_links__query_runs__href STRING
_links__query_tables__href STRING
_links__report__href STRING
_links__report_runs__href STRING
_links__self__href STRING
created_at STRING
data_source_id FLOAT64
explorations_count FLOAT64
id FLOAT64
last_run_id FLOAT64
name STRING
raw_query STRING
report_imports_count FLOAT64
token STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
query_runs (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__cancel__action STRING
_forms__cancel__method STRING
_forms__edit__action STRING
_forms__edit__input__query_run__dataset__columns__type STRING
_forms__edit__input__query_run__dataset__content__type STRING
_forms__edit__input__query_run__dataset__count__type STRING
_forms__edit__input__query_run__error__detail__type STRING
_forms__edit__input__query_run__error__message__type STRING
_forms__edit__method STRING
_links__executed_by__href STRING
_links__query__href STRING
_links__query_web__href STRING
_links__report_run__href STRING
_links__report_run_web__href STRING
_links__result__href STRING
_links__result_web__href STRING
_links__self__href STRING
_links__view__href STRING
completed_at STRING
created_at STRING
data_source_id FLOAT64
data_source_token STRING
id STRING
limit BOOL
max_result_bytes FLOAT64
query_created_at STRING
query_name STRING
query_token STRING
raw_source STRING
rendered_source STRING
state STRING
token STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
report_filters (51 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report_filter__control_type__type STRING
_forms__edit__input__report_filter__control_type__value STRING
_forms__edit__input__report_filter__data_type__type STRING
_forms__edit__input__report_filter__data_type__value STRING
_forms__edit__input__report_filter__filter_type__type STRING
_forms__edit__input__report_filter__filter_type__value STRING
_forms__edit__input__report_filter__formula__type STRING
_forms__edit__input__report_filter__formula__value STRING
_forms__edit__input__report_filter__formula_type__type STRING
_forms__edit__input__report_filter__formula_type__value STRING
_forms__edit__input__report_filter__hide_select_all__type STRING
_forms__edit__input__report_filter__hide_select_all__value BOOL
_forms__edit__input__report_filter__name__type STRING
_forms__edit__input__report_filter__name__value STRING
_forms__edit__input__report_filter__options__type STRING
_forms__edit__input__report_filter__options__value STRING
_forms__edit__input__report_filter__show_relevant_values_only__type STRING
_forms__edit__input__report_filter__show_relevant_values_only__value BOOL
_forms__edit__input__report_filter__variable_type__type STRING
_forms__edit__input__report_filter__variable_type__value STRING
_forms__edit__method STRING
_forms__edit_position__action STRING
_forms__edit_position__input__all__type STRING
_forms__edit_position__input__all__value BOOL
_forms__edit_position__input__report_filter__next_filter_token__type STRING
_forms__edit_position__input__report_filter__next_filter_token__value STRING
_forms__edit_position__method STRING
_links__report__href STRING
_links__self__href STRING
control_type STRING
created_at STRING
data_type STRING
filter_type STRING
formula STRING
formula_type STRING
hide_select_all BOOL
id FLOAT64
name STRING
options__default__all BOOL
options__default__selection_mode STRING
report_id FLOAT64
row_order FLOAT64
show_relevant_values_only BOOL
token STRING
updated_at STRING
variable_type 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.

  • report_filters___forms__edit__input__report_filter__show_relevant_values_only__options (4 columns)
  • report_filters___forms__edit_position__input__all__options (4 columns)
  • report_filters__options__default__values (4 columns)
report_runs (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__cancel__action STRING
_forms__cancel__method STRING
_links__account__href STRING
_links__clone__href STRING
_links__content__href STRING
_links__embed__href STRING
_links__executed_by__href STRING
_links__latest_successful_report_run_api_url__href STRING
_links__pdf_export__href STRING
_links__preview__href STRING
_links__python_cell_runs__href STRING
_links__query_runs__href STRING
_links__report__href STRING
_links__self__href STRING
_links__share__href STRING
_links__web_clone__href STRING
completed_at STRING
created_at STRING
is_latest_report_run BOOL
is_latest_successful_report_run BOOL
python_state STRING
report_has_failures_since_last_success BOOL
state STRING
token STRING
updated_at 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.

  • report_runs__form_fields (4 columns)
report_schedules (46 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report_schedule__cron__day_of_month__type STRING
_forms__edit__input__report_schedule__cron__day_of_week__type STRING
_forms__edit__input__report_schedule__cron__freq__type STRING
_forms__edit__input__report_schedule__cron__freq__value STRING
_forms__edit__input__report_schedule__cron__hour__type STRING
_forms__edit__input__report_schedule__cron__hour__value FLOAT64
_forms__edit__input__report_schedule__cron__minute__type STRING
_forms__edit__input__report_schedule__cron__minute__value FLOAT64
_forms__edit__input__report_schedule__cron__time_zone__type STRING
_forms__edit__input__report_schedule__cron__time_zone__value STRING
_forms__edit__input__report_schedule__name__type STRING
_forms__edit__input__report_schedule__name__value STRING
_forms__edit__input__report_schedule__timeout__type STRING
_forms__edit__input__report_schedule__timeout__value FLOAT64
_forms__edit__method STRING
_links__account__href STRING
_links__creator__href STRING
_links__report__href STRING
_links__report_runs__href STRING
_links__report_subscriptions__href STRING
_links__report_web__href STRING
_links__self__href STRING
created_at STRING
frequency STRING
hour STRING
last_scheduled_run STRING
minute STRING
name STRING
next_scheduled_run STRING
report_name STRING
report_token STRING
report_type STRING
retry_count FLOAT64
retry_delay FLOAT64
retry_state STRING
subscribed BOOL
subscriber_count FLOAT64
time_zone STRING
timeout FLOAT64
token STRING
updated_at 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.

  • report_schedules___forms__edit__input__report_schedule__cron__day_of_month__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__day_of_month__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__day_of_week__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__day_of_week__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__freq__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__freq__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__hour__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__hour__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__minute__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__minute__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__time_zone__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__cron__time_zone__options__list (4 columns)
  • report_schedules___forms__edit__input__report_schedule__timeout__options (3 columns)
  • report_schedules___forms__edit__input__report_schedule__timeout__options__list (4 columns)
reports (105 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
_forms__archive__action STRING
_forms__archive__method STRING
_forms__batch_edit_filters__action STRING
_forms__batch_edit_filters__input__report__filtersx__options__type STRING
_forms__batch_edit_filters__input__report__filtersx__token__type STRING
_forms__batch_edit_filters__method STRING
_forms__clone__action STRING
_forms__clone__input__owner_id__type STRING
_forms__clone__input__owner_id__value FLOAT64
_forms__clone__method STRING
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report__description__type STRING
_forms__edit__input__report__description__value STRING
_forms__edit__input__report__account_id__type STRING
_forms__edit__input__report__account_id__value FLOAT64
_forms__edit__input__report__color_mappings__type STRING
_forms__edit__input__report__layout__type STRING
_forms__edit__input__report__layout__value STRING
_forms__edit__input__report__name__type STRING
_forms__edit__input__report__name__value STRING
_forms__edit__input__report__published__type STRING
_forms__edit__input__report__published__value BOOL
_forms__edit__input__report__space_token__type STRING
_forms__edit__input__report__space_token__value STRING
_forms__edit__method STRING
_forms__unarchive__action STRING
_forms__unarchive__method STRING
_forms__update_settings__action STRING
_forms__update_settings__input__report__drill_anywhere_enabled__type STRING
_forms__update_settings__input__report__drill_anywhere_enabled__value BOOL
_forms__update_settings__input__report__full_width__type STRING
_forms__update_settings__input__report__full_width__value BOOL
_forms__update_settings__input__report__manual_run_disabled__type STRING
_forms__update_settings__input__report__manual_run_disabled__value BOOL
_forms__update_settings__input__report__theme__type STRING
_forms__update_settings__input__report__theme__value FLOAT64
_forms__update_settings__method STRING
_links__account__href STRING
_links__creator__href STRING
_links__csv_export__href STRING
_links__dbt_metadata__href STRING
_links__last_run__href STRING
_links__last_successful_run__href STRING
_links__perspective_email_subscription_memberships__href STRING
_links__python_notebook__href STRING
_links__python_visualizations__href STRING
_links__queries__href STRING
_links__report_filters__href STRING
_links__report_index_web__href STRING
_links__report_pins__href STRING
_links__report_run__href STRING
_links__report_run__templated BOOL
_links__report_runs__href STRING
_links__report_schedules__href STRING
_links__report_subscriptions__href STRING
_links__report_theme__href STRING
_links__self__href STRING
_links__share__href STRING
_links__space__href STRING
_links__space_links__href STRING
_links__validate_email_subscriber__href STRING
_links__validate_email_subscriber__templated BOOL
_links__web__href STRING
_links__web_edit__href STRING
_links__web_report_runs__href STRING
account_id FLOAT64
account_username STRING
archived BOOL
chart_count FLOAT64
created_at STRING
drill_anywhere_enabled BOOL
drilldowns_enabled BOOL
edited_at STRING
expected_runtime FLOAT64
full_width BOOL
id FLOAT64
is_embedded BOOL
is_signed BOOL
last_run_at STRING
last_saved_at STRING
last_successful_run_token STRING
last_successfully_run_at STRING
layout STRING
manual_run_disabled BOOL
max_query_count FLOAT64
name STRING
public BOOL
query_count FLOAT64
query_preview STRING
run_privately BOOL
runs_count FLOAT64
schedules_count FLOAT64
shared BOOL
space_token STRING
theme_id FLOAT64
token STRING
updated_at STRING
view_count FLOAT64
web_preview_image 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.

  • reports___forms__update_settings__input__report__drill_anywhere_enabled__options (4 columns)
  • reports___forms__update_settings__input__report__full_width__options (4 columns)
  • reports___forms__update_settings__input__report__manual_run_disabled__options (4 columns)
  • reports___forms__update_settings__input__report__theme__options (3 columns)
  • reports___forms__update_settings__input__report__theme__options__list (4 columns)
reports_subscriptions (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_forms__edit__action STRING
_forms__edit__input__report_subscription__csv_attachments_enabled__type STRING
_forms__edit__input__report_subscription__data_previews_enabled__type STRING
_forms__edit__input__report_subscription__data_tables_enabled__type STRING
_forms__edit__input__report_subscription__pdf_attachments_enabled__type STRING
_forms__edit__input__report_subscription__report_links_enabled__type STRING
_forms__edit__method STRING
_links__email_subscription_memberships__href STRING
_links__report_schedule__href STRING
_links__self__href STRING
_links__slack_subscription_memberships__href STRING
csv_attachments_enabled BOOL
data_previews_enabled BOOL
data_tables_enabled BOOL
email_subscriber_count FLOAT64
pdf_attachments_enabled BOOL
report_links_enabled BOOL
_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.

  • reports_subscriptions___forms__edit__input__report_subscription__csv_attachments_enabled__options (4 columns)
  • reports_subscriptions___forms__edit__input__report_subscription__data_previews_enabled__options (4 columns)
  • reports_subscriptions___forms__edit__input__report_subscription__data_tables_enabled__options (4 columns)
  • reports_subscriptions___forms__edit__input__report_subscription__pdf_attachments_enabled__options (4 columns)
  • reports_subscriptions___forms__edit__input__report_subscription__report_links_enabled__options (4 columns)
space_memberships (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__destroy__action STRING
_forms__destroy__method STRING
_links__creator__href STRING
_links__member__href STRING
_links__self__href STRING
email STRING
member_id STRING
member_token STRING
member_type STRING
token STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
spaces (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_forms__create__action STRING
_forms__create__input__space__description__type STRING
_forms__create__input__space__default_access_level__type STRING
_forms__create__input__space__default_access_level__value STRING
_forms__create__input__space__name__type STRING
_forms__create__input__space__space_type__type STRING
_forms__create__input__space__space_type__value STRING
_forms__create__method STRING
_links__creator__href STRING
_links__detail__href STRING
_links__preview_space_memberships__href STRING
_links__reports__href STRING
_links__search_space_permissions__href STRING
_links__self__href STRING
_links__space_memberships__href STRING
_links__space_report_pins__href STRING
_links__web__href STRING
default_access_level STRING
free_default BOOL
id FLOAT64
name STRING
restricted BOOL
space_type STRING
state STRING
token STRING
viewablex BOOL
_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.

  • spaces___forms__create__input__space__default_access_level__options (4 columns)
  • spaces___forms__create__input__space__space_type__options (4 columns)

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

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

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

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

Use reports and queries to document what exists and how it is organised.

Use report_runs and query_runs to find unused or heavy reports.

Join groups with memberships to review who can access your analytics.

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

  • Adform: Sync Adform to BigQuery.
  • Amplitude: Sync Amplitude to BigQuery.
  • Auth0: Sync Auth0 to BigQuery.
  • Convex: Sync Convex to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.