Skip to content
Book a demoStart free
Connectors

Teamwork connector

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

Teamwork connector pricing, tier and credits on kaivo.io

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

Sync your Teamwork project data into BigQuery with Kaivo to report on tasks, time, and project profitability across your work.

CategoryProject Management
AuthenticationUsername and password
SetupSelf-service

Getting started with the Teamwork connector

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

Connect with your Teamwork login. You provide:

Field Description
Password

When you set up the connector, you provide:

Field Description
Username
Site Name
Your Teamwork subdomain (e.g., mycompany in mycompany.teamwork.com)

| | Start Date |

Any data before this date will not be fetched.

|

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

companies (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
accounts FLOAT64
address_one STRING
address_two STRING
can_see_private BOOL
cid STRING
city STRING
clients FLOAT64
collaborators FLOAT64
company_name_url STRING
contacts FLOAT64
country_code STRING
created_at STRING
email_one STRING
email_three STRING
email_two STRING
fax STRING
id FLOAT64
is_owner BOOL
logo_url STRING
name STRING
phone STRING
state STRING
status STRING
updated_at STRING
website STRING
zip 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.
dashboards (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
color STRING
created_at STRING
deleted BOOL
display_order FLOAT64
id FLOAT64
is_default BOOL
project__type STRING
project__id FLOAT64
project_id FLOAT64
title STRING
updated_at STRING
user__type STRING
user__id FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
forms (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
allow_teamwork_branding BOOL
confirmation_message STRING
content__version FLOAT64
content__description STRING
content__banner__primary_color STRING
content__banner__x FLOAT64
content__banner__y FLOAT64
content__name STRING
content__state STRING
create_form_task BOOL
created_at STRING
created_by__type STRING
created_by__id FLOAT64
host_object__type STRING
host_object__id FLOAT64
id FLOAT64
installation__type STRING
installation__id FLOAT64
is_shared BOOL
prompt_additional_submissions BOOL
show_progress_bar BOOL
state STRING
token__canonical_url STRING
token__value STRING
total_submissions FLOAT64
updated_at STRING
updated_by__type STRING
updated_by__id 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
conditional_logic__enabled BOOL
help STRING
label STRING
name STRING
title STRING
tw_id STRING
tw_type STRING
validation STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: forms__content__definition__conditional_logic__actions

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

Subtable: forms__content__definition__conditional_logic__conditions

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

Subtable: forms__content__definition__conditional_logic__conditions__conditions

Section titled “Subtable: forms__content__definition__conditional_logic__conditions__conditions”
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.
latestactivity (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
activity_type STRING
company__type STRING
company__id FLOAT64
company_id FLOAT64
date_time STRING
due_date STRING
extra_description STRING
for_user__type STRING
for_user__id FLOAT64
for_user_id FLOAT64
for_user_name STRING
id FLOAT64
is_private FLOAT64
item__type STRING
item__id FLOAT64
item_id FLOAT64
item_link STRING
latest_activity_type STRING
link STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
public_info STRING
user__type STRING
user__id FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
me_timers (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
billable BOOL
created_at STRING
deleted BOOL
duration FLOAT64
id FLOAT64
last_started_at STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
running BOOL
server_time STRING
task__type STRING
task__id FLOAT64
task_id FLOAT64
updated_at STRING
user__type STRING
user__id FLOAT64
user_id 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.
duration FLOAT64
from STRING
id FLOAT64
to STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
milestones (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
can_complete BOOL
can_edit BOOL
comments_count FLOAT64
completed BOOL
created_by FLOAT64
created_on STRING
creator_user_id FLOAT64
deadline STRING
description_html STRING
id FLOAT64
is_deleted BOOL
last_changed_on STRING
name STRING
original_due_date STRING
private BOOL
project__type STRING
project__id FLOAT64
project_id FLOAT64
reminder BOOL
status STRING
updated_by FLOAT64
user_following_changes BOOL
user_following_comments BOOL
_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
id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: milestones__responsible_party_ids

Section titled “Subtable: milestones__responsible_party_ids”
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.
milestones_deadlines (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
date STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
notebooks (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
comments_count FLOAT64
contents STRING
created_at STRING
created_by FLOAT64
created_by_user_id FLOAT64
date_created STRING
date_updated STRING
deleted BOOL
id FLOAT64
is_full_width BOOL
is_private BOOL
latest_version_no FLOAT64
lockdown_id FLOAT64
locked BOOL
name STRING
notebook_version__type STRING
notebook_version__id FLOAT64
notebook_version_created_date_time STRING
notebook_version_id FLOAT64
notebook_version_updated_date_time STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
read_comments_count FLOAT64
secure_content BOOL
updated_at STRING
updated_by FLOAT64
updated_by_user_id FLOAT64
user_following_changes BOOL
user_following_comments BOOL
version_count FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: notebooks__change_followers__user_ids

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

Subtable: notebooks__change_followers__users

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

Subtable: notebooks__comment_followers__user_ids

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

Subtable: notebooks__comment_followers__users

Section titled “Subtable: notebooks__comment_followers__users”
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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
notebooks_comments.json (33 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
body STRING
comment_link STRING
content_type STRING
date_last_edited STRING
deleted BOOL
deleted_by_user_id FLOAT64
file_count FLOAT64
html_body STRING
id FLOAT64
installation__type STRING
installation__id FLOAT64
installation_id FLOAT64
is_private FLOAT64
last_edited_by FLOAT64
last_edited_by_user_id FLOAT64
lockdown_id FLOAT64
meta__is_read BOOL
meta__permissions__can_delete BOOL
meta__permissions__can_edit BOOL
object__type STRING
object__id FLOAT64
object_id FLOAT64
object_type STRING
people_notified_count FLOAT64
posted_by FLOAT64
posted_by_user_id FLOAT64
posted_date_time STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
reactions_count 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.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
people (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
avatar_url STRING
can_add_projects BOOL
company__type STRING
company__id FLOAT64
company_id FLOAT64
company_role_id FLOAT64
deleted BOOL
email STRING
first_name STRING
id FLOAT64
is_admin BOOL
is_client_user BOOL
is_service_account BOOL
last_name STRING
length_of_day FLOAT64
timezone STRING
title STRING
user_cost FLOAT64
user_rate FLOAT64
working_hour__type STRING
working_hour__id FLOAT64
working_hours_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projectcategories (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color STRING
count FLOAT64
id FLOAT64
name STRING
parent__type STRING
parent__id FLOAT64
parent_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (87 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
description STRING
active_pages__billing BOOL
active_pages__board BOOL
active_pages__comments BOOL
active_pages__files BOOL
active_pages__finance BOOL
active_pages__forms BOOL
active_pages__gantt BOOL
active_pages__links BOOL
active_pages__list BOOL
active_pages__messages BOOL
active_pages__milestones BOOL
active_pages__notebooks BOOL
active_pages__proofs BOOL
active_pages__risk_register BOOL
active_pages__table BOOL
active_pages__tasks BOOL
active_pages__tickets BOOL
active_pages__time BOOL
allow_notify_anyone BOOL
announcement STRING
company__type STRING
company__id FLOAT64
company_id FLOAT64
created_at STRING
created_by FLOAT64
default_privacy STRING
direct_file_uploads_enabled BOOL
end_at STRING
end_date STRING
financial_budget__type STRING
financial_budget__id FLOAT64
financial_budget_id FLOAT64
harvest_timers_enabled BOOL
id FLOAT64
integrations__google_drive__access STRING
integrations__google_drive__enabled BOOL
integrations__google_drive__folder STRING
integrations__google_drive__folder_name STRING
integrations__one_drive_business__account STRING
integrations__one_drive_business__enabled BOOL
integrations__one_drive_business__folder STRING
integrations__one_drive_business__folder_name STRING
integrations__sharepoint__account STRING
integrations__sharepoint__enabled BOOL
integrations__sharepoint__folder STRING
integrations__sharepoint__folder_name STRING
integrations__xero__base_currency STRING
integrations__xero__connected BOOL
integrations__xero__country_code STRING
integrations__xero__enabled BOOL
integrations__xero__organisation STRING
is_billable BOOL
is_on_boarding_project BOOL
is_sample_project BOOL
logo STRING
name STRING
notify_comment_include_creator BOOL
notify_everyone BOOL
notify_task_assignee BOOL
overview_start_page STRING
owned_by FLOAT64
owner_id FLOAT64
privacy_enabled BOOL
project_owner__type STRING
project_owner__id FLOAT64
project_owner_id FLOAT64
reply_by_email_enabled BOOL
show_announcement BOOL
skip_weekends BOOL
start_at STRING
start_date STRING
start_page STRING
status STRING
sub_status STRING
tasks_start_page STRING
time_budget__type STRING
time_budget__id FLOAT64
time_budget_id FLOAT64
update__type STRING
update__id FLOAT64
update_id FLOAT64
updated_at STRING
updated_by 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.
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 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
id 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
id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects_active (3 columns)
Column Type Description
_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.
projects_billable (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
color STRING
id FLOAT64
name STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasklists (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
created_at STRING
display_order FLOAT64
id FLOAT64
is_pinned BOOL
is_private BOOL
name STRING
project__type STRING
project__id FLOAT64
project_id FLOAT64
status STRING
updated_at STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (35 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
accumulated_estimated_minutes FLOAT64
created_at STRING
created_by FLOAT64
created_by_user_id FLOAT64
date_updated STRING
decimal_display_order FLOAT64
description_content_type STRING
display_order FLOAT64
due_date STRING
estimate_minutes FLOAT64
has_desk_tickets BOOL
id FLOAT64
is_archived BOOL
is_private FLOAT64
name STRING
notify BOOL
original_due_date STRING
parent_task_id FLOAT64
priority STRING
progress FLOAT64
start_date STRING
status STRING
tasklist__type STRING
tasklist__id FLOAT64
tasklist_id FLOAT64
updated_at STRING
updated_by FLOAT64
user_permissions__can_add_subtasks BOOL
user_permissions__can_complete BOOL
user_permissions__can_edit BOOL
user_permissions__can_log_time BOOL
user_permissions__can_view_est_time BOOL
_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 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
id 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
id 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.
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 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 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.
stage_id FLOAT64
stage_task_display_order FLOAT64
workflow_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
time_entries (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
billable BOOL
created_at STRING
date_created STRING
deleted BOOL
has_start_time BOOL
id FLOAT64
is_billable BOOL
logged_by FLOAT64
logged_by_user_id FLOAT64
minutes FLOAT64
project__type STRING
project__id FLOAT64
project_id FLOAT64
task__type STRING
task__id FLOAT64
task_id FLOAT64
time_logged STRING
user__type STRING
user__id FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
timelog_totals (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
sub_tasks__estimated_minutes FLOAT64
sub_tasks__minutes FLOAT64
sub_tasks__minutes_billable FLOAT64
time_totals__estimated_minutes FLOAT64
time_totals__estimated_minutes_active FLOAT64
time_totals__estimated_minutes_completed FLOAT64
time_totals__estimated_minutes_filtered FLOAT64
time_totals__estimated_minutes_with_logged_time FLOAT64
time_totals__minutes FLOAT64
time_totals__minutes_billable FLOAT64
time_totals__minutes_billed FLOAT64
time_totals__minutes_non_billable FLOAT64
time_totals__minutes_non_billed FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
timesheets (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
dates___2024_09_01__total_minutes FLOAT64
dates___2024_09_02__total_minutes FLOAT64
dates___2024_09_03__total_minutes FLOAT64
dates___2024_09_04__total_minutes FLOAT64
dates___2024_09_05__total_minutes FLOAT64
entity__type STRING
entity__id FLOAT64
is_custom_row BOOL
total FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workload_planners (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
capacities___2024_09_02__capacity FLOAT64
capacities___2024_09_02__estimate_minutes_total FLOAT64
capacities___2024_09_02__length_of_day_minutes FLOAT64
capacities___2024_09_03__capacity FLOAT64
capacities___2024_09_03__estimate_minutes_total FLOAT64
capacities___2024_09_03__length_of_day_minutes FLOAT64
capacities___2024_09_04__capacity FLOAT64
capacities___2024_09_04__estimate_minutes_total FLOAT64
capacities___2024_09_04__length_of_day_minutes FLOAT64
capacities___2024_09_05__capacity FLOAT64
capacities___2024_09_05__estimate_minutes_total FLOAT64
capacities___2024_09_05__length_of_day_minutes FLOAT64
user__type STRING
user__id FLOAT64
user_id FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: workload_planners__capacities___2024_09_02__tasks

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

Subtable: workload_planners__capacities___2024_09_03__tasks

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

Subtable: workload_planners__capacities___2024_09_04__tasks

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

Subtable: workload_planners__capacities___2024_09_05__tasks

Section titled “Subtable: workload_planners__capacities___2024_09_05__tasks”
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.
estimate_minutes FLOAT64
task_id FLOAT64
_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 Teamwork 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 Teamwork?

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

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

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

Track tasks and milestones against deadlines to see what is on time and what is slipping.

Use time_entries and timelog_totals to compare logged time against budgets.

Join projects_billable with time entries to measure margin by project.

Bring people and workload_planners together to balance load across the team.

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

  • ClickUp: Sync ClickUp to BigQuery.
  • GitHub: Sync GitHub to BigQuery.
  • GitLab: Sync GitLab to BigQuery.
  • Harvest: Sync Harvest to BigQuery.
  • Jira: Sync Jira to BigQuery.
  • Kellokortti: Sync Kellokortti to BigQuery.