Skip to content
Book a demoStart free
Connectors

Kellokortti connector

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

Kellokortti connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Kellokortti 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 Kellokortti time tracking data into BigQuery with Kaivo to report on hours, attendance, and projects alongside the rest of your data.

CategoryHR, Project Management
AuthenticationUsername and password
SetupSelf-service

Getting started with the Kellokortti connector

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

Field Description
Password
Available in Kellokortti interface at “Työkalut > Tiedonsiirto > Tiedonsiirtoasetukset > API-avain”.

|

When you set up the connector, you provide:

Field Description
Username
Corresponds to the Kellokortti admin account name without the “_admin” suffix.

| | Start Date |

Extract events starting from this date.

|

Tables and columns synced from Kellokortti

Section titled “Tables and columns synced from Kellokortti”

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

calendar_event (76 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
person_id STRING
start_time TIMESTAMP
end_time TIMESTAMP
reason_code INT64
work_shift INT64
event_category INT64
event_category_wage_code STRING
event_category_wage_code_name STRING
event_category_wage_code_for_hourly_wages STRING
event_category_wage_code_name_for_hourly_wages STRING
billed INT64
explanation STRING
supervisor STRING
accepted BOOL
accept_date TIMESTAMP
flextime INT64
overtime INT64
modified BOOL
timestamp TIMESTAMP
modifier_id STRING
question1 STRING
question2 STRING
question3 STRING
project_supervisor STRING
project_accepted BOOL
project_accept_date TIMESTAMP
start_time_cut_to_shift TIMESTAMP
end_time_cut_to_shift TIMESTAMP
shift_date TIMESTAMP
closing_method INT64
removed BOOL
dimension1 STRING
dimension_name1 STRING
dimension2 STRING
dimension_name2 STRING
dimension3 STRING
dimension_name3 STRING
dimension4 STRING
dimension_name4 STRING
dimension5 STRING
dimension_name5 STRING
free_text1 STRING
free_text2 STRING
event_category_name STRING
day_event_category INT64
day_event_category_name STRING
duration_cut_to_shift INT64
event_period_id INT64
event_type INT64
filled_hours_reason_code INT64
holiday_money_leave_year INT64
holiday_period_id INT64
hours_automatically_filled BOOL
transferred BOOL
transfer_date TIMESTAMP
person_info__person_name STRING
person_info__person_id STRING
person_info__person_guid STRING
person_info__person_group INT64
person_info__person_external_group STRING
person_info__person_number INT64
person_info__tax_number STRING
person_info__external_person_id STRING
person_info__person_uri STRING
day_info__daily_overtime_method STRING
day_info__day_saldo_revised BOOL
day_info__daily_flextime_saldo INT64
day_info__daily_pekkassaldo INT64
day_info__daily_saldo_of_worktimebank INT64
day_info__daily_saldo_of_overtimebank INT64
day_info__daily_puncked_worktime INT64
day_info__daily_planned_worktime INT64
day_info__added_to_flex_time_from_day INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dimension (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
dimension_uid INT64
external_id STRING
dimension_id STRING
dimension_group INT64
main_dimension_id STRING
not_in_use BOOL
dimension_name STRING
dimension_name_en STRING
dimension_name_sv STRING
person_groups STRING
unit INT64
not_to_tax_report BOOL
hourly_wage FLOAT64
hourly_wage_billed FLOAT64
start_date TIMESTAMP
end_date TIMESTAMP
additional_info STRING
self_uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
dimension_person (16 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
dimension_uid INT64
dimension_group INT64
dimension_id STRING
person_guid STRING
person_id STRING
start_date TIMESTAMP
end_date TIMESTAMP
price_per_hour FLOAT64
price_per_hour_for_invoicing FLOAT64
external_dimension_id STRING
external_person_id STRING
self_uri STRING
dimension_uri STRING
person_uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
person (77 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
person_id_mode INT64
guid STRING
person_id STRING
external_person_id STRING
person_role INT64
license_sms BOOL
person_group INT64
external_person_group STRING
name STRING
first_name STRING
last_name STRING
birth_date TIMESTAMP
person_number INT64
person_number_payroll STRING
holiday_planning_group INT64
active BOOL
phone STRING
e_mail STRING
supervisor STRING
punch_rights BOOL
license_travel_claims BOOL
license_holiday_planning BOOL
license_web BOOL
allow_changes BOOL
default_dimension1 STRING
default_dimension2 STRING
default_dimension3 STRING
default_dimension4 STRING
default_dimension5 STRING
notification_messages BOOL
message_format INT64
start_date TIMESTAMP
employment_start_date TIMESTAMP
employment_end_date TIMESTAMP
gsm_location BOOL
show_dimension_id_in_lists BOOL
default_event_category INT64
person_unit INT64
employee_type INT64
employment_type INT64
employer_business_id STRING
employer_name STRING
memo1 STRING
memo2 STRING
max_flextime INT64
min_flextime INT64
max_flextime_daily INT64
tax_number STRING
license_tyoajastin BOOL
street_address STRING
address_additional_info STRING
postal_code STRING
post_office STRING
language STRING
country STRING
uses_calendar BOOL
uses_timer BOOL
uses_travel_claims BOOL
creates_period_events BOOL
can_approve_own_events BOOL
can_modify_timebank_events BOOL
can_modify_payroll_events BOOL
can_see_persons_basic_info_on_calendar BOOL
rfid_number STRING
worksite_employees_in_use BOOL
external_group_id STRING
builder_information__valtti_bar_code STRING
builder_information__valtti_status STRING
builder_information__valtti_uid STRING
builder_information__builder_id INT64
builder_information__valtti_valid_to TIMESTAMP
builder_information__not_on_tax_report BOOL
builder_information__employer_agency INT64
send_password_to_new_person BOOL
self_uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_membership (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
membership_type INT64
person_id STRING
person_guid STRING
dimension_group INT64
dimension_id STRING
dimension_uid INT64
external_dimension_id STRING
external_person_id STRING
self_uri STRING
person_uri STRING
dimension_uri STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
travel_claim (31 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
travel_claim_id INT64
person_id STRING
person_guid STRING
external_person_id STRING
start_time TIMESTAMP
end_time TIMESTAMP
country_id STRING
country_name STRING
description STRING
acceptor STRING
accepted BOOL
accept_date TIMESTAMP
project_acceptor STRING
project_accept_date TIMESTAMP
project_accepted BOOL
ready BOOL
ready_date TIMESTAMP
rejected BOOL
rejected_date TIMESTAMP
rejector STRING
paid BOOL
sum FLOAT64
dimension1 STRING
dimension2 STRING
dimension3 STRING
dimension4 STRING
dimension5 STRING
free1 STRING
free2 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.
travel_id INT64
travel_day_id INT64
person_id STRING
travel_date TIMESTAMP
start_time TIMESTAMP
end_time TIMESTAMP
country_id STRING
country_name STRING
destination_id STRING
destination_name STRING
meal_time1 TIMESTAMP
meal_time2 TIMESTAMP
meal_time3 TIMESTAMP
description STRING
dimension1 STRING
dimension2 STRING
dimension3 STRING
dimension4 STRING
dimension5 STRING
free1 STRING
free2 STRING
meal_compensation INT64
night_travel_compensation INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: travel_claim__travel_days__travel_imbursements

Section titled “Subtable: travel_claim__travel_days__travel_imbursements”
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.
person_id STRING
travel_imbursement_row_id INT64
travel_date TIMESTAMP
travel_imbursement_type INT64
type_title STRING
travel_imbursement_id INT64
country_id STRING
country_name STRING
destination_id INT64
destination_title STRING
travel_imbursement_description STRING
amount FLOAT64
unit_price FLOAT64
total FLOAT64
description STRING
vehicle_id INT64
travel_route STRING
dimension1 STRING
dimension2 STRING
dimension3 STRING
dimension4 STRING
dimension5 STRING
free1 STRING
free2 STRING
parent_row_id INT64
extras_total FLOAT64
initial_read_out INT64
final_read_out INT64
acceptor STRING
accepted BOOL
accept_date TIMESTAMP
project_acceptor STRING
project_accepted BOOL
project_accept_date TIMESTAMP
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: travel_claim__travel_days__travel_imbursements__travel_imbursement_rows

Section titled “Subtable: travel_claim__travel_days__travel_imbursements__travel_imbursement_rows”
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.
accept_date TIMESTAMP
accepted BOOL
acceptor STRING
amount FLOAT64
country_id STRING
country_name STRING
description STRING
destination_id INT64
destination_title STRING
dimension1 STRING
dimension2 STRING
dimension3 STRING
dimension4 STRING
dimension5 STRING
extras_total FLOAT64
final_read_out INT64
free1 STRING
free2 STRING
initial_read_out INT64
parent_row_id INT64
person_id STRING
project_accept_date TIMESTAMP
project_accepted BOOL
project_acceptor STRING
total FLOAT64
travel_date TIMESTAMP
travel_imbursement_description STRING
travel_imbursement_id INT64
travel_imbursement_row_id INT64
travel_imbursement_type INT64
travel_route STRING
type_title STRING
unit_price FLOAT64
vehicle_id INT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: travel_claim__travel_days__travel_imbursements__travel_imbursement_rows__travel_imbursement_rows

Section titled “Subtable: travel_claim__travel_days__travel_imbursements__travel_imbursement_rows__travel_imbursement_rows”
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: travel_claim__travel_days__travel_expenses

Section titled “Subtable: travel_claim__travel_days__travel_expenses”
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.
work_calendar_event (34 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64
person_id STRING
event_type INT64
start_time TIMESTAMP
end_time TIMESTAMP
reason_code INT64
shift INT64
event_category INT64
billable BOOL
dimension1 STRING
dimension2 STRING
dimension3 STRING
dimension4 STRING
dimension5 STRING
freetext1 STRING
freetext2 STRING
explanation STRING
approver STRING
approved BOOL
approval_date TIMESTAMP
modified BOOL
modified_date TIMESTAMP
modifier STRING
project_approver STRING
project_approved BOOL
project_approval_date TIMESTAMP
start_time_cut_to_shift TIMESTAMP
end_time_cut_to_shift TIMESTAMP
duration_cut_to_shift INT64
created_date TIMESTAMP
is_deleted BOOL
timestamp TIMESTAMP
_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 Kellokortti 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 Kellokortti?

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

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

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

Track logged hours and attendance by employee and over time.

Report on time by project to see where work goes and support billing.

Analyse hours to monitor overtime and working-time balances.

Bring time data alongside payroll or finance data in BigQuery for a full view.

Use Kellokortti data in your AI and BI tools

Section titled “Use Kellokortti data in your AI and BI tools”

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

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