Skip to content
Book a demoStart free
Connectors

Box connector

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

Box connector pricing, tier and credits on kaivo.io

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

Sync your Box content and activity data into BigQuery with Kaivo to audit access, monitor activity, and track storage across your account.

CategoryFiles & Databases
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Box 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 Box credentials. You provide:

Field Description
OAuth Client ID
Client ID of your Box Custom App (Server Authentication / Client Credentials Grant), found under the app’s Configuration tab in the Box Developer Console.

| | OAuth Client Secret |

Client secret of the same Box Custom App, found under its Configuration tab in the Box Developer Console (viewing it requires 2FA on your Box account).

|

When you set up the connector, you provide:

Field Description
User ID
Numeric ID of the Box user to sync as — the app authenticates as this user (sent as box_subject_id). Find it in the Admin Console under Users; it is not your Client ID. The app needs “Generate User Access Tokens” enabled and must be authorized in the Admin Console.

|

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

admin_logs (97 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
accessible_by__type STRING
accessible_by__id STRING
accessible_by__login STRING
accessible_by__name STRING
additional_details__type STRING
additional_details__metadata__type STRING
additional_details__metadata__operation_params STRING
additional_details__access_token_identifier STRING
additional_details__collab_id STRING
additional_details__collection__collection_id FLOAT64
additional_details__collection__collection_name STRING
additional_details__collection__user__email STRING
additional_details__collection__user__id FLOAT64
additional_details__collection__user__name STRING
additional_details__collection_item__collection_id FLOAT64
additional_details__collection_item__collection_name STRING
additional_details__collection_item__item__file FLOAT64
additional_details__collection_item__user__email STRING
additional_details__collection_item__user__id FLOAT64
additional_details__collection_item__user__name STRING
additional_details__comment_id FLOAT64
additional_details__ekm_id STRING
additional_details__invitation_message STRING
additional_details__is_performed_by_admin BOOL
additional_details__message STRING
additional_details__original_item_id STRING
additional_details__original_item_name STRING
additional_details__original_item_type STRING
additional_details__role STRING
additional_details__service_id STRING
additional_details__service_name STRING
additional_details__shared_link_settings__new_can_download BOOL
additional_details__shared_link_settings__new_can_edit BOOL
additional_details__shared_link_settings__new_can_preview BOOL
additional_details__shared_link_settings__new_is_expiration_date_set BOOL
additional_details__shared_link_settings__new_is_password_protected BOOL
additional_details__shared_link_settings__new_visibility_status STRING
additional_details__shared_link_id STRING
additional_details__sign_request__ready_sign_link__id STRING
additional_details__sign_request__redirection__declined_redirect_url STRING
additional_details__sign_request__redirection__redirect_url STRING
additional_details__sign_request__requestor__type STRING
additional_details__sign_request__requestor__id STRING
additional_details__sign_request__requestor__login STRING
additional_details__sign_request__requestor__name STRING
additional_details__sign_request__requestor_ip_address STRING
additional_details__sign_request__sender_message__message STRING
additional_details__sign_request__sender_message__subject STRING
additional_details__sign_request__sign_request_id STRING
additional_details__sign_request__sign_request_short_id STRING
additional_details__sign_request__signer__type STRING
additional_details__sign_request__signer__id STRING
additional_details__sign_request__signer__login STRING
additional_details__sign_request__signer__name STRING
additional_details__sign_request__signer_ip_address STRING
additional_details__sign_request__status STRING
additional_details__size FLOAT64
additional_details__task__created_by__id FLOAT64
additional_details__task__created_by__login STRING
additional_details__task__due_at STRING
additional_details__task__id FLOAT64
additional_details__task__message STRING
additional_details__task_assignment__assigned_to__id FLOAT64
additional_details__task_assignment__assigned_to__login STRING
additional_details__task_assignment__message STRING
additional_details__task_assignment__status STRING
additional_details__version_id STRING
created_at STRING
created_by__type STRING
created_by__id STRING
created_by__login STRING
created_by__name STRING
event_id STRING
event_type STRING
ip_address STRING
source__type STRING
source__file_id STRING
source__file_name STRING
source__folder_id STRING
source__folder_name STRING
source__id STRING
source__item_id STRING
source__item_name STRING
source__item_type STRING
source__login STRING
source__name STRING
source__owned_by__type STRING
source__owned_by__id STRING
source__owned_by__login STRING
source__owned_by__name STRING
source__parent__type STRING
source__parent__id STRING
source__parent__name STRING
source__user_email STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: admin_logs__additional_details__sign_request__files

Section titled “Subtable: admin_logs__additional_details__sign_request__files”
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
id STRING
name STRING
parent__type STRING
parent__id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
collection_items (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
collections (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
collection_type STRING
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
events (76 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
additional_details__original_item_id STRING
additional_details__original_item_name STRING
additional_details__original_item_type STRING
created_at STRING
created_by__type STRING
created_by__id STRING
created_by__login STRING
created_by__name STRING
event_id STRING
event_type STRING
recorded_at STRING
session_id STRING
source__type STRING
source__description STRING
source__assigned_at STRING
source__assigned_by__type STRING
source__assigned_by__id STRING
source__assigned_by__login STRING
source__assigned_by__name STRING
source__assigned_to__type STRING
source__assigned_to__id STRING
source__assigned_to__login STRING
source__assigned_to__name STRING
source__content_created_at STRING
source__content_modified_at STRING
source__created_at STRING
source__created_by__type STRING
source__created_by__id STRING
source__created_by__login STRING
source__created_by__name STRING
source__etag STRING
source__file_version__type STRING
source__file_version__id STRING
source__file_version__sha1 STRING
source__id STRING
source__invite_email STRING
source__is_reply_comment BOOL
source__item__type STRING
source__item__etag STRING
source__item__file_version__type STRING
source__item__file_version__id STRING
source__item__file_version__sha1 STRING
source__item__id STRING
source__item__name STRING
source__item__sequence_id STRING
source__item__sha1 STRING
source__item_status STRING
source__message STRING
source__modified_at STRING
source__modified_by__type STRING
source__modified_by__id STRING
source__modified_by__login STRING
source__modified_by__name STRING
source__name STRING
source__owned_by__type STRING
source__owned_by__id STRING
source__owned_by__login STRING
source__owned_by__name STRING
source__parent__type STRING
source__parent__etag STRING
source__parent__id STRING
source__parent__name STRING
source__parent__sequence_id STRING
source__path_collection__total_count FLOAT64
source__purged_at STRING
source__resolution_state STRING
source__role STRING
source__sequence_id STRING
source__sha1 STRING
source__size FLOAT64
source__status STRING
source__synced BOOL
source__trashed_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: events__source__path_collection__entries

Section titled “Subtable: events__source__path_collection__entries”
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
etag STRING
id STRING
name STRING
sequence_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
file_collaborations (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at STRING
created_by__type STRING
created_by__id STRING
created_by__login STRING
created_by__name STRING
id STRING
invite_email STRING
is_access_only BOOL
item__type STRING
item__etag STRING
item__file_version__type STRING
item__file_version__id STRING
item__file_version__sha1 STRING
item__id STRING
item__name STRING
item__sequence_id STRING
item__sha1 STRING
modified_at STRING
role STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
file_comments (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at STRING
created_by__type STRING
created_by__id STRING
created_by__login STRING
created_by__name STRING
id STRING
is_reply_comment BOOL
message STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
file_tasks (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
assigned_at STRING
assigned_to__type STRING
assigned_to__id STRING
assigned_to__login STRING
assigned_to__name STRING
id STRING
item__type STRING
item__etag STRING
item__file_version__type STRING
item__file_version__id STRING
item__file_version__sha1 STRING
item__id STRING
item__name STRING
item__sequence_id STRING
item__sha1 STRING
message STRING
resolution_state STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
files (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
folder_collaborations (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
created_at STRING
created_by__type STRING
created_by__id STRING
created_by__login STRING
created_by__name STRING
id STRING
invite_email STRING
is_access_only BOOL
item__type STRING
item__etag STRING
item__id STRING
item__name STRING
item__sequence_id STRING
modified_at STRING
role STRING
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
folders (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
etag STRING
id STRING
name STRING
sequence_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
recent_items (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sign_request (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
are_reminders_enabled BOOL
are_text_signatures_enabled BOOL
id STRING
is_document_preparation_needed BOOL
is_phone_verification_required_to_view BOOL
name STRING
parent_folder__type STRING
parent_folder__etag STRING
parent_folder__id STRING
parent_folder__name STRING
parent_folder__sequence_id STRING
sign_files__is_ready_for_download BOOL
status 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.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 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.
email STRING
has_viewed_document BOOL
is_in_person BOOL
login_required BOOL
order FLOAT64
role STRING
suppress_notifications BOOL
verification_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.
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.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sign_templates (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
are_email_settings_locked BOOL
are_fields_locked BOOL
are_files_locked BOOL
are_options_locked BOOL
are_recipients_locked BOOL
days_valid FLOAT64
email_message STRING
email_subject STRING
id STRING
name STRING
parent_folder__type STRING
parent_folder__etag STRING
parent_folder__id STRING
parent_folder__name STRING
parent_folder__sequence_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: sign_templates__additional_info__non_editable

Section titled “Subtable: sign_templates__additional_info__non_editable”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: sign_templates__additional_info__required__signers

Section titled “Subtable: sign_templates__additional_info__required__signers”
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.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: sign_templates__additional_info__required__signers__list

Section titled “Subtable: sign_templates__additional_info__required__signers__list”
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.
email STRING
is_in_person BOOL
label STRING
order FLOAT64
public_id STRING
role 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.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
trashed_items (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
etag STRING
file_version__type STRING
file_version__id STRING
file_version__sha1 STRING
id STRING
name STRING
sequence_id STRING
sha1 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
address STRING
avatar_url STRING
created_at STRING
id STRING
job_title STRING
language STRING
login STRING
max_upload_size FLOAT64
modified_at STRING
name STRING
phone STRING
space_amount FLOAT64
space_used FLOAT64
status STRING
timezone 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 Box 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 Box?

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

It depends on how much history is in your Box 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.

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 Box, 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 Box 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 Box connector in Kaivo and all of its synced data is deleted with it.

Use file_collaborations and folder_collaborations to review who has access, their role, and any external invite_email.

Bring events and admin_logs into BigQuery to track logins, downloads, and changes over time.

Use the users table’s space_used and space_amount to see how storage is consumed across your account.

Use file_tasks and file_comments to follow review and approval activity.

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