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.ioKaivo 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.
What is the Greenhouse connector
Section titled “What is the Greenhouse connector”Sync your Greenhouse candidates, applications, and interviews into BigQuery with Kaivo to report on hiring alongside the rest of your data.
| Category | HR |
|---|---|
| Authentication | API key |
| Setup | Self-service |
Getting started with the Greenhouse connector
Section titled “Getting started with the Greenhouse connector”- Sign up for Kaivo and create a workspace.
- Connect your Greenhouse account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- Query your data in BigQuery or your favourite AI or BI tool.
Authenticating Greenhouse
Section titled “Authenticating Greenhouse”Authenticate with your API Key.
| Field | Description |
|---|---|
| API Key | |
| Your Greenhouse Harvest API key. |
|
Tables and columns synced from Greenhouse
Section titled “Tables and columns synced from Greenhouse”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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. |
Nested subtables
Section titled “Nested subtables”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)
How the Greenhouse sync works
Section titled “How the Greenhouse sync works”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.
Frequently asked questions
Section titled “Frequently asked questions”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.
Can I sync only some tables or columns?
Section titled “Can I sync only some tables or columns?”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.
Common use cases for Greenhouse data
Section titled “Common use cases for Greenhouse data”Pipeline funnel
Section titled “Pipeline funnel”Track applications by stage to measure your hiring funnel and conversion.
Time to hire
Section titled “Time to hire”Analyse applications and interviews to measure time to hire and where candidates stall.
Source effectiveness
Section titled “Source effectiveness”Report on where candidates come from to see which sources produce hires.
Department reporting
Section titled “Department reporting”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.
Claude
Section titled “Claude”Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →
Power BI
Section titled “Power BI”Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →
Data Studio
Section titled “Data Studio”Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →
Tableau
Section titled “Tableau”The premium analytics standard, with native BigQuery integration. Setup guide →
Google Sheets
Section titled “Google Sheets”Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →
Connect via Power Query’s BigQuery connector. Setup guide →
Metabase
Section titled “Metabase”Open-source BI tool with strong BigQuery support. Setup guide →
See our pricing page for Greenhouse connector pricing and plan details.
Related connectors
Section titled “Related connectors”- Kellokortti: Sync Kellokortti to BigQuery.
- Nepton: Sync Nepton to BigQuery.
- Teamtailor: Sync Teamtailor to BigQuery.
- 7shifts: Sync 7shifts to BigQuery.
- Ashby: Sync Ashby to BigQuery.
- BambooHR: Sync BambooHR to BigQuery.