Insights [Enterprise]

Build queries and visualizations to understand your experiments, entities, and entries.

Hannah Park avatar Sanjay Saraf avatar Andrew Collins avatar +3
27 articles in this collection
Written by Hannah Park, Sanjay Saraf, Andrew Collins and 3 others

Using Block Templates in Insights

Add tables and charts to Insights dashboards without writing SQL
Rebecca Conway avatar
Written by Rebecca Conway
Updated this week

Introduction to Insights

Sanjay Saraf avatar
Written by Sanjay Saraf
Updated over a week ago

Writing SQL in Insights

Videos walking through querying with Benchling Insights
Sanjay Saraf avatar
Written by Sanjay Saraf
Updated over a week ago

Managing Blocks within Insights

How to manage blocks within the Insights tool
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Insights Permissions

Guide reviewing the permissions for the Insights
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Insight Navigation and Orientation

Basic guide to orientate new users with navigating the application
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Running a SQL Query

How to run a SQL Query in the Insights tool
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Configuring Visualizations

How to set up specific graph visualizations within the Insights application.
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Creating Parameters

What are Parameters useful for?
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Duplicating or Deleting a Dashboard in Benchling Insights

You can duplicate and delete dashboards, and their associated queries, within Benchling Insights.
Andrew Collins avatar
Written by Andrew Collins
Updated over a week ago

Using Dynamic Warehouse Diagrams within Insights

Understand the relationships among your schema tables in Benchling
Sanjay Saraf avatar
Written by Sanjay Saraf
Updated over a week ago

How do I configure Insights Registry Embedding?

Embed your Insights Dashboards into the Registry to get contextual data about your entities!
Sanjay Saraf avatar
Written by Sanjay Saraf
Updated over a week ago
Querying FAQ

How do I convert row_index and column_index to well positions?

Well and Box Positions
Namitha Patil avatar
Written by Namitha Patil
Updated over a week ago

How do I join data from different Benchling Applications?

Key Joins for Applications in Benchling
Namitha Patil avatar
Written by Namitha Patil
Updated over a week ago

How do I aggregate data across different organizations?

Combine data across Benchling organizations
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How and when should I use schema specific tables or the single “registry_entity” table?

Schema specific table vs. “registry_entity” table
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I make a date range for a time series with parameters?

Filter on Date Range
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I add timezones to my Datetime values?

Adjust Timezone for Datetime columns
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How come my division yields wrong numbers?

Specify precision on number columns
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I query over JSONB arrays like ["seq_D3fZa648", "seq_bVWwI73e"]?

Separate data in JSONB Array columns
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How do I change the order of query results of alphanumeric values?

You can use SUBSTRING to extract a certain part of a value and use that to order
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How is “PARTITION BY” different from “GROUP BY”?

Window Functions vs. Group By
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How do I make my parameter work when it is a null value?

Return data when the parameter is empty
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

What is the difference between tables that are suffixed with $raw vs. not?

Raw Tables vs Non-Raw Tables
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How do I search for multiple values in a parameter?

Filter data on multiple values
Anshi Saxena avatar
Written by Anshi Saxena
Updated over a week ago

How do I set up partial text matching for Parameters?

Use CONCAT and LIKE/ILIKE
Hannah Park avatar
Written by Hannah Park
Updated over a week ago

How do I extract the date/timestamp from values such as “2020-06-19T21:23:26.990971”?

Convert Timestamp to Date
Hannah Park avatar
Written by Hannah Park
Updated over a week ago