Skip to content
Book a demoStart free
Connectors

Huntr connector

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

Huntr connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Huntr 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 Huntr recruiting data into BigQuery with Kaivo to track candidates and hiring activity across your roles.

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

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

actions (279 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_type STRING
activity__completed BOOL
activity__completed_at FLOAT64
activity__created_at FLOAT64
activity__created_by_workflow BOOL
activity__end_at FLOAT64
activity__id STRING
activity__note STRING
activity__start_at FLOAT64
activity__title STRING
activity_category__id STRING
activity_category__name STRING
activity_id STRING
board_id STRING
candidate__created_at FLOAT64
candidate__email STRING
candidate__first_name STRING
candidate__id STRING
candidate__last_name STRING
candidate__profiles__github STRING
candidate__profiles__linkedin STRING
candidate_id STRING
created_at FLOAT64
created_by_workflow BOOL
creator_employer_member__created_at FLOAT64
creator_employer_member__email STRING
creator_employer_member__family_name STRING
creator_employer_member__given_name STRING
creator_employer_member__id STRING
creator_member__created_at FLOAT64
creator_member__email STRING
creator_member__family_name STRING
creator_member__full_name STRING
creator_member__given_name STRING
creator_member__id STRING
creator_member__is_active BOOL
creator_member__last_seen_at FLOAT64
creator_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
creator_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
creator_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
creator_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
creator_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
creator_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
creator_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
creator_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
creator_member__member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
creator_member__member_field_values_keyed_by_id___666958440297480067932137__value STRING
creator_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
creator_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
creator_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
creator_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
creator_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
creator_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
creator_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__field_id STRING
creator_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
creator_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
creator_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
creator_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
creator_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
creator_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
creator_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
creator_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
creator_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__field_id STRING
creator_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__value STRING
date FLOAT64
document__document_category_name STRING
document__extension STRING
document__id STRING
document__name STRING
document__title STRING
document__url STRING
document_id STRING
employer__domain STRING
employer__id STRING
employer__is_partner BOOL
employer__name STRING
employer_id STRING
from_list__id STRING
from_list__name STRING
from_list_id STRING
goal__description STRING
goal__enrollment_start_date FLOAT64
goal__enrollment_type STRING
goal__id STRING
goal__instructions STRING
goal__name STRING
goal__objective_entity STRING
goal__objective_numeric_target FLOAT64
goal__objective_target_type STRING
goal__one_time_goal_due_days_count FLOAT64
goal__schedule_type STRING
goal__status STRING
goal_enrollment__goal_id STRING
goal_enrollment__id STRING
goal_enrollment__status STRING
goal_progress__end FLOAT64
goal_progress__goal_enrollment_id STRING
goal_progress__goal_id STRING
goal_progress__id STRING
goal_progress__objective_entity STRING
goal_progress__objective_numeric_count FLOAT64
goal_progress__objective_numeric_target FLOAT64
goal_progress__progress_index FLOAT64
goal_progress__start FLOAT64
goal_progress__status STRING
id STRING
job__description STRING
job__board_id STRING
job__created_at FLOAT64
job__html_description STRING
job__id STRING
job__list_id STRING
job__location__address STRING
job__location__lat STRING
job__location__lng STRING
job__location__name STRING
job__location__place_id STRING
job__location__url STRING
job__salary STRING
job__title STRING
job__url STRING
job_id STRING
job_post__application_instructions STRING
job_post__created_at FLOAT64
job_post__employer_id STRING
job_post__html_description STRING
job_post__id STRING
job_post__is_remote BOOL
job_post__job_post_status__name STRING
job_post__job_type STRING
job_post__location__address STRING
job_post__location__country STRING
job_post__location__lat STRING
job_post__location__lng STRING
job_post__location__name STRING
job_post__post_date FLOAT64
job_post__source_name STRING
job_post__title STRING
job_post__url STRING
job_post__visibility STRING
job_post_id STRING
member__created_at FLOAT64
member__email STRING
member__family_name STRING
member__full_name STRING
member__given_name STRING
member__id STRING
member__is_active BOOL
member__last_seen_at FLOAT64
member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
member__member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
member__member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
member__member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
member__member_field_values_keyed_by_id___666958440297480067932137__value STRING
member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
member_id STRING
note__html_text STRING
note__id STRING
note__member_id STRING
note__text STRING
note_id STRING
organization_employer_partnership__created_at FLOAT64
organization_employer_partnership__employer_can_browse_candidates BOOL
organization_employer_partnership__employer_can_post_jobs BOOL
organization_employer_partnership__employer_id STRING
organization_employer_partnership__id STRING
organization_employer_partnership_id STRING
organization_invitation_id STRING
owner_member__created_at FLOAT64
owner_member__email STRING
owner_member__family_name STRING
owner_member__full_name STRING
owner_member__given_name STRING
owner_member__id STRING
owner_member__is_active BOOL
owner_member__last_seen_at FLOAT64
owner_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
owner_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
owner_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
owner_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
owner_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
owner_member__member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
owner_member__member_field_values_keyed_by_id___666958440297480067932137__value STRING
owner_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
owner_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
owner_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
owner_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
owner_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
owner_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
owner_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__field_id STRING
owner_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
owner_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
owner_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
owner_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
owner_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
owner_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
owner_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
owner_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
owner_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__field_id STRING
owner_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__value STRING
to_list__id STRING
to_list__name STRING
to_list_id STRING
update___background_photo STRING
update___primary_role_preference STRING
update___profile_photo STRING
update__background_photo_url STRING
update__bio STRING
update__color STRING
update__current_location___city STRING
update__current_location___country STRING
update__current_location__address STRING
update__current_location__country STRING
update__current_location__geohash STRING
update__current_location__lat FLOAT64
update__current_location__lng FLOAT64
update__current_location__name STRING
update__current_location__point__type STRING
update__email STRING
update__expected_salary__actual FLOAT64
update__expected_salary__currency STRING
update__expected_salary__interval STRING
update__expected_salary__max FLOAT64
update__expected_salary__min FLOAT64
update__experience_preference STRING
update__headline STRING
update__html_bio STRING
update__html_description STRING
update__is_public_profile BOOL
update__is_visible_to_all_employers BOOL
update__last_name STRING
update__legally_authorized_to_work_in_usa BOOL
update__location__address STRING
update__location__lat FLOAT64
update__location__lng FLOAT64
update__location__name STRING
update__location__place_id STRING
update__location__url STRING
update__phone_number STRING
update__primary_role_experience_years FLOAT64
update__primary_role_experience_years_text STRING
update__primary_role_preference_name STRING
update__profile_photo_url STRING
update__profiles__github STRING
update__profiles__linkedin STRING
update__require_work_visa_sponsorship_in_usa BOOL
update__root_domain STRING
update__status STRING
update__title STRING
update__title_base_keyword STRING
update__total_work_experience_years FLOAT64
update__total_work_experience_years_text STRING
update__url STRING
update__username STRING
update__willing_to_relocate BOOL
update__work_environment_preference 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.

  • actions__creator_member__board_ids (4 columns)
  • actions__creator_member__member_field_values (5 columns)
  • actions__creator_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • actions__creator_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • actions__creator_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__value (4 columns)
  • actions__filters__candidate_list_ids (4 columns)
  • actions__filters__filters (4 columns)
  • actions__goal__enrollment_triggers (4 columns)
  • actions__goal__enrollment_triggers__conditions (4 columns)
  • actions__goal__objective_entity_conditions (6 columns)
  • actions__goal_progress__objective_action_ids (4 columns)
  • actions__goal_progress__objective_activity_ids (4 columns)
  • actions__goal_progress__objective_contact_ids (4 columns)
  • actions__goal_progress__objective_job_ids (4 columns)
  • actions__job_post__locations (8 columns)
  • actions__job_post__visible_member_group_ids (4 columns)
  • actions__jobs (14 columns)
  • actions__member__board_ids (4 columns)
  • actions__member__member_field_values (5 columns)
  • actions__member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • actions__member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • actions__owner_member__board_ids (4 columns)
  • actions__owner_member__member_field_values (5 columns)
  • actions__owner_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • actions__owner_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • actions__owner_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__value (4 columns)
  • actions__update___documents (4 columns)
  • actions__update___industry_preferences (4 columns)
  • actions__update___role_preferences (4 columns)
  • actions__update___skills (4 columns)
  • actions__update__current_location___administrative_regions (4 columns)
  • actions__update__current_location__administrative_regions_names (4 columns)
  • actions__update__current_location__point__coordinates (4 columns)
  • actions__update__educations (14 columns)
  • actions__update__educations__achievements (4 columns)
  • actions__update__emails (6 columns)
  • actions__update__industry_preferences_names (4 columns)
  • actions__update__job_type_preferences (4 columns)
  • actions__update__keywords (5 columns)
  • actions__update__keywords__job_matches (4 columns)
  • actions__update__links (7 columns)
  • actions__update__location_preferences (12 columns)
  • actions__update__location_preferences___administrative_regions (4 columns)
  • actions__update__location_preferences__administrative_regions_names (4 columns)
  • actions__update__location_preferences__point__coordinates (4 columns)
  • actions__update__phone_numbers (5 columns)
  • actions__update__role_preferences_names (4 columns)
  • actions__update__sentences (8 columns)
  • actions__update__skill_names (4 columns)
  • actions__update__volunteer_experiences (26 columns)
  • actions__update__volunteer_experiences___skills (4 columns)
  • actions__update__volunteer_experiences__achievements (4 columns)
  • actions__update__volunteer_experiences__achievements_with_vectors (4 columns)
  • actions__update__volunteer_experiences__location___administrative_regions (4 columns)
  • actions__update__volunteer_experiences__location__administrative_regions_names (4 columns)
  • actions__update__volunteer_experiences__location__point__coordinates (4 columns)
  • actions__update__volunteer_experiences__skill_names (4 columns)
  • actions__update__volunteer_experiences__skills (4 columns)
  • actions__update__work_experiences (31 columns)
  • actions__update__work_experiences___skills (4 columns)
  • actions__update__work_experiences__achievements (4 columns)
  • actions__update__work_experiences__achievements_with_vectors (4 columns)
  • actions__update__work_experiences__location___administrative_regions (4 columns)
  • actions__update__work_experiences__location__administrative_regions_names (4 columns)
  • actions__update__work_experiences__location__point__coordinates (4 columns)
  • actions__update__work_experiences__skill_names (4 columns)
  • actions__update__work_experiences__skills (4 columns)
activities (63 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
activity_category__id STRING
activity_category__name STRING
completed BOOL
completed_at FLOAT64
created_at FLOAT64
created_by_workflow BOOL
creator_member__created_at FLOAT64
creator_member__email STRING
creator_member__family_name STRING
creator_member__full_name STRING
creator_member__given_name STRING
creator_member__id STRING
creator_member__is_active BOOL
creator_member__last_seen_at FLOAT64
employer__description STRING
employer__domain STRING
employer__founded_year FLOAT64
employer__id STRING
employer__is_partner BOOL
employer__location STRING
employer__name STRING
id STRING
job__board_id STRING
job__created_at FLOAT64
job__deadline FLOAT64
job__id STRING
job__list_id STRING
job__location__address STRING
job__location__lat STRING
job__location__lng STRING
job__location__name STRING
job__location__place_id STRING
job__location__url STRING
job__salary STRING
job__title STRING
job__url STRING
job_post__created_at FLOAT64
job_post__employer_id STRING
job_post__id STRING
job_post__is_remote BOOL
job_post__job_type STRING
job_post__location__address STRING
job_post__location__lat STRING
job_post__location__lng STRING
job_post__location__name STRING
job_post__post_date FLOAT64
job_post__source_name STRING
job_post__title STRING
job_post__url STRING
job_post__visibility STRING
note STRING
owner_member__created_at FLOAT64
owner_member__email STRING
owner_member__family_name STRING
owner_member__full_name STRING
owner_member__given_name STRING
owner_member__id STRING
owner_member__is_active BOOL
owner_member__last_seen_at FLOAT64
start_at FLOAT64
title 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.

  • activities__creator_member__board_ids (4 columns)
  • activities__creator_member__member_field_values (5 columns)
  • activities__job_post__locations (7 columns)
  • activities__job_post__visible_member_group_ids (4 columns)
  • activities__owner_member__board_ids (4 columns)
  • activities__owner_member__member_field_values (5 columns)
candidate_profile_viewed_actions (2 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
candidates (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
email STRING
first_name STRING
id STRING
last_name STRING
member_id STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
member_deactivated_actions (91 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
action_type STRING
created_at FLOAT64
created_by_workflow BOOL
creator_member__created_at FLOAT64
creator_member__email STRING
creator_member__family_name STRING
creator_member__full_name STRING
creator_member__given_name STRING
creator_member__id STRING
creator_member__is_active BOOL
creator_member__last_seen_at FLOAT64
creator_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
date FLOAT64
id STRING
member__created_at FLOAT64
member__email STRING
member__family_name STRING
member__full_name STRING
member__given_name STRING
member__id STRING
member__is_active BOOL
member__last_seen_at FLOAT64
member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
member__member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
member__member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
member__member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
member__member_field_values_keyed_by_id___666958440297480067932137__value STRING
member__member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__field_id STRING
member__member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__value STRING
member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__field_id STRING
member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__field_id STRING
member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__value STRING
member_id STRING
owner_member__created_at FLOAT64
owner_member__email STRING
owner_member__family_name STRING
owner_member__full_name STRING
owner_member__given_name STRING
owner_member__id STRING
owner_member__is_active BOOL
owner_member__last_seen_at FLOAT64
owner_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
owner_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
owner_member__member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
owner_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
owner_member__member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
owner_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
owner_member__member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
owner_member__member_field_values_keyed_by_id___666958440297480067932137__value STRING
owner_member__member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__field_id STRING
owner_member__member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__value STRING
owner_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
owner_member__member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
owner_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
owner_member__member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
owner_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
owner_member__member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
owner_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__field_id STRING
owner_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
owner_member__member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
owner_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
owner_member__member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
owner_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
owner_member__member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
owner_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
owner_member__member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
owner_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__field_id STRING
owner_member__member_field_values_keyed_by_id___66ec16249b764b00713e9190__value 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.

  • member_deactivated_actions__creator_member__board_ids (4 columns)
  • member_deactivated_actions__creator_member__member_field_values (4 columns)
  • member_deactivated_actions__creator_member__member_field_values__value (4 columns)
  • member_deactivated_actions__creator_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • member_deactivated_actions__member__board_ids (4 columns)
  • member_deactivated_actions__member__member_field_values (5 columns)
  • member_deactivated_actions__member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • member_deactivated_actions__member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • member_deactivated_actions__member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__value (4 columns)
  • member_deactivated_actions__owner_member__board_ids (4 columns)
  • member_deactivated_actions__owner_member__member_field_values (5 columns)
  • member_deactivated_actions__owner_member__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • member_deactivated_actions__owner_member__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • member_deactivated_actions__owner_member__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__value (4 columns)
member_fields (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
employer_partner_can_view BOOL
field_type STRING
id STRING
job_seeker_can_edit BOOL
name 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.

  • member_fields__choices (4 columns)
members (52 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
advisor__created_at FLOAT64
advisor__email STRING
advisor__family_name STRING
advisor__full_name STRING
advisor__given_name STRING
advisor__id STRING
advisor__last_seen_at FLOAT64
created_at FLOAT64
email STRING
family_name STRING
full_name STRING
given_name STRING
id STRING
is_active BOOL
last_seen_at FLOAT64
member_field_values_keyed_by_id___60c1df50c0ed7d00272923c0__field_id STRING
member_field_values_keyed_by_id___60c1df50c0ed7d00272923c0__value STRING
member_field_values_keyed_by_id___60c1e036c0ed7d0027292454__field_id STRING
member_field_values_keyed_by_id___60c1e036c0ed7d0027292454__value STRING
member_field_values_keyed_by_id___60c1e19fc0ed7d002729263f__field_id STRING
member_field_values_keyed_by_id___60c1e19fc0ed7d002729263f__value STRING
member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__field_id STRING
member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__field_id STRING
member_field_values_keyed_by_id___6516d5336f0d78007e63ddea__value STRING
member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__field_id STRING
member_field_values_keyed_by_id___6516d7ce85cdd6006797ce91__value STRING
member_field_values_keyed_by_id___651fa7960d6b610053131858__field_id STRING
member_field_values_keyed_by_id___651fa7960d6b610053131858__value STRING
member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__field_id STRING
member_field_values_keyed_by_id___666958440297480067932137__field_id STRING
member_field_values_keyed_by_id___666958440297480067932137__value STRING
member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__field_id STRING
member_field_values_keyed_by_id___666ab8b7af3b43006e5e118f__value STRING
member_field_values_keyed_by_id___66712d5216511b007d6504f2__field_id STRING
member_field_values_keyed_by_id___66712d5216511b007d6504f2__value STRING
member_field_values_keyed_by_id___669786b0867f7f00805862ad__field_id STRING
member_field_values_keyed_by_id___669786b0867f7f00805862ad__value STRING
member_field_values_keyed_by_id___669786cf825817005ab3c21c__field_id STRING
member_field_values_keyed_by_id___669786cf825817005ab3c21c__value STRING
member_field_values_keyed_by_id___669788b06f8cc80060c52d87__field_id STRING
member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__field_id STRING
member_field_values_keyed_by_id___6697c9c219442e0075c45d7d__value STRING
member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__field_id STRING
member_field_values_keyed_by_id___66b23ee5376425007bebcbe0__value STRING
member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__field_id STRING
member_field_values_keyed_by_id___66b2f80336e4d8050af4ec60__value STRING
member_field_values_keyed_by_id___66b2f82182fa370059c82009__field_id STRING
member_field_values_keyed_by_id___66b2f82182fa370059c82009__value STRING
member_field_values_keyed_by_id___66ec16249b764b00713e9190__field_id STRING
member_field_values_keyed_by_id___66ec16249b764b00713e9190__value 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.

  • members__board_ids (4 columns)
  • members__member_field_values (5 columns)
  • members__member_field_values_keyed_by_id___6516d4ca3d98fd0053e5ea66__value (4 columns)
  • members__member_field_values_keyed_by_id___659f8db0587682007c5f3ea8__value (4 columns)
  • members__member_field_values_keyed_by_id___669788b06f8cc80060c52d87__value (4 columns)
notes (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
html_text STRING
id STRING
member_id STRING
text STRING
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
organization_invitations (14 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
board_name STRING
board_template__id STRING
board_template__is_default BOOL
board_template__name STRING
created_at FLOAT64
id STRING
to__created_at FLOAT64
to__email STRING
to__family_name STRING
to__given_name STRING
to__id STRING
to_email 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.

  • organization_invitations__board_template__list_names (4 columns)
  • organization_invitations__board_template__list_templates (5 columns)
  • organization_invitations__member_field_values (5 columns)

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

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

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

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

Use candidates and activities to follow how candidates move through hiring.

Join members with actions to measure recruiter activity.

Use candidate_profile_viewed_actions and notes to see engagement with candidates.

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