We are making updates to the BI Connector schema on November 2, 2022.
Download the latest schema file by clicking the attachment on the right side of the page.
Overview of changes
In the Business Intelligence Connector, the
attributes table was generated as a unique list of values with an id that changed each time the data was refreshed. Then, to correctly match the list of values to a more specific table containing relevant Greenhouse Recruiting data, organizations had to write an additional JOIN to ensure the correct values were returned in the query.
With this update, the following changes will occur:
idcolumn will become a real, primary key ID as it exists in Greenhouse Recruiting, removing the need for the additional JOIN statement
idwill be static, and won't update with each data refresh
updated_atcolumns provide the actual
updated_attimes instead of a null value
In addition to the changes outlined above, the following changes will occur on the
jobs_attributestable now will contain
jobs_attributes.attributes_idwill contain matching values
scorecards_attributestable will contain
attibute_idnow joins to
After this change, the
job_attributes table contains the same data as the
attributes table. The
attributes table will be deprecated in a future release. Organizations should plan to update their queries with the following mapping.
|Matching job_attributes column
When the interviews table contained a generated id, an additional JOIN statement was needed to query the tables.
JOIN attributes ON attributes.id = scorecard_attributes.attribute_id
WHERE attributes.name = 'Public Speaking'
After the above updates, the ID in the Business Intelligence Connector will match the ID Greenhouse Recruiting, providing a stable id for the table and allowing you to query each table directly without the additional JOIN:
WHERE attribute_name = 'Public Speaking'