What does Benchling Insights do?

  • It allows organizations to query and visualize all of the data inputted into their Benchling system. With proper configuration, it can be used to answer an organization’s scientific and operational questions.

What does Benchling Insights not do?

  • Insights currently can not set up Machine Learning Models, Advanced Statistical Knowledge, inherently cannot bring EXTERNAL data in from other databases and analyze it 

  • Currently, Insights is restricted to SQL-based calculations and formulas. Machine learning models or advanced statistics is not currently not possible within the tool (however one can use the tool to organize the data into an exportable format and exporting the table into your statistical software.

How can I get this application? 

  • If you have not attended the Insights Webinar, watch the recording here: (link coming soon!). Afterwards, reach out to your CX representative and account manager for next steps.

How do I navigate to the application?

  • Reference this article: Navigation & Orientation
    As a registry admin, how do I control the permission controls for my tenant?

What happens when you have None Access to the dashboard? 

  • You will not see any graphs or data, and you will be prompted to request access from your Registry Admin.

Can I query data from projects I do not have permission to? 

  • No, you will only see the data that you have access to. For example, if there are certain proprietary entities that should not be queried by certain teams within the organization, then said users are not able to be queried.

  • Reference article: Insights Permissions

How do I set up and change my graphs in Benchling Insights?

How do I set up parameters such that end-users can select which subset of entities to query without changing the query.

Where is the documentation for tables that are stored in the warehouse?

How come the tables in the docs.benchling.com documentation do not match what I see in the insights application?

  • The tables listed on docs.benchling.com show general schemas, and they act as an example of how the tables would look in your environment. Your actual tables will look different based on how your organization’s schemas were set up.

What is the difference between a ‘regular’ and a ‘$raw’ table in the ?

  • A Regular table is a validated set of entities fewer columns & fewer rows; archived and deleted values will be excluded. For example, result tables in unreviewed entries could be queried through the $raw tables but not the regular tables.

Why are ids listed in the form “ent_fhgTCjd” and where can I get the actual name of items in the warehouse?

  • These are Benchling-specific

Where can I learn more about SQL?

  • We have a few videos that review the basics of SQL here. For additional training, there are a lot of resources online such as W3Schools and Khan Academy.

Did this answer your question?