BI Connector/Greenhouse Analytics Overview

BI Connector (fka Greenhouse Analytics) data support 

Support for the BI Connector (fka Greenhouse Analytics data product) is provided by the Greenhouse team, and consists of:

  • Self-service materials below
  • Email support via

Documentation on data and reports:

  • Data schema - please subscribe to Release Notes to be notified any time there is a change to the data schema. Note: Schema files are best opened up with a text editor like Sublime (free) after you change the file extension from .txt to .sql.
  • Guide to data tables (last updated 6/23/17) – a guide to each data table
  • Data model – a simple description of how certain data tables relate to each other

Thought leadership and best practices

Greenhouse Recruiting support

For any questions about Greenhouse Recruiting that DO NOT relate to the data available via the BI Connector, including support for the Harvest API please contact:

  • Your Customer Success Manager (if applicable) for strategic questions about Greenhouse and product requests for Greenhouse Recruiting
  • Customer Support via in-app chat or for usability questions, including for Greenhouse Recruiting reports

Amazon Redshift support

The data available from the BI Connector is stored in an Amazon Redshift cluster that is managed by the Greenhouse team. For a guide to connecting to Redshift, please refer to the Redshift documentation. The main methods are via a compatible business intelligence / analytics tool (see shortlist of official Redshift Business Intelligence Partners), a SQL query tool, psql, or programmatically via Java or .NET.

See technical requirements here

Tool-specific support

If you have any questions about the analytics tool you are using—including error messages—they are best answered by the provider of your analytics tool.



Keywords: [analytics, reports, reporting, domo, redshift, looker, tableau, sql]

Have more questions? Submit a request


  • Avatar
    emily keuthen

    Hey Mike and Alex -

    Looks like most of your links above are broken. Please fix ASAP as we rely on this documentation.


  • Avatar
    Mike Linshi

    Hi Emily – thank you for notifying us! I will work on fixing this and let you know when complete.

  • Avatar
    Mike Linshi

    Hi Emily,

    The links are active again!

  • Avatar
    Stephanie Pruitt

    Hello, where can I find the documentation on the different dimensions and measures (and how to calculate them)? I don't see where to find these on the new Master List website

  • Avatar
    Mike Linshi

    Hi Stephanie,

    We deprecated an out-of-date "data dictionary" document and replaced it with the "Guide to Greenhouse Analytics tables" file that you'll see in the Community page. If you have questions about what specific dimensions represent, or which dimensions to use to calculate a specific measure, you can write into for support!

  • Avatar
    Tom Arnold

    hi, when are you adding activity feed into redshift?

  • Avatar
    Mike Linshi

    Hi Tom,

    There is no stand-alone activity feed data table, but there are several specific/focused data tables that contain timestamped activities that appear in the activity feed. For example, the applications table contains the applied_at and rejected_at timestamps that you would see in the activity feed, and the application_stages table contains all the stage change timestamps that you would see in the activity feed. If you are looking to analyze the activity feed, I'd recommend first starting with the specific action you are looking to analyze. If there are timestamped activities that don't exist, you can bring this up with your CSM or Customer Support to log this as a product request (similarly, you can also log a request with your CSM or with Customer Support if you have a reason as to why a stand-alone activity feed data table is preferred).

    Note: In the future, questions like this are best sent to your CSM or to (easier to track than article comments).