Skip to content
Book a demoStart free
Connectors

Uptick connector

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

Uptick connector pricing, tier and credits on kaivo.io

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

Sync your Uptick field service data into BigQuery with Kaivo to analyse jobs, invoices, asset maintenance, and purchasing costs.

CategoryOther
AuthenticationUsername and password
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Uptick 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 Uptick login. You provide:

Field Description
OAuth Client Secret
The Client Secret of your Uptick OAuth application (Control Panel → Uptick API).

| | Uptick API Account Password |

The password for that Uptick account.

|

Prerequisites

Uptick uses an OAuth 2.0 password grant, so you need an OAuth application plus an Uptick account with API access:

  1. In Uptick, go to Control Panel → Uptick API → Create Application, give it a name and save — Uptick generates a Client ID and Client Secret.
  2. Enter the email and password of the Uptick account to use for API access.

Your Base URL is your Uptick workspace address, e.g. https://your-company.onuptick.com.

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

When you set up the connector, you provide:

Field Description
Base URL
Your Uptick workspace URL, e.g. https://your-company.onuptick.com.

| | OAuth Client ID |

The Client ID of your Uptick OAuth application (Control Panel → Uptick API).

| | Uptick API Account Email |

The email address of the Uptick account used for API access.

|

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

accreditations (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
status STRING
expiry DATE
number STRING
property_id INT64
accreditationtype_id INT64
technician_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
accreditationtypes (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
type STRING
property_specific BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
appointments (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
status STRING
subject STRING
scheduled_start TIMESTAMP
scheduled_end TIMESTAMP
scheduler STRING
notes STRING
address STRING
last_reminder_sent TIMESTAMP
timezone STRING
attendance STRING
category_id INT64
routine_id INT64
task_id INT64
_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.

  • appointments__technicians (4 columns)
assets (49 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
is_active BOOL
internal_note STRING
contractor_note STRING
contractor_ref STRING
is_silent BOOL
is_notoncofo BOOL
uptick_ref STRING
ref STRING
iotdevice_id INT64
label STRING
location STRING
standard_maintenance STRING
standard_performance STRING
standard_installation STRING
compliant BOOL
status STRING
inspection_ref STRING
barcode STRING
inspection_order INT64
serviced_date DATE
base_date DATE
installation_date DATE
total_expected_life INT64
asset_condition STRING
inspected_date DATE
make STRING
model STRING
size STRING
signoff_date DATE
signoff_method STRING
guid STRING
coord_lat FLOAT64
coord_lng FLOAT64
bsecure_latest_sticker_guid STRING
bsecure_resolved_guid STRING
type_id INT64
variant_id INT64
product_id INT64
property_id INT64
contractor_id INT64
serviced_by_id INT64
last_service_result STRING
highest_severity 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.

  • assets__tags (4 columns)
  • assets__servicelevels (4 columns)
assettypes (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
is_active BOOL
is_starred BOOL
is_esm BOOL
name STRING
description STRING
code STRING
icon STRING
standard_maintenance STRING
standard_performance STRING
standard_installation STRING
standard_excerpt STRING
is_lifecycle_enabled BOOL
total_nominal_life INT64
category STRING
subcategory STRING
fire_industry_classification STRING
inspection_criteria STRING
sequence_group STRING
sequence_name STRING
is_sequential_ref BOOL
asset_count INT64
is_majorservice_applicable BOOL
is_component_default BOOL
can_bulk_perform_servicetasks BOOL
default_replacement_product_id INT64
_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.

  • assettypes__tags (4 columns)
  • assettypes__variants (4 columns)
  • assettypes__applicable_routines (4 columns)
  • assettypes__excluded_routinelevels (4 columns)
assettypevariants (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
name STRING
sequence_name STRING
is_active BOOL
icon STRING
type_id INT64
default_replacement_product_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
billingcards (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
created TIMESTAMP
updated TIMESTAMP
is_active BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
billingcontractlineitems (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
billingcontract_id INT64
visible BOOL
product_id INT64
description STRING
unit_price STRING
all_routines BOOL
price_period STRING
type STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
billingcontracts (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
type STRING
property_id INT64
billingcard_id INT64
recurrence STRING
invoice_mode STRING
is_active BOOL
start_date DATE
finish_date DATE
review_date DATE
send_invoice DATE
author_id INT64
authorisation STRING
authorisation_ref STRING
next_due DATE
value STRING
annual_value STRING
period_begin STRING
period_end STRING
notes STRING
priceincrease_policy STRING
priceincrease_auto_next_date DATE
priceincrease_auto_percentage STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
branches (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
code STRING
address STRING
business_hours STRING
email STRING
phone STRING
fax STRING
property_count INT64
user_count INT64
material_markup STRING
subcontracted_task_safety_requirements STRING
subcontracted_task_service_requirements STRING
default_warehouse_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
clientgroups (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
sector STRING
is_active BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
clients (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
ref STRING
name STRING
is_active BOOL
contact_name STRING
contact_organisation STRING
contact_mobile STRING
contact_phone_bh STRING
contact_phone_ah STRING
contact_email STRING
contact_email_cc STRING
contact_address STRING
report_requirements STRING
report_attention STRING
report_email_to STRING
report_email_cc STRING
report_manual BOOL
billing_organisation STRING
billing_requirements STRING
billing_attention STRING
billing_email_to STRING
billing_email_cc STRING
billing_manual BOOL
billing_address STRING
billing_fixedprice BOOL
quoting_autoreminders_enabled BOOL
quoting_requirements STRING
notes STRING
address STRING
material_markup STRING
sector STRING
billingcard_id INT64
pricetier_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
contractors (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
ref STRING
primary_contact STRING
email STRING
email_cc STRING
contact_mobile STRING
contact_bh STRING
contact_ah STRING
address STRING
notes STRING
is_starred BOOL
is_active BOOL
partner_uid STRING
category_id INT64
account_id INT64
supplier_id INT64
accounting_organisation_id INT64
asset_count 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.

  • contractors__tags (4 columns)
  • contractors__skill (4 columns)
  • contractors__serviceareas (4 columns)
  • contractors__zones (4 columns)
costcentres (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
income_account_code STRING
expense_account_code STRING
is_active BOOL
is_default BOOL
branch_id INT64
taskcategory_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
creditnotelineitems (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
account_code STRING
description STRING
unit_price STRING
quantity STRING
subtotal STRING
tax STRING
total STRING
taxcode STRING
taxrate STRING
creditnote_id INT64
product_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
creditnotes (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
status STRING
date DATE
subtotal STRING
tax STRING
total STRING
description STRING
number STRING
partner_uid STRING
invoice_id INT64
_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.

  • creditnotes__lineitems (4 columns)
defectquotelineitems (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
description STRING
unit_price STRING
cost_price STRING
markup STRING
quantity STRING
taxcode STRING
taxrate STRING
subtotal STRING
total STRING
gst STRING
index INT64
estimated_time INT64
product_type STRING
product_id INT64
quote_id INT64
asset_id INT64
remark_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
defectquotes (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
description STRING
ref STRING
created TIMESTAMP
updated TIMESTAMP
status STRING
date DATE
due_date DATE
expiry_date DATE
last_actioned TIMESTAMP
email_template STRING
reminder_email_template STRING
scope_of_works STRING
branch_id INT64
client_id INT64
property_id INT64
author_id INT64
salesperson_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoicelineitems (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
invoice_id INT64
created TIMESTAMP
updated TIMESTAMP
description STRING
index INT64
account_code STRING
quantity STRING
unit_price STRING
gst STRING
total STRING
taxcode STRING
taxrate STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
invoices (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
description STRING
authorisation_ref STRING
currency STRING
date DATE
due_date DATE
gst STRING
is_overdue STRING
is_sent BOOL
number STRING
partner_uid STRING
ref STRING
status STRING
subtotal STRING
synced TIMESTAMP
total STRING
property_id INT64
task_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
products (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
name STRING
type STRING
description STRING
code STRING
sku STRING
upc STRING
account_code STRING
expense_account_code STRING
default_taxcode STRING
internal_note STRING
is_starred BOOL
is_active BOOL
is_stocked BOOL
cost_price STRING
unit_description STRING
unit_price STRING
current_price STRING
category STRING
subcategory STRING
markup STRING
estimated_time INT64
partner_uid STRING
autocomplete_label STRING
supplier_id INT64
accounting_organisation_id INT64
is_attendancefee BOOL
included_labour INT64
included_travel INT64
labour_increment INT64
last_used TIMESTAMP
latest_unit_cost STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
projects (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
status STRING
ref STRING
name STRING
is_active BOOL
category STRING
scope_of_works STRING
retention_rate STRING
final_rebate_rate STRING
expected_start_date DATE
expected_completion_date DATE
actual_start_date TIMESTAMP
actual_completion_date TIMESTAMP
retention_date DATE
order_no STRING
description STRING
branch_id INT64
costcentre_id INT64
client_id INT64
property_id INT64
billingcard_id INT64
supervisor_id INT64
salesperson_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
properties (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
address STRING
coords STRING
timezone STRING
access_inductionreq BOOL
access_logbookreq BOOL
access_schedule STRING
access_signaturereq BOOL
billing_manual BOOL
building_tenancies INT64
client_signature_required BOOL
name STRING
ref STRING
report_manual BOOL
status STRING
bsecure_resolved_guid 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.

  • properties__tags (4 columns)
purchaseorderbilllineitems (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
description STRING
unit_price STRING
quantity STRING
subtotal STRING
gst STRING
total STRING
taxcode STRING
taxrate STRING
index INT64
account_code STRING
purchaseorderbill_id INT64
purchaseorderlineitem_id INT64
product_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchaseorderbills (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
status STRING
invoice_number STRING
invoice_date DATE
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchaseorderdockets (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
number STRING
date DATE
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchaseorderlineitems (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
description STRING
unit_price STRING
quantity STRING
subtotal STRING
gst STRING
total STRING
taxcode STRING
taxrate STRING
index INT64
purchaseorder_ref STRING
is_committed STRING
is_incurred STRING
billed_quantity STRING
docketed_quantity STRING
has_dockets BOOL
purchaseorder_id INT64
product_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
purchaseorders (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
ref STRING
status STRING
all_goods_received BOOL
date DATE
total STRING
supplier_ref STRING
created_via STRING
has_manually_added_costs STRING
currency STRING
fx_rate STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
remarkevents (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
event STRING
notes STRING
remark_id INT64
task_id INT64
servicetask_id INT64
account_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
remarks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
identified TIMESTAMP
ref STRING
is_active BOOL
inactive_date TIMESTAMP
severity INT64
notes STRING
description STRING
resolution STRING
location STRING
last_verified_date TIMESTAMP
is_published BOOL
quoted_date DATE
quote_ref STRING
quote_status STRING
type_id INT64
asset_id INT64
assigned_contractor_id INT64
created_by_id INT64
created_by_contractor_id INT64
status STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
rounds (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
name STRING
is_active BOOL
notes STRING
due DATE
task_count STRING
task_breakdown STRING
chieftan_id INT64
technician_id INT64
branch_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routines (11 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
display_name STRING
due DATE
tolerance_period_start DATE
tolerance_period_end DATE
status STRING
is_processing BOOL
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routineservicelevels (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
is_active BOOL
is_asset_based_level BOOL
estimated_duration STRING
contractor_authorisation_limit STRING
type_id INT64
routineservice_id INT64
servicegroup_id INT64
contractor_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routineserviceleveltypes (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
display_code STRING
applicability_note STRING
internal_note STRING
interval INT64
offset INT64
frequency STRING
tolerance_interval INT64
tolerance_unit STRING
is_active BOOL
is_custom BOOL
is_default_enabled BOOL
is_asset_based BOOL
suggest_to_technician BOOL
uses_due_date_slippage BOOL
supersedes_lower_rank BOOL
service_rank INT64
estimated_duration_per_asset STRING
estimated_duration_per_visit STRING
servicegroup_id INT64
routineservicetype_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routineservices (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
start_date DATE
annual_test_date DATE
end_date DATE
output_type STRING
performance_standard STRING
is_active BOOL
type_id INT64
property_id INT64
servicegroup_id INT64
contractor_id INT64
assettag_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
routineservicetypes (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
short_name STRING
standard_reference STRING
standard_notes STRING
is_active BOOL
is_custom BOOL
default_performance_standard STRING
routineservice_count INT64
applicable_esms STRING
is_annual_certification BOOL
product_id INT64
standard_id INT64
servicegroup_id INT64
_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.

  • routineservicetypes__assettype_set (4 columns)
servicegroups (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
servicequotedoandchargelineitems (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
servicequote_id INT64
description STRING
quantity STRING
unit_price STRING
billingcontract_type STRING
index INT64
estimated_duration STRING
taxcode STRING
taxrate STRING
annual_tax STRING
site_price STRING
annual_subtotal STRING
service_price STRING
created TIMESTAMP
updated TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
servicequotefixedlineitems (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
servicequote_id INT64
description STRING
quantity STRING
unit_price STRING
billingcontract_type STRING
index INT64
estimated_duration STRING
taxcode STRING
taxrate STRING
annual_tax STRING
annual_subtotal STRING
created TIMESTAMP
updated TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
servicequoteproductlineitems (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
servicequote_id INT64
product_id INT64
description STRING
quantity STRING
unit_price STRING
cost_price STRING
subtotal STRING
taxcode STRING
taxrate STRING
tax STRING
total STRING
index INT64
created TIMESTAMP
updated TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
servicequotes (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
description STRING
created TIMESTAMP
updated TIMESTAMP
uuid STRING
ref STRING
status STRING
status_changed_submitted TIMESTAMP
status_changed_approved TIMESTAMP
expiry_date DATE
review_date DATE
template STRING
template_name STRING
scope_of_works_format STRING
upload_path STRING
property_access_schedule STRING
authorisation_date TIMESTAMP
product_subtotal STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
servicetasks (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
due DATE
quantity STRING
unit_price STRING
subtotal STRING
cost_price STRING
from_stock BOOL
markup STRING
notes STRING
is_scheduled BOOL
is_majorservice BOOL
is_quoted BOOL
is_invoiced BOOL
is_billable BOOL
is_scanned BOOL
performed_date TIMESTAMP
quoted_date TIMESTAMP
invoiced_date TIMESTAMP
guid STRING
result STRING
remarks_added_count INT64
active_remarks_count INT64
highest_severity INT64
task_id INT64
item_id INT64
routine_id INT64
remark_id INT64
product_id INT64
technician_id INT64
purchaseorderlineitem_id INT64
routineserviceleveltype_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
subtasks (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
order INT64
performed_date TIMESTAMP
is_performed BOOL
service_task BOOL
site_price STRING
report_task BOOL
billing_task BOOL
billing_period_start_date DATE
billing_period_end_date DATE
task_id INT64
billingcontract_id INT64
product_id INT64
routine_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
suppliers (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
is_active BOOL
name STRING
partner_uid STRING
accounts_name STRING
purchasing_name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
task_profitability (28 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
task_id STRING
updated TIMESTAMP
quoted_cost STRING
estimated_cost STRING
committed_cost STRING
incurred_cost STRING
paid_cost STRING
quoted_sell STRING
estimated_sell STRING
billable STRING
invoiced STRING
received STRING
invoiced_credit STRING
left_to_be_incurred STRING
actual_cost STRING
revised_cost STRING
uninvoiced STRING
net_invoiced STRING
revised_sell STRING
cash_position STRING
quoted_profit STRING
actual_profit STRING
revised_profit STRING
quoted_margin STRING
actual_margin STRING
revised_margin STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
taskcategories (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
name STRING
created TIMESTAMP
updated TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tasks (73 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
deleted TIMESTAMP
ref STRING
description STRING
is_active BOOL
inactive_date TIMESTAMP
due DATE
due_after DATE
pm_date DATE
tolerance_start DATE
tolerance_end DATE
invoiced_date TIMESTAMP
name STRING
scope_of_works STRING
address STRING
coord_lat FLOAT64
coord_lng FLOAT64
access_note STRING
access_window STRING
access_procedure STRING
access_schedule STRING
access_code STRING
internal_note STRING
workorder_url STRING
technician_note STRING
partner_uid STRING
priority INT64
sla_incident_notification_at TIMESTAMP
sla_due_inprogress TIMESTAMP
sla_due_inspected TIMESTAMP
charge_type STRING
notes STRING
invoice_note STRING
estimated_duration STRING
authorisation_name STRING
authorisation_note STRING
authorisation_ref STRING
authorisation_amount STRING
authorisation_date DATE
contractor_note STRING
status_changed_inprogress TIMESTAMP
status_changed_inspected TIMESTAMP
status_changed_complete TIMESTAMP
app_link STRING
timezone STRING
bulk_email_last_sent_at TIMESTAMP
contractor_authorisation_limit STRING
category_id INT64
servicegroup_id INT64
client_id INT64
property_id INT64
billingcard_id INT64
assigned_to_id INT64
assigned_office_id INT64
salesperson_id INT64
technician_id INT64
round_id INT64
branch_id INT64
costcentre_id INT64
parent_task_id INT64
author_id INT64
contractor_id INT64
contractor_assigned_technician_id INT64
updated_by_id STRING
status_id STRING
zone_id INT64
project_id INT64
sla_id INT64
callout_id INT64
_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.

  • tasks__tags (4 columns)
  • tasks__supporting_technicians (4 columns)
  • tasks__required_accreditationtypes (4 columns)
tasksessions (37 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
created TIMESTAMP
updated TIMESTAMP
trashed TIMESTAMP
submitted TIMESTAMP
is_approved BOOL
is_submitted BOOL
type_id INT64
started TIMESTAMP
finished TIMESTAMP
started_coord_lat FLOAT64
started_coord_lng FLOAT64
finished_coord_lat FLOAT64
finished_coord_lng FLOAT64
original_started TIMESTAMP
original_finished TIMESTAMP
description STRING
rate STRING
timezone STRING
multiplier STRING
multiplier_label STRING
sell_rate STRING
cost STRING
sell STRING
submitted_at TIMESTAMP
approved_at TIMESTAMP
task_id INT64
technician_id INT64
sell_product_id INT64
submitted_by_id STRING
approved_by_id STRING
duration INT64
duration_hours STRING
status STRING
payroll_date DATE
_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.
id INT64
updated TIMESTAMP
name STRING
email STRING
partner_uid STRING
date_joined TIMESTAMP
last_login TIMESTAMP
last_access TIMESTAMP
is_active BOOL
is_staff STRING
is_superuser BOOL
license STRING
rate STRING
sell_rate STRING
purchase_order_approval_limit STRING
defectquote_approval_limit STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

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

  • users__addons (4 columns)

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

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

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

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

Use tasks and routines to track service work and maintenance over time.

Join invoices with clients to track revenue from service work.

Use purchaseorders and suppliers to track parts and supplier activity.

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