Skip to content
Book a demoStart free
Connectors

Greenhouse connector

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

Greenhouse connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Greenhouse 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 Greenhouse candidates, applications, and interviews into BigQuery with Kaivo to report on hiring alongside the rest of your data.

CategoryHR
AuthenticationAPI key
SetupSelf-service

Getting started with the Greenhouse connector

Section titled “Getting started with the Greenhouse connector”
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Greenhouse 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
Your Greenhouse Harvest API key.

|

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

activity_feed (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.

Repeating fields are split into their own tables, listed here with their column counts.

  • activity_feed__activities (12 columns)
  • activity_feed__emails (14 columns)
  • activity_feed__emails__cc (4 columns)
  • activity_feed__notes (14 columns)
applications (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
applied_at STRING Timestamp when the candidate applied.
candidate_id INT64 Unique identifier for the candidate.
credited_to__employee_id STRING Unique identifier for the employee.
credited_to__first_name STRING First name of the employee.
credited_to__id INT64 ID of the employee.
credited_to__last_name STRING Last name of the employee.
credited_to__name STRING Full name of the employee.
current_stage__id INT64 ID of the current stage.
current_stage__name STRING Name of the current stage.
id INT64 Unique identifier for the application.
job_post_id INT64
last_activity_at STRING Timestamp of the last activity on the application.
location STRING Location related to the application.
prospect BOOL Status of the application prospect.
prospect_detail__prospect_owner__id INT64 Unique identifier for the prospect owner.
prospect_detail__prospect_owner__name STRING Name of the prospect owner.
prospect_detail__prospect_pool STRING Pool the prospect belongs to.
prospect_detail__prospect_stage STRING Stage of the prospect.
prospective_department STRING Prospective department for the candidate.
prospective_office STRING Prospective office for the candidate.
rejected_at STRING Timestamp when the application was rejected.
rejection_reason__type__id INT64 ID of the rejection reason type.
rejection_reason__type__name STRING Name of the rejection reason type.
rejection_reason__id INT64 ID of the rejection reason.
rejection_reason__name STRING Name of the rejection reason.
source__id INT64 ID of the application source.
source__public_name STRING Public name of the application source.
status STRING Status of the application.
_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.

  • applications__answers (4 columns)
  • applications__attachments (4 columns)
  • applications__jobs (4 columns)
applications_demographics_answers (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 Unique identifier for the application associated with the demographic answer
created_at TIMESTAMP Timestamp indicating when the demographic answer was created
demographic_answer_option_id INT64 Unique identifier for the selected answer option for the demographic question
demographic_question_id INT64 Unique identifier for the demographic question answered
free_form_text STRING Any additional free form text provided as part of the answer
id INT64 Unique identifier for the demographic answer record
updated_at TIMESTAMP Timestamp indicating when the demographic answer was last updated
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
applications_interviews (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 Unique identifier for the job application.
created_at TIMESTAMP Date and time when the application interview data was created.
end__date_time TIMESTAMP End date and time of the interview.
external_event_id STRING ID of the external event associated with the interview.
id INT64 Unique identifier for the interview data.
interview__id INT64 Unique identifier for the interview type.
interview__name STRING Name or title of the interview.
location STRING Location where the interview takes place.
organizer__employee_id STRING Employee ID of the organizer.
organizer__first_name STRING First name of the organizer.
organizer__id INT64 Unique identifier for the organizer.
organizer__last_name STRING Last name of the organizer.
organizer__name STRING Full name of the organizer.
start__date_time TIMESTAMP Start date and time of the interview.
status STRING Status of the interview (e.g., scheduled, completed).
updated_at TIMESTAMP Date and time when the application interview data was last updated.
video_conferencing_url STRING URL for the video conferencing platform used for the interview.
_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.

  • applications_interviews__interviewers (9 columns)
approvals (10 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64 Version of the approval request
approval_status STRING The status of the approval (e.g. pending, approved, rejected)
approval_type STRING The type of approval required for the request
id INT64 Unique identifier of the approval request
job_id INT64 Identifier of the job associated with this approval request
offer_id INT64 Identifier of the offer associated with this approval request
requested_by_user_id INT64 User ID who requested this approval
sequential BOOL Flag indicating whether the approvals are required in a sequential order
_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.

  • approvals__approver_groups (10 columns)
  • approvals__approver_groups__approvers (6 columns)
  • approvals__approver_groups__approvers__email_addresses (4 columns)
candidates (15 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
can_email BOOL Indicates if candidate can be emailed
company STRING Company where the candidate is associated
coordinator STRING Coordinator assigned to the candidate
created_at STRING Date and time of creation
first_name STRING Candidate’s first name
id INT64 Candidate’s ID
is_private BOOL Indicates if the candidate’s data is private
last_activity STRING Details of the last activity related to the candidate
last_name STRING Candidate’s last name
photo_url STRING URL of the candidate’s profile photo
recruiter STRING Recruiter assigned to the candidate
title STRING Candidate’s title (e.g., Mr., Mrs., Dr.)
updated_at STRING Date and time of last update
_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.

  • candidates__addresses (4 columns)
  • candidates__application_ids (4 columns)
  • candidates__applications (30 columns)
  • candidates__applications__answers (4 columns)
  • candidates__applications__attachments (4 columns)
  • candidates__applications__jobs (4 columns)
  • candidates__attachments (4 columns)
  • candidates__educations (4 columns)
  • candidates__email_addresses (4 columns)
  • candidates__employments (4 columns)
  • candidates__phone_numbers (4 columns)
  • candidates__social_media_addresses (4 columns)
  • candidates__tags (4 columns)
  • candidates__website_addresses (4 columns)
close_reasons (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the close reason.
name STRING The name or description of the close reason.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
custom_fields (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING Description of the custom field.
active BOOL Indicates whether the custom field is currently active or not.
api_only BOOL Denotes if the custom field is used only in API requests.
expose_in_job_board_api BOOL Specifies if the custom field should be exposed in the job board API.
field_type STRING Type of the custom field (text, dropdown, etc.).
id INT64 Unique identifier of the custom field.
name STRING Name of the custom field.
name_key STRING Key associated with the name of the custom field.
priority INT64 Priority of the custom field.
private BOOL Indicates if the custom field is for private use only.
require_approval BOOL Specifies if approval is required for changes to the custom field.
required BOOL Denotes whether the custom field is required or not.
template_token_string STRING Token string used in templates for the custom field.
trigger_new_version BOOL Indicates if a new version should be triggered upon changes to the custom field.
value_type STRING Type of values accepted by the custom field.
_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.

  • custom_fields__custom_field_options (7 columns)
  • custom_fields__departments (4 columns)
  • custom_fields__offices (4 columns)
degrees (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
external_id STRING Unique identifier for the greenhouse record in an external system
id INT64 Unique identifier for the greenhouse record
name STRING Name of the degrees data
priority INT64 Priority level of the degrees data for sorting
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
demographics_answer_options (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates if the demographic answer option is currently active or not.
demographic_question_id INT64 The ID of the demographic question associated with this answer option.
free_form BOOL Specifies if the answer option allows for a free-form text input.
id INT64 Unique identifier for the demographic answer option.
name STRING The name or label of the demographic answer option.
_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.

  • demographics_answer_options__translations (5 columns)
demographics_answers (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 The unique identifier of the application associated with the demographic answer
created_at TIMESTAMP The date and time when the demographic answer was created
demographic_answer_option_id INT64 The identifier of the answer option chosen for the demographic question
demographic_question_id INT64 The identifier of the demographic question to which the answer belongs
free_form_text STRING Any additional free-form text provided as part of the answer
id INT64 The unique identifier of the demographic answer
updated_at TIMESTAMP The date and time when the demographic answer was last updated
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
demographics_answers_answer_options (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates whether this demographic answer option is active or not.
demographic_question_id INT64 The unique identifier of the demographic question associated with this answer option.
free_form BOOL Specifies if the answer option allows for free-form input in addition to predefined options.
id INT64 The unique identifier of this demographic answer option.
name STRING The name or label of the demographic answer option.
_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.

  • demographics_answers_answer_options__translations (5 columns)
demographics_question_sets (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING A brief description of the demographics question set
active BOOL Indicates if the demographics question set is currently active
id INT64 Unique identifier for the demographics question set
title STRING Title of the demographics question set
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
demographics_question_sets_questions (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Specifies if the question is active or not.
demographic_question_set_id INT64 Unique identifier of the demographic question set to which this question belongs.
id INT64 Unique identifier of the question.
name STRING Name of the question.
required BOOL Indicates if this question is mandatory to answer.
_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.

  • demographics_question_sets_questions__translations (5 columns)
demographics_questions (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Specifies if the demographic question is currently active or not.
demographic_question_set_id INT64 The ID of the demographic question set this question belongs to.
id INT64 The unique identifier for the demographic question.
name STRING The name or title of the demographic question.
required BOOL Indicates if the demographic question is required to be answered.
_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.

  • demographics_questions__translations (5 columns)
departments (7 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
external_id STRING External ID of this department.
id INT64 Unique ID of this department.
name STRING Name of the department.
parent_department_external_id STRING External ID of the parent department of this department.
parent_id INT64 Unique ID of the parent department of this department.
_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.

  • departments__child_department_external_ids (4 columns)
  • departments__child_ids (4 columns)
disciplines (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the discipline
name STRING Name of the discipline
priority INT64 Priority level of the discipline
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
eeoc (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 Unique identifier for the job application
candidate_id INT64 Unique identifier for the candidate applying for the job
disability_status__description STRING Description of the candidate’s disability status
disability_status__id INT64 Unique identifier for the disability status
gender__description STRING Description of the candidate’s gender
gender__id INT64 Unique identifier for the gender
race__description STRING Description of the candidate’s race
race__id INT64 Unique identifier for the race
submitted_at STRING Timestamp when the data was submitted
veteran_status__id INT64 Unique identifier for the veteran status
veteran_status__message STRING Message related to the candidate’s veteran status
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
email_templates (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING Type or category of the email template (e.g., welcome email, newsletter).
description STRING Brief description of the email template and its purpose.
body STRING The main content body of the email template.
created_at STRING Timestamp indicating when the email template was created.
default BOOL Flag indicating if the template is the default one to use.
from STRING Email address or name of the sender for the email template.
html_body STRING HTML formatted content of the email template.
id INT64 Unique identifier for the email template.
name STRING Name or title of the email template.
updated_at STRING Timestamp indicating when the email template was last updated.
user STRING User associated with the email template (creator or owner).
_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.

  • email_templates__cc (4 columns)
interviews (19 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 The unique identifier for the job application associated with the interview
created_at TIMESTAMP The date and time when the interview was created
end__date_time TIMESTAMP The end date and time of the interview
external_event_id STRING The identifier for the external event related to the interview
id INT64 The unique identifier for the interview
interview__id INT64 The unique identifier for the interview
interview__name STRING The name or title of the interview
location STRING The physical or virtual location of the interview
organizer__employee_id STRING The employee identifier of the organizer
organizer__first_name STRING The first name of the organizer
organizer__id INT64 The unique identifier for the organizer
organizer__last_name STRING The last name of the organizer
organizer__name STRING The full name of the organizer
start__date_time TIMESTAMP The start date and time of the interview
status STRING The status of the interview (e.g., scheduled, completed)
updated_at TIMESTAMP The date and time when the interview was last updated
video_conferencing_url STRING The URL for the video conferencing platform used for the interview
_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.

  • interviews__interviewers (9 columns)
job_posts (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Flag indicating if the job post is active or not.
content STRING Content or description of the job post.
created_at STRING Date and time when the job post was created.
demographic_question_set_id INT64 ID of the demographic question set associated with the job post.
external BOOL Flag indicating if the job post is external or not.
first_published_at STRING Date and time when the job post was first published.
id INT64 Unique identifier of the job post.
internal BOOL Flag indicating if the job post is internal or not.
internal_content STRING Internal content or description of the job post.
job_id INT64 ID of the job associated with the job post.
live BOOL Flag indicating if the job post is live or not.
location__id INT64 Unique identifier of the location.
location__job_post_location_type__id INT64 Unique identifier of the location type.
location__job_post_location_type__name STRING Name of the location type.
location__name STRING Name of the location.
location__office_id INT64 ID of the office associated with the location.
title STRING Title or headline of the job post.
updated_at STRING Date and time when the job post was last updated.
_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.

  • job_posts__questions (9 columns)
  • job_posts__questions__values (4 columns)
job_stages (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP The timestamp when the job stage was created
id INT64 The unique identifier of the job stage
job_id INT64 The identifier of the job associated with the job stage
name STRING The name of the job stage
priority INT64 The priority level of the job stage
updated_at TIMESTAMP The timestamp when the job stage was last updated
_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.

  • job_stages__interviews (9 columns)
  • job_stages__interviews__default_interviewer_users (4 columns)
  • job_stages__interviews__interview_kit__questions (4 columns)
jobs (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
closed_at STRING The date and time the job was closed
confidential BOOL Indicates if the job details are confidential
copied_from_id INT64 The ID of the job from which this job was copied
created_at STRING The date and time the job was created
custom_fields__employment_type STRING Type of employment associated with the job
id INT64 Unique ID of the job
is_template BOOL Indicates if the job is a template
keyed_custom_fields__employment_type__type STRING Data type of the employment type field
keyed_custom_fields__employment_type__name STRING Name of the employment type field
keyed_custom_fields__employment_type__value STRING Value of the employment type field
name STRING Name of the job
notes STRING Additional notes or comments about the job
opened_at STRING The date and time the job was opened
requisition_id STRING ID associated with the job requisition
status STRING Current status of the job
updated_at STRING The date and time the job was last updated
_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.

  • jobs__departments (8 columns)
  • jobs__departments__child_department_external_ids (4 columns)
  • jobs__departments__child_ids (4 columns)
  • jobs__hiring_team__coordinators (4 columns)
  • jobs__hiring_team__hiring_managers (4 columns)
  • jobs__hiring_team__recruiters (4 columns)
  • jobs__hiring_team__sourcers (4 columns)
  • jobs__offices (10 columns)
  • jobs__offices__child_ids (4 columns)
  • jobs__offices__child_office_external_ids (4 columns)
  • jobs__openings (10 columns)
jobs_openings (18 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 The unique identifier for the job application.
close_reason__id INT64 The unique identifier for the close reason.
close_reason__name STRING The name or description of the close reason.
closed_at TIMESTAMP The date and time when the job opening was closed.
custom_fields__employment_type STRING Type of employment for the job.
custom_fields__maximum_budget STRING The maximum budget assigned for the job.
id INT64 The unique identifier for the job opening.
keyed_custom_fields__budget__type STRING The type of budget value.
keyed_custom_fields__budget__name STRING The name or description of the budget.
keyed_custom_fields__budget__value STRING The value of the budget.
keyed_custom_fields__employment_type__type STRING The type of employment value.
keyed_custom_fields__employment_type__name STRING The name or description of the employment type.
keyed_custom_fields__employment_type__value STRING The value of the employment type.
opened_at TIMESTAMP The date and time when the job opening was created.
opening_id STRING The unique identifier for the job opening.
status STRING The current status of the job opening.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
jobs_stages (8 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at TIMESTAMP The date and time when the job stage was created
id INT64 The unique identifier for the job stage
job_id INT64 The unique identifier of the job associated with this stage
name STRING The name of the job stage
priority INT64 The priority level of this job stage
updated_at TIMESTAMP The date and time when the job stage was last updated
_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.

  • jobs_stages__interviews (9 columns)
  • jobs_stages__interviews__default_interviewer_users (4 columns)
  • jobs_stages__interviews__interview_kit__questions (4 columns)
offers (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
version INT64 Version of the offer data
application_id INT64 Unique identifier for the application associated with the offer
candidate_id INT64 Unique identifier for the candidate associated with the offer
created_at STRING Timestamp indicating when the offer was created
custom_fields__employment_type STRING Type of employment associated with the offer
id INT64 Unique identifier for the offer
job_id INT64 Unique identifier for the job associated with the offer
keyed_custom_fields__employment_type__type STRING Type of the custom employment field
keyed_custom_fields__employment_type__name STRING Name of the custom employment field
keyed_custom_fields__employment_type__value STRING Value of the custom employment field
opening__application_id INT64 Unique identifier for the opening application
opening__close_reason STRING Reason for closing the opening
opening__closed_at STRING Timestamp indicating when the opening was closed
opening__id INT64 Unique identifier for the opening
opening__opened_at STRING Timestamp indicating when the opening was opened
opening__opening_id STRING Unique identifier for the opening associated with the offer
opening__status STRING Status of the opening
resolved_at STRING Timestamp indicating when the offer was resolved
sent_at STRING Timestamp indicating when the offer was sent
starts_at STRING Timestamp indicating when the offer starts
status STRING Status of the offer
updated_at STRING Timestamp indicating when the offer was last updated
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
offices (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
external_id STRING Unique identifier for this office in the external system
id INT64 Unique identifier for this office in the API system
location__name STRING Name of the location where the office is situated
name STRING Name of the office
parent_id INT64 ID of the parent office, if this office is a branch office
parent_office_external_id STRING External ID of the parent office in the external system
primary_contact_user_id INT64 User ID of the primary contact person for this office
_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.

  • offices__child_ids (4 columns)
  • offices__child_office_external_ids (4 columns)
prospect_pools (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
active BOOL Indicates whether the prospect pool is active or not.
id INT64 Unique identifier for the prospect pool.
name STRING The name of the prospect pool.
_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.

  • prospect_pools__prospect_stages (5 columns)
rejection_reasons (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type__id INT64 Unique identifier for the type of rejection reason.
type__name STRING The name of the type of rejection reason.
id INT64 Unique identifier for the rejection reason.
name STRING The name of the rejection reason.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
schools (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the school.
name STRING Name of the school.
priority INT64 Priority level of the school.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
scorecards (23 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
application_id INT64 The unique identifier of the job application associated with the scorecard data.
candidate_id INT64 The unique identifier of the candidate for whom the scorecard is created.
created_at STRING The timestamp when the scorecard was created.
id INT64 The unique identifier of the scorecard.
interview STRING Details about the interview related to the scorecard.
interview_step__id INT64 The unique identifier of the interview step.
interview_step__name STRING The name or title of the interview step.
interviewed_at STRING The timestamp when the candidate was interviewed.
interviewer__employee_id STRING The unique identifier of the employee who conducted the interview.
interviewer__first_name STRING The first name of the interviewer.
interviewer__id INT64 The unique identifier of the interviewer.
interviewer__last_name STRING The last name of the interviewer.
interviewer__name STRING The full name of the interviewer.
overall_recommendation STRING The overall recommendation for the candidate based on the scorecard evaluation.
submitted_at STRING The timestamp when the scorecard was submitted.
submitted_by__employee_id STRING The unique identifier of the employee who submitted the scorecard.
submitted_by__first_name STRING The first name of the employee who submitted the scorecard.
submitted_by__id INT64 The unique identifier of the employee who submitted the scorecard.
submitted_by__last_name STRING The last name of the employee who submitted the scorecard.
submitted_by__name STRING The full name of the employee who submitted the scorecard.
updated_at STRING The timestamp when the scorecard was last updated.
_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.

  • scorecards__attributes (7 columns)
  • scorecards__questions (6 columns)
  • scorecards__ratings__definitely_not (4 columns)
  • scorecards__ratings__mixed (4 columns)
  • scorecards__ratings__no (4 columns)
  • scorecards__ratings__strong_yes (4 columns)
  • scorecards__ratings__yes (4 columns)
sources (6 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type__id INT64 The unique identifier for the type of the source.
type__name STRING The name of the type of the source.
id INT64 The unique identifier for the source.
name STRING The name of the source.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
tags (4 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the tag.
name STRING The name of the tag.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user_permissions (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier for the user permission data
job_id INT64 Identifier for the job associated with the user permission data
user_role_id INT64 Identifier for the user role associated with the user permission data
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
user_roles (5 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
type STRING The type or category of the user role.
id INT64 The unique identifier for the user role.
name STRING The name of the user role.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (12 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
created_at STRING The date and time when the user account was created.
disabled BOOL Indicates whether the user account is disabled.
employee_id STRING Employee identifier for the user.
first_name STRING The first name of the user.
id INT64 Unique identifier for the user.
last_name STRING The last name of the user.
name STRING The full name of the user.
primary_email_address STRING The primary email address of the user.
site_admin BOOL Indicates whether the user is a site administrator.
updated_at STRING The date and time when the user account was last updated.
_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.

  • users__departments (8 columns)
  • users__departments__child_department_external_ids (4 columns)
  • users__departments__child_ids (4 columns)
  • users__emails (4 columns)
  • users__linked_candidate_ids (4 columns)
  • users__offices (10 columns)
  • users__offices__child_ids (4 columns)
  • users__offices__child_office_external_ids (4 columns)

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

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

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

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

Track applications by stage to measure your hiring funnel and conversion.

Analyse applications and interviews to measure time to hire and where candidates stall.

Report on where candidates come from to see which sources produce hires.

Break hiring down by department to monitor open roles and progress.

Use Greenhouse data in your AI and BI tools

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

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