Release Notes

September 2026

We've made the following changes in v1.5.0:

• Updated all source identifier variables and integration test seed files to reflect v3 source table names.

• Added the greenhouse_using_interview and greenhouse_using_interviewer variables (both default to true) to support environments where the interview and/or interviewer tables aren't synced. See the README for more details.

  • greenhouse_using_interview: false disables greenhouse__interview_enhanced and greenhouse__interview_scorecard_detail, and removes interview-metric columns from greenhouse__application_enhanced and greenhouse__job_enhanced.
  • greenhouse_using_interviewer: false disables greenhouse__interview_scorecard_detail and removes interviewer/scorecard-derived columns from greenhouse__interview_enhanced and interviewer metrics in greenhouse__application_enhanced .

• Made 66 schema/data changes to support the Greenhouse Harvest API v3 connector schema (36 possible breaking changes):

  Data Model(s)	Change type	Old	New	Notes
  greenhouse__application_enhanced	Columns added/removed	Removed: applied_at, prospect_pool_id, prospect_stage_id, prospect_owner_user_id, prospect_pool, prospect_stage, prospect_owner_name, rejected_reason_id	Added: job_id, job_post_id, coordinator_id, recruiter_id, coordinator_email, recruiter_email, created_at, updated_at, agency_note_id, preferred_name, time_zone, can_email	Possible breaking change: applied_at and prospect pipeline data permanently removed in v3.
  greenhouse__application_enhanced stg_greenhouse__application	Columns renamed	current_stage_id, credited_to_user_id	stage_id, referrer_id	Possible breaking change: Update downstream references.
  greenhouse__interview_enhanced stg_greenhouse__scorecard	Column renamed + values changed	overall_recommendation	candidate_rating	Possible breaking change: Values change from definitely_not, no, yes, strong_yes, no_decision to strong_no, no, yes, strong_yes, no_decision.
  greenhouse__interview_enhanced	Column removed	candidate_id	—
  greenhouse__interview_enhanced stg_greenhouse__interview	Columns renamed	interview_id, start_at, end_at	job_interview_id, starts_at, ends_at	Possible breaking change: Update downstream references.
  greenhouse__interview_enhanced stg_greenhouse__interview	Columns added	—	scheduled_at, all_day_start_on, all_day_end_on, external_event_id, video_conferencing_url, availability_received_at
  stg_greenhouse__interview	Column removed	interview_kit_content	—	Possible breaking change: No longer available in the v3 source table.
  greenhouse__interview_scorecard_detail	Columns removed/added	Removed: index, attribute_name, rating, attribute_category, overall_recommendation	Added: id, job_candidate_attribute_id, candidate_attribute_rating, candidate_rating	Possible breaking change:
  greenhouse__job_enhanced stg_greenhouse__job	Columns added	—	department_id, opened_at, is_template, copied_from_id
  greenhouse__interview_scorecard_detail	Surrogate key grain change	scorecard_attribute_key = interview_scorecard_key + index	scorecard_attribute_key = interview_scorecard_key + id	Possible breaking change: All existing key values change.
  stg_greenhouse__application	Columns added/removed	Removed: applied_at, prospect_owner_user_id, prospect_pool_id, prospect_stage_id, rejected_reason_id	Added: job_id, coordinator_id, recruiter_id, job_post_id, needs_decision, created_at, updated_at	Possible breaking change: job_id was previously only on the job_application bridge table; coordinator_id/recruiter_id moved from candidate to application in v3.
  stg_greenhouse__job_post	Columns added/removed	Removed: location_name	Added: is_active, is_featured, created_at, demographic_question_set_id, first_published_at, job_board_id, language_code, public_url	Possible breaking change: location_name moved to the new stg_greenhouse__job_post_location model.
  stg_greenhouse__scorecard	Columns added/removed	Removed: candidate_id, interview	Added: interviewer_id, interview_kit_id, status, notes, notes_with_tags, private_notes, private_notes_with_tags, public_notes, public_notes_with_tags
  stg_greenhouse__candidate	Columns removed	coordinator_id, recruiter_id, new_candidate_id	—	Possible breaking change: Moved to stg_greenhouse__application in v3.
  stg_greenhouse__attachment	Column removed	index	—	Possible breaking change: id is the new primary key.
  stg_greenhouse__job_interview_stage stg_greenhouse__job_post_location stg_greenhouse__candidate_tag_link	New Staging/Tmp models	—	—	New staging models (with corresponding _tmp models) added to support the v3 schema.
  stg_greenhouse__job_application stg_greenhouse__job_department stg_greenhouse__tag stg_greenhouse__hiring_team stg_greenhouse__job_stage	Models removed/replaced	—	—	Possible breaking change: job_id/department_id now live directly on their source tables; tag_name is denormalized onto candidate_tag_link; stg_greenhouse__job_interview_stage replaces job_stage and the v2 interview source table; hiring_team is split into stg_greenhouse__job_hiring_manager and stg_greenhouse__job_owner, gated respectively by the new greenhouse_using_job_hiring_manager and greenhouse_using_job_owner vars (replacing the single greenhouse_using_job_hiring_team var). These vars are also referenced by greenhouse__application_enhanced, greenhouse__interview_enhanced, greenhouse__interview_scorecard_detail, and greenhouse__application_history.
  stg_greenhouse__opening stg_greenhouse__candidate_phone_number stg_greenhouse__prospect_pool_stage stg_greenhouse__interview stg_greenhouse__interviewer stg_greenhouse__scorecard_candidate_attribute stg_greenhouse__candidate_social_media_address stg_greenhouse__users stg_greenhouse__candidate_email_address	Models renamed	stg_greenhouse__job_opening stg_greenhouse__phone_number stg_greenhouse__prospect_stage stg_greenhouse__scheduled_interview stg_greenhouse__scheduled_interviewer stg_greenhouse__scorecard_attribute stg_greenhouse__social_media_address stg_greenhouse__user stg_greenhouse__email_address	stg_greenhouse__opening stg_greenhouse__candidate_phone_number stg_greenhouse__prospect_pool_stage stg_greenhouse__interview stg_greenhouse__interviewer stg_greenhouse__scorecard_candidate_attribute stg_greenhouse__candidate_social_media_address stg_greenhouse__users stg_greenhouse__candidate_email_address	Possible breaking change: Renamed to match their v3 source table names. Update any direct references.

  All staging, intermediate, and end models reflect the v3 source table and column names.

August 2026

We've updated the following quickstart data model packages to add DuckDB as a supported destination:

June 2026

v1.4.0

Under the Hood

• Migrates the union_connections, apply_source_relation, and partition_by_source_relation macros to the dbt_fivetran_utils package.
• Adds the fivetran_using_source_casing variable for case-sensitive destination support. When enabled, downstream transformations respect source casing to ensure consistent results. See the Additional Configurations section of the README for details.

January 2026

v1.3.0

Documentation

• Updates README with standardized Fivetran formatting.

Under the Hood

• In the quickstart.yml file:
  • Adds table_variables for relevant sources to prevent missing sources from blocking downstream Quickstart models.
  • Adds supported_vars for Quickstart UI customization.

v1.2.0

Features

• Increases the required dbt version upper limit to v3.0.0

August 2025

v1.0.1

PR #37 introduces the following updates:

Bug Fixes

• Updated dbt_project.yml variables with the new tags and users source tables, which are the new versions of the tag and user source tables. These sources were previously included, but were accidentally dropped in the Source Package consolidation release.

Under the Hood

• Added tags and users seed files.