Benchling Insights provides a flexible way to analyze your data, whether you just need to pull data from different schemas, or you want to visualize it. It all begins with a SQL query. This article guides you on the basics of what you need to run your own SQL query. To get started:
- Navigate to the Dashboard Page
- In the Schema Browser box, you will be able to see all of the tables you can pull from (entities are sorted by schemas, and all of their metadata fields and internal identifiers are available).
You will notice there tables with similar names. One with a regular name and one that says “$raw”
Regular table = fewer columns & fewer rows; archived entity values will be excluded
For Result Tables - Result tables in unreviewed entries are not included in it
You can preview the rows in each of these schemas by clicking on it
3. On the left SQL box, enter your SQL query, referencing one of the tables in the schema browser.
4. Click “Run Query” to execute your SQL query. The results of your query will show up below the SQL code entry block
Note: Parameters can be used to select specific sub-sets within your data without rewriting a query, yet changing specifc values such as (rate > 40). Reference this help article to learn more about Parameters. This will enable to create different visualizations using the different parameters.