Skip to content
Book a demoStart free
Connectors

Deputy connector

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

Deputy connector pricing, tier and credits on kaivo.io

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

Sync your Deputy scheduling and time data into BigQuery with Kaivo to analyse labour cost, hours, and staffing across your locations.

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

When you set up the connector, you provide:

Field Description
Base URL
The base url for your deputy account to make API requests

|

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

addresses (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
city STRING
country FLOAT64
created STRING
creator FLOAT64
id FLOAT64
modified STRING
postcode STRING
print STRING
state STRING
street1 STRING
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
award_lists (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
award_code STRING
country_code STRING
employment_term FLOAT64
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
categories (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
category STRING
created STRING
creator FLOAT64
group STRING
id FLOAT64
modified STRING
sort_order FLOAT64
stafflog BOOL
system BOOL
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
comments (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
comment STRING
created STRING
creator FLOAT64
id FLOAT64
ignore_permission BOOL
in_feed BOOL
modified STRING
orm STRING
rec_id FLOAT64
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
company_periods (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
company FLOAT64
created STRING
creator FLOAT64
date_end STRING
date_start STRING
end FLOAT64
id FLOAT64
modified STRING
pay_period FLOAT64
start FLOAT64
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
departments (36 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
address FLOAT64
address_object JSON
colour STRING
company FLOAT64
company_address FLOAT64
company_code STRING
company_name STRING
created STRING
creator FLOAT64
id FLOAT64
modified STRING
operational_unit_name STRING
parent_operational_unit FLOAT64
payroll_export_name STRING
roster_sort_order FLOAT64
show_on_roster BOOL
_dp_meta_data__address_object__city STRING
_dp_meta_data__address_object__country FLOAT64
_dp_meta_data__address_object__created STRING
_dp_meta_data__address_object__creator FLOAT64
_dp_meta_data__address_object__id FLOAT64
_dp_meta_data__address_object__modified STRING
_dp_meta_data__address_object__postcode STRING
_dp_meta_data__address_object__print STRING
_dp_meta_data__address_object__state STRING
_dp_meta_data__address_object__street1 STRING
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employee (27 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
allow_appraisal BOOL
company FLOAT64
contact FLOAT64
created STRING
creator FLOAT64
display_name STRING
first_name STRING
history_id FLOAT64
id FLOAT64
last_name STRING
modified STRING
photo FLOAT64
pronouns FLOAT64
role FLOAT64
start_date STRING
stress_profile FLOAT64
user_id FLOAT64
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employee_agreements (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
company_name STRING
config STRING
contract FLOAT64
contract_file FLOAT64
created STRING
creator FLOAT64
emp_type FLOAT64
employee_id FLOAT64
history_id FLOAT64
id FLOAT64
modified STRING
pay_period FLOAT64
pay_point FLOAT64
payroll_id STRING
salary_pay_rule FLOAT64
start_date STRING
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
employees (38 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
allow_appraisal BOOL
allow_login BOOL
analytics_id STRING
can_ask_to_show_pin BOOL
company FLOAT64
contact FLOAT64
contract JSON
created STRING
creator FLOAT64
display_name STRING
email STRING
employee_hourly_rate FLOAT64
first_name STRING
has_android_token BOOL
has_enabled2_fa BOOL
has_i_phone_token BOOL
history_id FLOAT64
id FLOAT64
img STRING
is_subordinate BOOL
last_name STRING
mobile STRING
modified STRING
payroll_id STRING
photo FLOAT64
photo_link_id STRING
pronouns FLOAT64
role FLOAT64
start_date STRING
status FLOAT64
stress_profile FLOAT64
training_array STRING
user_id FLOAT64
user_name STRING
_dp_meta_data__system 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 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.
agreement1 FLOAT64
agreement2 FLOAT64
agreement3 FLOAT64
company FLOAT64
created STRING
creator FLOAT64
employee_id FLOAT64
id FLOAT64
modified STRING
sort_order FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
locations (40 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
address FLOAT64
business_number STRING
code STRING
company_name STRING
contact FLOAT64
created STRING
creator FLOAT64
id FLOAT64
is_payroll_entity BOOL
is_workplace BOOL
modified STRING
parent_company FLOAT64
payroll_export_code STRING
trading_name STRING
_dp_meta_data__address_object__country FLOAT64
_dp_meta_data__address_object__created STRING
_dp_meta_data__address_object__creator FLOAT64
_dp_meta_data__address_object__id FLOAT64
_dp_meta_data__address_object__modified STRING
_dp_meta_data__address_object__print STRING
_dp_meta_data__address_object__state STRING
_dp_meta_data__address_object__street1 STRING
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__geo__created STRING
_dp_meta_data__geo__creator FLOAT64
_dp_meta_data__geo__id FLOAT64
_dp_meta_data__geo__latitude FLOAT64
_dp_meta_data__geo__longitude FLOAT64
_dp_meta_data__geo__modified STRING
_dp_meta_data__geo__orm STRING
_dp_meta_data__geo__rec_id FLOAT64
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
news_feed (29 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL
confirm_text STRING
content STRING
created STRING
creator FLOAT64
disable_comment BOOL
id FLOAT64
keyword STRING
modified STRING
show_from STRING
type FLOAT64
_dp_meta_data__can_delete BOOL
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__reactions___1 FLOAT64
_dp_meta_data__reactions___2 FLOAT64
_dp_meta_data__reactions___3 FLOAT64
_dp_meta_data__reactions___4 FLOAT64
_dp_meta_data__reactions___5 FLOAT64
_dp_meta_data__reactions___6 FLOAT64
_dp_meta_data__require_confirmation BOOL
_dp_meta_data__require_my_confirm BOOL
_dp_meta_data__system STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: news_feed___dp_meta_data__assigned_users

Section titled “Subtable: news_feed___dp_meta_data__assigned_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.
display_name STRING
employee FLOAT64
employee_profile FLOAT64
id FLOAT64
photo STRING
pronouns FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: news_feed___dp_meta_data__comments

Section titled “Subtable: news_feed___dp_meta_data__comments”
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: news_feed___dp_meta_data__companies

Section titled “Subtable: news_feed___dp_meta_data__companies”
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.
active BOOL
address FLOAT64
business_number STRING
code STRING
company_name STRING
contact FLOAT64
created STRING
creator FLOAT64
id FLOAT64
is_payroll_entity BOOL
is_workplace BOOL
modified STRING
parent_company FLOAT64
payroll_export_code STRING
trading_name STRING
_dp_meta_data__address_object__country FLOAT64
_dp_meta_data__address_object__created STRING
_dp_meta_data__address_object__creator FLOAT64
_dp_meta_data__address_object__id FLOAT64
_dp_meta_data__address_object__modified STRING
_dp_meta_data__address_object__print STRING
_dp_meta_data__address_object__state STRING
_dp_meta_data__address_object__street1 STRING
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__geo__created STRING
_dp_meta_data__geo__creator FLOAT64
_dp_meta_data__geo__id FLOAT64
_dp_meta_data__geo__latitude FLOAT64
_dp_meta_data__geo__longitude FLOAT64
_dp_meta_data__geo__modified STRING
_dp_meta_data__geo__orm STRING
_dp_meta_data__geo__rec_id FLOAT64
_dp_meta_data__system 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.
created STRING
creator FLOAT64
download_link STRING
dynamic_link STRING
height FLOAT64
id FLOAT64
linkid STRING
modified STRING
name STRING
p5050_link STRING
preview_link STRING
session FLOAT64
size FLOAT64
tempid STRING
type STRING
width FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: news_feed___dp_meta_data__memo_logs

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

Subtable: news_feed___dp_meta_data__user_reaction

Section titled “Subtable: news_feed___dp_meta_data__user_reaction”
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.
tasks (26 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
answer STRING
comment STRING
created STRING
date STRING
day_timestamp FLOAT64
group_id FLOAT64
id FLOAT64
modified STRING
op_unit_id FLOAT64
question STRING
sort_order FLOAT64
task_setup_id FLOAT64
type FLOAT64
user_entry FLOAT64
user_responsible FLOAT64
_dp_meta_data__system STRING
_dp_meta_data__user_entry_info__display_name STRING
_dp_meta_data__user_entry_info__employee FLOAT64
_dp_meta_data__user_entry_info__id FLOAT64
_dp_meta_data__user_entry_info__photo STRING
_dp_meta_data__user_responsible_info__display_name STRING
_dp_meta_data__user_responsible_info__employee FLOAT64
_dp_meta_data__user_responsible_info__id FLOAT64
_dp_meta_data__user_responsible_info__photo STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
timesheets (81 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
auto_pay_rule_approved BOOL
auto_processed BOOL
auto_rounded BOOL
auto_time_approved BOOL
created STRING
creator FLOAT64
date STRING
disputed BOOL
employee FLOAT64
employee_agreement FLOAT64
employee_history FLOAT64
end_time FLOAT64
end_time_localized STRING
id FLOAT64
invoiced BOOL
is_in_progress BOOL
is_leave BOOL
marked_paid_unpaid_at STRING
mealbreak STRING
mealbreak_slots STRING
metadata STRING
modified STRING
on_cost FLOAT64
operational_unit FLOAT64
operational_unit_object__active BOOL
operational_unit_object__address FLOAT64
operational_unit_object__address_object__city STRING
operational_unit_object__address_object__country FLOAT64
operational_unit_object__address_object__created STRING
operational_unit_object__address_object__creator FLOAT64
operational_unit_object__address_object__id FLOAT64
operational_unit_object__address_object__modified STRING
operational_unit_object__address_object__postcode STRING
operational_unit_object__address_object__print STRING
operational_unit_object__address_object__state STRING
operational_unit_object__address_object__street1 STRING
operational_unit_object__colour STRING
operational_unit_object__company FLOAT64
operational_unit_object__company_address FLOAT64
operational_unit_object__company_code STRING
operational_unit_object__company_name STRING
operational_unit_object__created STRING
operational_unit_object__creator FLOAT64
operational_unit_object__id FLOAT64
operational_unit_object__modified STRING
operational_unit_object__operational_unit_name STRING
operational_unit_object__parent_operational_unit FLOAT64
operational_unit_object__payroll_export_name STRING
operational_unit_object__roster_sort_order FLOAT64
operational_unit_object__show_on_roster BOOL
pay_rule_approved BOOL
pay_staged BOOL
paycycle_id FLOAT64
real_time BOOL
review_state FLOAT64
start_time FLOAT64
start_time_localized STRING
time_approved BOOL
total_time FLOAT64
total_time_inv FLOAT64
validation_flag FLOAT64
_dp_meta_data__creator_info__display_name STRING
_dp_meta_data__creator_info__employee FLOAT64
_dp_meta_data__creator_info__employee_profile FLOAT64
_dp_meta_data__creator_info__id FLOAT64
_dp_meta_data__creator_info__photo STRING
_dp_meta_data__creator_info__pronouns FLOAT64
_dp_meta_data__employee_info__display_name STRING
_dp_meta_data__employee_info__employee FLOAT64
_dp_meta_data__employee_info__employee_profile FLOAT64
_dp_meta_data__employee_info__id FLOAT64
_dp_meta_data__employee_info__photo STRING
_dp_meta_data__employee_info__pronouns FLOAT64
_dp_meta_data__operational_unit_info__company FLOAT64
_dp_meta_data__operational_unit_info__company_name STRING
_dp_meta_data__operational_unit_info__id FLOAT64
_dp_meta_data__operational_unit_info__label_with_company STRING
_dp_meta_data__operational_unit_info__operational_unit_name STRING
_dp_meta_data__system 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.

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

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

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

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

Use timesheets with employee_agreements to track labour cost against your sales.

Join timesheets with employees to measure scheduled versus actual hours.

Use locations and departments to see where you are over or understaffed.

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