Insights

Introduction to Insights

Written by Sanjay Saraf
Updated over a week ago

Writing SQL in Insights

Videos walking through querying with Benchling Insights

Written by Sanjay Saraf
Updated over a week ago

Managing Blocks within Insights

How to manage blocks within the Insights tool

Written by Andrew Collins
Updated over a week ago

Insights Permissions

Guide reviewing the permissions for the Insights

Written by Andrew Collins
Updated over a week ago

Insight Navigation and Orientation

Basic guide to orientate new users with navigating the application

Written by Andrew Collins
Updated over a week ago

Running a SQL Query

How to run a SQL Query in the Insights tool

Written by Andrew Collins
Updated over a week ago

Configuring Visualizations

How to set up specific graph visualizations within the Insights application.

Written by Andrew Collins
Updated over a week ago

Creating Parameters

What are Parameters useful for?

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.

Written by Andrew Collins
Updated over a week ago

Using Dynamic Warehouse Diagrams within Insights

Understand the relationships among your schema tables in Benchling

Written by Sanjay Saraf
Updated over a week ago

Notebook entry creation over time

Build a visualization to show how many entries are created each week

Written by Sanjay Saraf
Updated over a week ago

How do I convert row_index and column_index to well positions?

Well and Box Positions

Written by Namitha Patil
Updated over a week ago

How do I join data from different Benchling Applications?

Key Joins for Applications in Benchling

Written by Namitha Patil
Updated over a week ago

How do I aggregate data across different organizations?

Combine data across Benchling organizations

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

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

Written by Anshi Saxena
Updated over a week ago

How do I add timezones to my Datetime values?

Adjust Timezone for Datetime columns

Written by Anshi Saxena
Updated over a week ago

How come my division yields wrong numbers?

Specify precision on number columns

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

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

Written by Hannah Park
Updated over a week ago

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

Window Functions vs. Group By

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

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

Written by Hannah Park
Updated over a week ago

How do I search for multiple values in a parameter?

Filter data on multiple values

Written by Anshi Saxena
Updated over a week ago

How do I set up partial text matching for Parameters?

Use CONCAT and LIKE/ILIKE

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

Written by Hannah Park
Updated over a week ago