Skip to content
Book a demoStart free
Connectors

Fulcrum connector

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

Fulcrum connector pricing, tier and credits on kaivo.io

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

Sync your Fulcrum field data collection into BigQuery with Kaivo to analyse form records and inspections without exporting spreadsheets.

CategorySurveys & Email
AuthenticationAPI key
SetupSelf-service

Getting started with the Fulcrum connector

Section titled “Getting started with the Fulcrum connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Fulcrum 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
API key to use. Find it at https://web.fulcrumapp.com/settings/api

|

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

audio (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
access_key STRING
content_type STRING
created_at STRING
created_by STRING
created_by_id STRING
file_size FLOAT64
form_id STRING
processed BOOL
record_id STRING
status STRING
stored BOOL
updated_at STRING
updated_by STRING
updated_by_id STRING
uploaded BOOL
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
authorizations (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
last_ip_address STRING
last_used_at STRING
last_user_agent STRING
note STRING
token_last_8 STRING
updated_at STRING
user_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
changesets (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
metadata__application STRING
metadata__browser STRING
metadata__browser_version STRING
metadata__platform STRING
metadata__platform_version STRING
metadata__user_agent STRING
closed_at STRING
closed_by STRING
closed_by_id STRING
created_at STRING
created_by STRING
created_by_id STRING
form_id STRING
gravatar_image_url STRING
id STRING
image_large STRING
image_small STRING
max_lat FLOAT64
max_lon FLOAT64
min_lat FLOAT64
min_lon FLOAT64
number_created FLOAT64
number_deleted FLOAT64
number_of_changes FLOAT64
number_updated FLOAT64
updated_at STRING
updated_by STRING
updated_by_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
choice_lists (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
description STRING
created_at STRING
created_by STRING
created_by_id STRING
id STRING
name STRING
updated_at STRING
updated_by STRING
updated_by_id 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.
label STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
classification_sets (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
description STRING
created_at STRING
created_by STRING
created_by_id STRING
id STRING
name STRING
updated_at STRING
updated_by STRING
updated_by_id 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.
label STRING
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
forms (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
description STRING
assignment_enabled BOOL
auto_assign BOOL
created_at STRING
created_by STRING
created_by_id STRING
fastfill_audio_enabled BOOL
geometry_required BOOL
hidden_on_dashboard BOOL
id STRING
name STRING
projects_enabled BOOL
record_changed_at STRING
record_count FLOAT64
record_title_key STRING
status STRING
status_field__type STRING
status_field__description STRING
status_field__data_name STRING
status_field__default_previous_value BOOL
status_field__default_value STRING
status_field__disabled BOOL
status_field__enabled BOOL
status_field__hidden BOOL
status_field__key STRING
status_field__label STRING
status_field__read_only BOOL
status_field__required BOOL
updated_at STRING
updated_by STRING
updated_by_id 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 JSON
_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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
agreement_text STRING
annotations_enabled BOOL
audio_enabled BOOL
data_name STRING
default_previous_value BOOL
default_value STRING
deidentification_enabled BOOL
disabled BOOL
hidden BOOL
key STRING
label STRING
latlongstamp_enabled BOOL
negative__label STRING
negative__value STRING
neutral__label STRING
neutral__value STRING
neutral_enabled BOOL
numeric BOOL
positive__label STRING
positive__value STRING
required BOOL
timestamp_enabled BOOL
track_enabled BOOL
visible_conditions_behavior 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.
description STRING
id STRING
name 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 JSON
_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.
groups (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
id STRING
is_managed BOOL
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
layers (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
created_at STRING
id STRING
name STRING
origin STRING
source STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
memberships (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING
email STRING
first_name STRING
gravatar_image_url STRING
id STRING
image_large STRING
image_small STRING
last_name STRING
last_sign_in_at STRING
role_id STRING
role_name STRING
updated_at STRING
user STRING
user_id STRING
user_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
photos (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
access_key STRING
content_type STRING
created_at STRING
created_by STRING
created_by_id STRING
file_size FLOAT64
form_id STRING
latitude FLOAT64
longitude FLOAT64
processed BOOL
record_id STRING
stored BOOL
updated_at STRING
updated_by STRING
updated_by_id STRING
uploaded BOOL
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
customer STRING
external_job_id STRING
form_count FLOAT64
id STRING
name STRING
record_count FLOAT64
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
records (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version FLOAT64
client_created_at STRING
client_updated_at STRING
created_at STRING
created_by STRING
created_by_id STRING
created_duration FLOAT64
edited_duration FLOAT64
form_id STRING
form_values___0600 STRING
form_values___2f60__signature_id STRING
form_values___2f60__timestamp STRING
form_values___7da2 STRING
form_values__d630 STRING
geometry__type STRING
id STRING
latitude FLOAT64
longitude FLOAT64
updated_at STRING
updated_by STRING
updated_by_id STRING
updated_duration FLOAT64
_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.
audio_id 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.
video_id 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.
photo_id 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.
attachment_id STRING
name 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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
roles (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
can_access_issues_and_tasks BOOL
can_assign_records BOOL
can_bulk_delete_records BOOL
can_bulk_update_records BOOL
can_change_project BOOL
can_change_status BOOL
can_configure_issues_and_tasks BOOL
can_create_records BOOL
can_delete_records BOOL
can_export_records BOOL
can_import_records BOOL
can_manage_apps BOOL
can_manage_authorizations BOOL
can_manage_choice_lists BOOL
can_manage_classification_sets BOOL
can_manage_groups BOOL
can_manage_layers BOOL
can_manage_members BOOL
can_manage_projects BOOL
can_manage_roles BOOL
can_manage_subscription BOOL
can_run_reports BOOL
can_update_organization BOOL
can_update_records BOOL
created_at STRING
created_by STRING
created_by_id STRING
id STRING
is_default BOOL
is_system BOOL
name STRING
updated_at STRING
updated_by STRING
updated_by_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
signatures (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
access_key STRING
content_type STRING
created_at STRING
created_by STRING
created_by_id STRING
file_size FLOAT64
form_id STRING
processed BOOL
record_id STRING
stored BOOL
updated_at STRING
updated_by STRING
updated_by_id STRING
uploaded BOOL
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
access__allowed BOOL
completed_onboarding BOOL
current_organization__id STRING
current_organization__name STRING
email STRING
first_name STRING
id STRING
image_large STRING
image_small STRING
last_name STRING
managed BOOL
phone_number STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
api_token STRING
has_ita_system_apps BOOL
id STRING
name STRING
plan__description STRING
plan__activity_feed_enabled BOOL
plan__api_access_enabled BOOL
plan__attachments_enabled BOOL
plan__audio_enabled BOOL
plan__audit_logs_enabled BOOL
plan__barcodes_enabled BOOL
plan__base_price_in_cents FLOAT64
plan__calculations_enabled BOOL
plan__communities_enabled BOOL
plan__created_at STRING
plan__custom_roles_enabled BOOL
plan__data_event_inference_enabled BOOL
plan__data_event_loadfile_enabled BOOL
plan__data_event_recognizetext_enabled BOOL
plan__data_pack_cost FLOAT64
plan__data_pack_size FLOAT64
plan__data_shares_enabled BOOL
plan__data_shares_limit FLOAT64
plan__developer_pack_cost FLOAT64
plan__developer_pack_enabled BOOL
plan__esri_enterprise_connection_enabled BOOL
plan__export_changesets_enabled BOOL
plan__export_full_history_enabled BOOL
plan__export_photos BOOL
plan__export_reports_enabled BOOL
plan__exports_enabled BOOL
plan__external_contributions_enabled BOOL
plan__flags__advanced_geometry_android BOOL
plan__flags__advanced_geometry_beta BOOL
plan__flags__advanced_geometry_enabled BOOL
plan__flags__advanced_geometry_ios BOOL
plan__flags__batch_pdf_export_enabled BOOL
plan__flags__bulk_records_delete_enabled BOOL
plan__flags__esri_enhanced BOOL
plan__flags__feature_service_layers_enabled BOOL
plan__flags__import_limit FLOAT64
plan__flags__map_engine STRING
plan__flags__mobile_layer_picker BOOL
plan__flags__mobile_layer_picker_ga BOOL
plan__flags__mobile_offline_feature_services BOOL
plan__flags__non_blocking_sync_ga BOOL
plan__flags__offline_basemaps_beta BOOL
plan__flags__reporting_map_engine STRING
plan__flags__suppress_repeatable_geometry BOOL
plan__flags__suppress_repeatable_geometry_ga BOOL
plan__flags__tracking_android_enabled BOOL
plan__flags__tracking_ios_enabled BOOL
plan__flags__tracking_ios_enabled_ga BOOL
plan__flags__web_map_engine STRING
plan__flags__web_sketch_editor BOOL
plan__form_scripts_enabled BOOL
plan__id STRING
plan__imports_enabled BOOL
plan__included_users FLOAT64
plan__layers_enabled BOOL
plan__maps_data_quota FLOAT64
plan__media_data_quota FLOAT64
plan__media_data_usage_includes_audio BOOL
plan__media_data_usage_includes_photos BOOL
plan__media_data_usage_includes_signatures BOOL
plan__media_data_usage_includes_videos BOOL
plan__name STRING
plan__photo_annotations_enabled BOOL
plan__photo_deidentification_enabled BOOL
plan__photo_recognition_enabled BOOL
plan__photos_enabled BOOL
plan__price_in_cents FLOAT64
plan__public_color STRING
plan__public_slug STRING
plan__query_api_enabled BOOL
plan__record_links_enabled BOOL
plan__record_merging_enabled BOOL
plan__reference_files_enabled BOOL
plan__repeatables_enabled BOOL
plan__report_watermark_enabled BOOL
plan__reporting_advanced_enabled BOOL
plan__reporting_basic_enabled BOOL
plan__saml_enabled BOOL
plan__shared_views_enabled BOOL
plan__signatures_enabled BOOL
plan__slug STRING
plan__sync_draft_records_enabled BOOL
plan__updated_at STRING
plan__versioning_enabled BOOL
plan__videos_enabled BOOL
plan__view_history_enabled BOOL
plan__webhooks_enabled BOOL
plan__workflow_integration_daily_limit FLOAT64
plan__workflows_enabled BOOL
role__can_access_issues_and_tasks BOOL
role__can_assign_records BOOL
role__can_bulk_delete_records BOOL
role__can_bulk_update_records BOOL
role__can_change_project BOOL
role__can_change_status BOOL
role__can_configure_issues_and_tasks BOOL
role__can_create_records BOOL
role__can_delete_records BOOL
role__can_export_records BOOL
role__can_import_records BOOL
role__can_manage_apps BOOL
role__can_manage_authorizations BOOL
role__can_manage_choice_lists BOOL
role__can_manage_classification_sets BOOL
role__can_manage_groups BOOL
role__can_manage_layers BOOL
role__can_manage_members BOOL
role__can_manage_projects BOOL
role__can_manage_roles BOOL
role__can_manage_subscription BOOL
role__can_run_reports BOOL
role__can_update_organization BOOL
role__can_update_records BOOL
role__created_at STRING
role__created_by STRING
role__created_by_id STRING
role__id STRING
role__is_default BOOL
role__is_system BOOL
role__name STRING
role__updated_at STRING
role__updated_by STRING
role__updated_by_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: users__contexts__plan__export_formats

Section titled “Subtable: users__contexts__plan__export_formats”
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.
videos (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
access_key STRING
content_type STRING
created_at STRING
created_by STRING
created_by_id STRING
file_size FLOAT64
form_id STRING
processed BOOL
record_id STRING
status STRING
stored BOOL
updated_at STRING
updated_by STRING
updated_by_id STRING
uploaded BOOL
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
webhooks (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
created_at STRING
id STRING
name STRING
run_for_bulk_actions BOOL
updated_at STRING
url STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workflows (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
created_at STRING
created_by STRING
created_by_id STRING
event_type STRING
id STRING
name STRING
object_resource_id STRING
object_type STRING
run_for_bulk_actions BOOL
updated_at STRING
updated_by STRING
updated_by_id 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.
arguments__auth__password STRING
arguments__auth__username STRING
arguments__headers STRING
arguments__method STRING
arguments__parameters STRING
arguments__payload STRING
arguments__url STRING
id STRING
initial BOOL
step_type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: workflows__steps__arguments__expression

Section titled “Subtable: workflows__steps__arguments__expression”
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.
combinator STRING
field STRING
operator STRING
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.

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

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

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

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

Use forms and records to summarise field data and trends over time.

Join workflows with changesets to follow how records progress.

Use projects to compare data collection across sites and teams.

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