Business Intelligence Connector update – October 1, 2020

We are making the following changes to the Greenhouse Analytics schema on October 15, 2020. See below for a description, and see attached for the latest schema.

This update allows customers with the Business Intelligence Connector to view data regarding:

• Custom Demographic Questions marked as required
  
  • New column required added to the demographic_questions table

----

CREATE TABLE demographic_questions (
 id bigint NOT NULL,
 organization_id bigint NOT NULL,
 active boolean NOT NULL,
 demographic_question_set_id bigint,
 name character varying,
 required boolean
);