Skip to content
Book a demoStart free
Connectors

HiBob connector

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

HiBob connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your HiBob 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 HiBob HR data into BigQuery with Kaivo to report on headcount and people data without exporting spreadsheets.

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

Field Description
Password
Your HiBob service user token, shown once when the service user is created under Settings → Integrations → Service Users.

|

When you set up the connector, you provide:

Field Description
Username
Your HiBob service user ID, created under Settings → Integrations → Service Users.

|

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

employees (41 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about__avatar STRING
about__food_preferences STRING
about__hobbies STRING
about__superpowers STRING
company_id STRING
display_name STRING
email STRING
employee__last_day_of_work STRING
employee__veteran_status STRING
first_name STRING
full_name STRING
home__private_email STRING
id STRING
internal__lifecycle_status STRING
internal__status STRING
internal__termination_date STRING
internal__termination_reason STRING
personal__honorific STRING
personal__nationality STRING
personal__pronouns STRING
personal__short_birth_date STRING
surname STRING
work__active_effective_date STRING
work__custom__field_1698036945383 STRING
work__days_of_previous_service STRING
work__department STRING
work__employee_id_in_company STRING
work__is_manager STRING
work__manager STRING
work__original_start_date STRING
work__short_start_date STRING
work__site STRING
work__site_id STRING
work__start_date STRING
work__tenure_duration_years STRING
work__tenure_years STRING
work__title STRING
work__work_change_type STRING
work__years_of_service STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
payroll (91 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about__avatar STRING
avatar_url STRING
company_id FLOAT64
cover_image_url STRING
creation_date_time STRING
display_name STRING
email STRING
financial__account_name STRING
financial__accountnumber STRING
financial__bank_account_type STRING
financial__bank_name STRING
financial__custom__field_1692991687729 STRING
financial__passport_number STRING
first_name STRING
full_name STRING
home__family_status STRING
home__legal_gender STRING
home__mobile_phone STRING
home__number_of_kids FLOAT64
home__private_email STRING
home__private_phone STRING
id STRING
internal__current_active_status_start_date STRING
internal__lifecycle_status STRING
internal__status STRING
payroll__custom__field_1694738605040 FLOAT64
payroll__custom__field_1694739058581 STRING
payroll__custom__field_1694739102985 FLOAT64
payroll__employment__type STRING
payroll__employment__active_effective_date STRING
payroll__employment__actual_working_pattern__days__friday FLOAT64
payroll__employment__actual_working_pattern__days__monday FLOAT64
payroll__employment__actual_working_pattern__days__saturday FLOAT64
payroll__employment__actual_working_pattern__days__sunday FLOAT64
payroll__employment__actual_working_pattern__days__thursday FLOAT64
payroll__employment__actual_working_pattern__days__tuesday FLOAT64
payroll__employment__actual_working_pattern__days__wednesday FLOAT64
payroll__employment__actual_working_pattern__hours_per_day FLOAT64
payroll__employment__actual_working_pattern__working_pattern_id FLOAT64
payroll__employment__actual_working_pattern__working_pattern_type STRING
payroll__employment__calendar_id FLOAT64
payroll__employment__contract STRING
payroll__employment__fte FLOAT64
payroll__employment__hours_in_day_not_worked FLOAT64
payroll__employment__salary_pay_type STRING
payroll__employment__site_working_pattern__days__friday FLOAT64
payroll__employment__site_working_pattern__days__monday FLOAT64
payroll__employment__site_working_pattern__days__saturday FLOAT64
payroll__employment__site_working_pattern__days__sunday FLOAT64
payroll__employment__site_working_pattern__days__thursday FLOAT64
payroll__employment__site_working_pattern__days__tuesday FLOAT64
payroll__employment__site_working_pattern__days__wednesday FLOAT64
payroll__employment__site_working_pattern__hours_per_day FLOAT64
payroll__employment__site_working_pattern__working_pattern_id FLOAT64
payroll__employment__site_working_pattern__working_pattern_type STRING
payroll__employment__weekly_hours FLOAT64
payroll__time_since_last_salary_change__humanize STRING
payroll__time_since_last_salary_change__period_iso STRING
payroll__time_since_last_salary_change__sort_factor FLOAT64
surname STRING
work__active_effective_date STRING
work__days_of_previous_service FLOAT64
work__department STRING
work__direct_reports FLOAT64
work__duration_of_employment__humanize STRING
work__duration_of_employment__period_iso STRING
work__duration_of_employment__sort_factor FLOAT64
work__employee_id_in_company FLOAT64
work__indirect_reports FLOAT64
work__is_manager BOOL
work__manager STRING
work__original_start_date STRING
work__reports_to__display_name STRING
work__reports_to__email STRING
work__reports_to__first_name STRING
work__reports_to__id STRING
work__reports_to__surname STRING
work__reports_to_id_in_company FLOAT64
work__short_start_date STRING
work__site STRING
work__site_id FLOAT64
work__start_date STRING
work__tenure_duration__humanize STRING
work__tenure_duration__period_iso STRING
work__tenure_duration__sort_factor FLOAT64
work__tenure_duration_years FLOAT64
work__tenure_years FLOAT64
work__title STRING
work__years_of_service FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: payroll__about__food_preferences

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

Subtable: payroll__identification__custom__field_1697450926907

Section titled “Subtable: payroll__identification__custom__field_1697450926907”
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: payroll__payroll__actual_payment

Section titled “Subtable: payroll__payroll__actual_payment”
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: payroll__payroll__employment_type

Section titled “Subtable: payroll__payroll__employment_type”
Column Type Description
_kaivo_parent_id STRING Foreign key referencing _kaivo_id in the parent table. Auto-generated by Kaivo.
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING
active_effective_date STRING
actual_working_pattern__days__friday FLOAT64
actual_working_pattern__days__monday FLOAT64
actual_working_pattern__days__saturday FLOAT64
actual_working_pattern__days__sunday FLOAT64
actual_working_pattern__days__thursday FLOAT64
actual_working_pattern__days__tuesday FLOAT64
actual_working_pattern__days__wednesday FLOAT64
actual_working_pattern__hours_per_day FLOAT64
actual_working_pattern__working_pattern_id FLOAT64
actual_working_pattern__working_pattern_type STRING
calendar_id FLOAT64
calendar_name STRING
can_be_deleted BOOL
change__changed_by_id STRING
contract STRING
effective_date STRING
fte FLOAT64
hours_in_day_not_worked FLOAT64
id FLOAT64
is_current BOOL
modification_date STRING
salary_pay_type STRING
site_working_pattern__days__friday FLOAT64
site_working_pattern__days__monday FLOAT64
site_working_pattern__days__saturday FLOAT64
site_working_pattern__days__sunday FLOAT64
site_working_pattern__days__thursday FLOAT64
site_working_pattern__days__tuesday FLOAT64
site_working_pattern__days__wednesday FLOAT64
site_working_pattern__hours_per_day FLOAT64
site_working_pattern__working_pattern_id FLOAT64
site_working_pattern__working_pattern_type STRING
weekly_hours 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.
active_effective_date STRING
base__currency STRING
base__value FLOAT64
can_be_deleted BOOL
change__changed_by_id STRING
change__reason STRING
effective_date STRING
end_effective_date STRING
id FLOAT64
is_current BOOL
modification_date STRING
pay_frequency STRING
pay_period STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: payroll__payroll__variable_payment

Section titled “Subtable: payroll__payroll__variable_payment”
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: payroll__work__custom__field_1698036945383

Section titled “Subtable: payroll__work__custom__field_1698036945383”
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.
profiles (39 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
about__avatar STRING
company_id FLOAT64
display_name STRING
email STRING
first_name STRING
home__private_email STRING
id STRING
surname STRING
work__active_effective_date STRING
work__days_of_previous_service FLOAT64
work__department STRING
work__direct_reports FLOAT64
work__duration_of_employment__humanize STRING
work__duration_of_employment__period_iso STRING
work__duration_of_employment__sort_factor FLOAT64
work__employee_id_in_company FLOAT64
work__indirect_reports FLOAT64
work__is_manager BOOL
work__manager STRING
work__original_start_date STRING
work__reports_to__display_name STRING
work__reports_to__email STRING
work__reports_to__first_name STRING
work__reports_to__id STRING
work__reports_to__surname STRING
work__reports_to_id_in_company FLOAT64
work__short_start_date STRING
work__site STRING
work__site_id FLOAT64
work__start_date STRING
work__tenure_duration__humanize STRING
work__tenure_duration__period_iso STRING
work__tenure_duration__sort_factor FLOAT64
work__tenure_duration_years FLOAT64
work__tenure_years FLOAT64
work__title STRING
work__years_of_service FLOAT64
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Subtable: profiles__about__food_preferences

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

Subtable: profiles__work__custom__field_1698036945383

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

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

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

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

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

Use employees and profiles to track headcount and changes over time.

Use payroll to report on pay alongside the rest of your people data.

Bring HiBob data into BigQuery to build people reports tailored to your business.

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