Skip to content
Book a demoStart free
Connectors

When I Work connector

Set up the When I Work connector in Kaivo: authentication, configuration, the 12 BigQuery tables it syncs, and answers to common questions.

When I Work connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your When I Work 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 When I Work scheduling and time data into BigQuery with Kaivo to analyse labour cost, hours, and staffing.

CategoryHR
AuthenticationUsername and password
SetupSelf-service

Getting started with the When I Work connector

Section titled “Getting started with the When I Work connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your When I Work 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 When I Work login. You provide:

Field Description
Email
Your When I Work account email address.

| | Password |

Your When I Work account password.

|

Tables and columns synced from When I Work

Section titled “Tables and columns synced from When I Work”

Kaivo syncs 12 tables from When I Work into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

account (238 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
agent_id FLOAT64
attendance_alert_employee FLOAT64
attendance_alert_manager FLOAT64
attendance_freemium BOOL
availability_migrated FLOAT64
bad_credit_card BOOL
billing_address STRING
billing_city STRING
billing_country FLOAT64
billing_discount FLOAT64
billing_engine FLOAT64
billing_phone STRING
billing_state STRING
billing_type FLOAT64
billing_zip STRING
business_address_confirmed BOOL
business_id STRING
cancelreason_feedback STRING
cancelreason_id FLOAT64
company STRING
converted_at BOOL
country__dialing_code FLOAT64
country__id FLOAT64
country__is_deleted BOOL
country__is_enabled FLOAT64
country__iso2 STRING
country__iso3 STRING
country__name STRING
country__sms_cost FLOAT64
country__sms_credit_cost FLOAT64
country__updated_by STRING
country_id FLOAT64
created_at STRING
credit_attempts FLOAT64
credit_balance FLOAT64
credit_eft_number STRING
credit_email STRING
credit_exp STRING
credit_name STRING
credit_number STRING
credit_phone_number STRING
credit_recurring_day FLOAT64
deactivated_reason_id FLOAT64
deleted_at STRING
employee_count FLOAT64
enabled BOOL
group STRING
has_billing BOOL
has_saml BOOL
id FLOAT64
inactive STRING
industry_id FLOAT64
invalidated_by STRING
is_deactivated FLOAT64
is_default_location_address BOOL
is_deleted BOOL
is_demo BOOL
is_invalid FLOAT64
last_active STRING
limited_features__shift_acknowledgement BOOL
location_count FLOAT64
logo STRING
master_id FLOAT64
organization_id FLOAT64
owner__email STRING
owner__id FLOAT64
owner__name STRING
payroll_date STRING
payroll_hours_max FLOAT64
payroll_overtime_multiplier FLOAT64
place__address STRING
place__business_name STRING
place__country STRING
place__formatted_phone_number STRING
place__id FLOAT64
place__international_phone_number STRING
place__latitude FLOAT64
place__locality STRING
place__longitude FLOAT64
place__place_id STRING
place__postal_code STRING
place__region STRING
place__street_name STRING
place__street_number STRING
place__sub_locality STRING
place__subpremise STRING
place__updated_at STRING
place__updated_by STRING
place__website STRING
place_confirmed BOOL
place_id FLOAT64
plan_custom FLOAT64
plan_expires STRING
plan_id FLOAT64
plan_texting FLOAT64
plan_type FLOAT64
plan_units FLOAT64
previous_plan_id FLOAT64
previous_plan_units FLOAT64
previous_type FLOAT64
primary_contact FLOAT64
real_type FLOAT64
ref_employees FLOAT64
ref_plan_id FLOAT64
ref_status STRING
referral_code STRING
referral_id FLOAT64
referred_by STRING
settings__attendance__trial__activated BOOL
settings__attendance__trial__enabled BOOL
settings__availability__days_notice FLOAT64
settings__availability__enabled BOOL
settings__availability__is_public BOOL
settings__billing__recurring BOOL
settings__breaks__break_rules__enabled BOOL
settings__breaks__paid__track_missed BOOL
settings__breaks__unpaid__auto_deduct BOOL
settings__breaks__unpaid__enabled BOOL
settings__breaks__unpaid__manually_record BOOL
settings__clockin__enabled BOOL
settings__clockin__mobile__enabled BOOL
settings__clockin__mobile__radius FLOAT64
settings__clockin__mobile__strict BOOL
settings__clockin__mobile__strict_out BOOL
settings__clockin__photo__enabled BOOL
settings__clockin__window FLOAT64
settings__clockin__work__enabled BOOL
settings__clockin__work__radius FLOAT64
settings__clockin__work__strict BOOL
settings__clockin__work__strict_out BOOL
settings__conversations__enabled BOOL
settings__integrations__revel BOOL
settings__integrations__square BOOL
settings__marketing__attribution_id STRING
settings__marketing__funnel STRING
settings__on_demand_pay__enabled BOOL
settings__payroll__type FLOAT64
settings__payroll__adp_enabled BOOL
settings__payroll__adp_viewable BOOL
settings__payroll__dbl_multiplier FLOAT64
settings__payroll__enabled BOOL
settings__payroll__hours_dot_daily FLOAT64
settings__payroll__hours_dot_daily_enabled BOOL
settings__payroll__hours_max FLOAT64
settings__payroll__hours_max_daily FLOAT64
settings__payroll__hours_max_daily_enabled BOOL
settings__payroll__hours_max_enabled BOOL
settings__payroll__is_onboarded BOOL
settings__payroll__max_enforcement__enabled BOOL
settings__payroll__ot_alerts_clockin BOOL
settings__payroll__ot_alerts_clockout BOOL
settings__payroll__ot_alerts_within FLOAT64
settings__payroll__ot_multiplier FLOAT64
settings__payroll__reveal_attendance BOOL
settings__payroll__rounding__enabled BOOL
settings__payroll__rounding__minute_increment FLOAT64
settings__payroll__timesheets BOOL
settings__payroll__tips_tracking BOOL
settings__payroll__use_sow_for_ot BOOL
settings__payroll__work_day_start STRING
settings__payroll_check__days_to_pay_date FLOAT64
settings__payroll_check__enabled BOOL
settings__payroll_check__first_pay_period_id FLOAT64
settings__payroll_check__is_onboarded BOOL
settings__payroll_check__rejected BOOL
settings__payroll_check__requested BOOL
settings__permissions__text_credits FLOAT64
settings__privacy__enabled BOOL
settings__role_permissions__managers__can_manage_account_settings BOOL
settings__role_permissions__managers__can_manage_workplace_objects BOOL
settings__role_permissions__supervisors__can_approve_own_timesheet BOOL
settings__role_permissions__supervisors__can_edit_all_shift_details BOOL
settings__role_permissions__supervisors__can_edit_employee_timesheets BOOL
settings__role_permissions__supervisors__can_manage_workplace_objects BOOL
settings__role_permissions__supervisors__can_view_employee_wages BOOL
settings__schedule___24hour BOOL
settings__schedule__currency STRING
settings__schedule__enabled BOOL
settings__schedule__is_visible BOOL
settings__schedule__open_scheduling BOOL
settings__schedule__positions_only BOOL
settings__schedule__preferred_hours BOOL
settings__schedule__shared_openshifts BOOL
settings__schedule__shift_acknowledgement BOOL
settings__schedule__sort_employees FLOAT64
settings__schedule__split_shifts FLOAT64
settings__schedule__start_of_week FLOAT64
settings__schedule__track_absences BOOL
settings__schedule__worktags BOOL
settings__scheduling_rules__enabled BOOL
settings__scheduling_rules__max_consecutive_days__enabled BOOL
settings__scheduling_rules__max_days_in_week__enabled BOOL
settings__scheduling_rules__min_hours_between_shifts_diff_day__enabled BOOL
settings__scheduling_rules__min_hours_between_shifts_same_day__enabled BOOL
settings__social__enabled BOOL
settings__swaps__drop_hours_before FLOAT64
settings__swaps__enable_drops BOOL
settings__swaps__enable_partial_openshift BOOL
settings__swaps__enable_releases BOOL
settings__swaps__enable_swaps BOOL
settings__swaps__enabled BOOL
settings__swaps__manager_approval BOOL
settings__swaps__partial_openshift_coverage FLOAT64
settings__swaps__release_hours_before FLOAT64
settings__swaps__swap_hours_before FLOAT64
settings__tasks__enabled BOOL
settings__timeoff__days_notice STRING
settings__timeoff__enabled BOOL
settings__timeoff__is_public BOOL
settings__timeoff__manager_approval BOOL
settings__timeoff__max_hours_per_day FLOAT64
settings__timeoff__supervisor_autoapprove BOOL
settings__workchat__custom_channels_allowed BOOL
settings__workchat__enabled BOOL
settings__workchat__last_enabled_date STRING
settings__workchat__managed_channel_conversations_allowed BOOL
split_shifts FLOAT64
subdomain STRING
tax_exemption STRING
text_credits FLOAT64
time_format FLOAT64
timezone_id FLOAT64
timezone_name STRING
trial_created_at STRING
trial_length FLOAT64
updated_at STRING
updated_by STRING
user_count FLOAT64
user_count_local FLOAT64
utm_campaign STRING
utm_content STRING
utm_medium STRING
utm_source STRING
utm_term STRING
wb_expires 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 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.
key STRING
show 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 STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: account__settings__breaks__break_rules__rules

Section titled “Subtable: account__settings__breaks__break_rules__rules”
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: account__settings__on_demand_pay__providers

Section titled “Subtable: account__settings__on_demand_pay__providers”
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.
enabled BOOL
id STRING
name STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value JSON
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
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.
blocks (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
break_time FLOAT64
color STRING
created_at STRING
end_time STRING
id FLOAT64
is_shared FLOAT64
location_id FLOAT64
notes STRING
position_id FLOAT64
requires_openshift_approval FLOAT64
start_time STRING
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
locations (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
address STRING
created_at STRING
deleted_at STRING
id FLOAT64
ip_address STRING
is_default FLOAT64
is_deleted BOOL
latitude FLOAT64
longitude FLOAT64
max_hours FLOAT64
name STRING
place__address STRING
place__business_name STRING
place__country STRING
place__formatted_phone_number STRING
place__id FLOAT64
place__international_phone_number STRING
place__latitude FLOAT64
place__locality STRING
place__longitude FLOAT64
place__place_id STRING
place__postal_code STRING
place__region STRING
place__street_name STRING
place__street_number STRING
place__sub_locality STRING
place__subpremise STRING
place__updated_at STRING
place__updated_by STRING
place__website STRING
place_confirmed BOOL
place_id FLOAT64
radius FLOAT64
sort FLOAT64
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
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.
openshiftapprovalrequests (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
more BOOL
page FLOAT64
total FLOAT64
uid FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: openshiftapprovalrequests__openshiftapprovalrequests

Section titled “Subtable: openshiftapprovalrequests__openshiftapprovalrequests”
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.
payrolls (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
closed_at STRING
created_at STRING
creator_id FLOAT64
end_date STRING
id FLOAT64
is_closed BOOL
is_edited FLOAT64
is_finalized BOOL
notes STRING
offset STRING
start_date STRING
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payrolls_notices (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
uid 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.
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.
positions (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
account_id FLOAT64
color STRING
created_at STRING
id FLOAT64
is_deleted BOOL
name STRING
sort FLOAT64
tips_tracking BOOL
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
requests (25 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
account_id FLOAT64
canceled_by FLOAT64
completed FLOAT64
completed_at STRING
created_at STRING
creator_id FLOAT64
days_completed FLOAT64
days_requested FLOAT64
end_time STRING
hours FLOAT64
id FLOAT64
is_all_day FLOAT64
paid BOOL
start_time STRING
status FLOAT64
type_id FLOAT64
type_label STRING
updated_at STRING
updated_by STRING
updater_id FLOAT64
user_id FLOAT64
user_status 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 FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
sites (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING
account_id FLOAT64
address STRING
color STRING
created_at STRING
deleted_at STRING
id FLOAT64
is_deleted BOOL
latitude FLOAT64
location_id FLOAT64
longitude FLOAT64
name STRING
place_id STRING
postal_code STRING
radius FLOAT64
updated_at STRING
updated_by STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
times (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
end STRING
start STRING
uid 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.
timezones (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING
name STRING
offset FLOAT64
olson_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (89 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type FLOAT64
account_id FLOAT64
activated BOOL
affiliate FLOAT64
alert_settings__absences__email BOOL
alert_settings__absences__sms BOOL
alert_settings__attendance__email BOOL
alert_settings__attendance__sms BOOL
alert_settings__availability__email BOOL
alert_settings__availability__sms BOOL
alert_settings__hire__email BOOL
alert_settings__hire__sms BOOL
alert_settings__new_employee__email BOOL
alert_settings__new_employee__sms BOOL
alert_settings__ot_alerts__email BOOL
alert_settings__ot_alerts__sms BOOL
alert_settings__payroll__sms BOOL
alert_settings__reminders__email BOOL
alert_settings__reminders__sms BOOL
alert_settings__reporting__email BOOL
alert_settings__reporting__sms BOOL
alert_settings__schedule__email BOOL
alert_settings__schedule__sms BOOL
alert_settings__shift_bidding__email BOOL
alert_settings__shift_bidding__sms BOOL
alert_settings__swaps__email BOOL
alert_settings__swaps__sms BOOL
alert_settings__timeoff__email BOOL
alert_settings__timeoff__sms BOOL
alert_settings__workchat__alerts BOOL
alert_settings__workchat__badge_icon BOOL
alert_settings__workchat__in_app BOOL
alert_settings__workplace_alerts__email BOOL
alert_settings__workplace_alerts__sms BOOL
avatar__size STRING
avatar__url STRING
avatar_key STRING
c2dm_auth_key FLOAT64
country_code STRING
country_id FLOAT64
created_at STRING
created_by FLOAT64
delete_reason STRING
deleted_at STRING
deletion_queued BOOL
edit_personal_timesheet FLOAT64
email STRING
employee_code STRING
employment_type STRING
exclude_from_payrolls FLOAT64
first_name STRING
hourly_rate FLOAT64
hours_max FLOAT64
hours_preferred FLOAT64
id FLOAT64
infotips STRING
invited_at STRING
is_active BOOL
is_deleted BOOL
is_hidden BOOL
is_internal_login BOOL
is_onboarded BOOL
is_payroll BOOL
is_private BOOL
is_trusted FLOAT64
last_login STRING
last_name STRING
login_id FLOAT64
middle_name STRING
migration_id FLOAT64
notes STRING
notified_at STRING
password BOOL
phone_number STRING
reminder_time FLOAT64
role FLOAT64
sleep_end STRING
sleep_start STRING
sort___5696679 FLOAT64
start_date STRING
suppress_alerts FLOAT64
terminated_at STRING
timezone_id FLOAT64
timezone_name STRING
token_valid_after STRING
updated_at STRING
uuid STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
value FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
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 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 When I Work 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 When I Work?

Section titled “How long does the initial sync take for When I Work?”

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

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

Use payrolls and times to track labour cost against your sales.

Join times with users to measure scheduled versus actual hours.

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

Use When I Work data in your AI and BI tools

Section titled “Use When I Work data in your AI and BI tools”

Once When I Work 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 When I Work 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 When I Work connector pricing and plan details.