LoginSign Up
← Back to all sparks
Greenhouse Recruiting logo

Greenhouse Recruiting

HR
Velocity0.0

Structured hiring and recruiting optimization platform

www.greenhouse.com/solutions/recruiting ↗

Greenhouse Recruiting's BIC schema is being quietly modernized for sourcing analytics and multi-location reporting.

business-intelligence-connectorschema-evolutionsourcing-automationdata-warehousedeprecations
◆Current state
The tracked feed for Greenhouse Recruiting is dominated by Business Intelligence Connector (BIC) schema updates — the data layer customers use for warehouse-side reporting. Recent updates have moved recruiter and coordinator relationships from candidates to applications, added multi-location support, surfaced preferred names, and most recently exposed Greenhouse Sourcing Automation (GHSA) tables for downstream analytics.
◆Where it's heading
These are unsexy but consequential schema changes: Greenhouse is making BIC a more accurate model of how hiring actually works (one candidate, many applications; one job, many locations) and progressively exposing newer product lines like GHSA into the analytics surface. The implication is that Greenhouse expects more customers to push BIC data into Snowflake and BigQuery — and is willing to invest in keeping the schema clean for that audience.
◆Prediction
Expect more BIC additions tied to Real Talent (fraud signals, identity verification outcomes) and Hire Link Workday outputs, so analytics customers can report on the new product surface. The deprecation of older candidate-side fields signals more aggressive schema cleanup ahead.

◆Recent moves

  1. 11mo ago

    Business Intelligence Connector Update: July 14, 2025

    July 2025 BIC update adds Greenhouse Sourcing Automation (GHSA) tables to the nightly ETL — additive, opt-in via the schema toggle. Lets analytics teams report on outreach performance and prospect activity alongside core recruiting data.

    View source ↗
  2. 1y ago

    Business Intelligence Connector update: May 21, 2025

    May 2025 BIC update completes the deprecation of the legacy single-location field on the job_posts table, finalizing the migration to job_post_locations. Reporting accuracy improvement at the cost of one breaking change to old dashboards.

    View source ↗
  3. 1y ago

    Business Intelligence Connector update: February 19 & March 19, 2025

    Feb/March 2025 BIC update introduces the job_post_locations table (multi-location job-post support) and adds a preferred_name column to candidates. Schema work that better models real hiring flows.

    View source ↗
  4. 1y ago

    Business Intelligence Connector update: January 31, 2025

    January 2025 BIC update completes the move of recruiter/coordinator fields from the candidates table to the applications table. Candidate-side fields are deprecated, finishing the multi-application model rollout.

    View source ↗
  5. 1y ago

    Business Intelligence Connector update: November 21, 2024

    November 2024 BIC update kicks off the recruiter/coordinator schema migration by adding those fields to the applications table. First step of the multi-month, two-table refactor that finishes in January 2025.

    View source ↗