Block templates make it easy to run basic queries in Insights without having to touch a line of SQL.

To add a block using a template:

  • Click Add block

  • Select a template from the Templates section in the menu

To fill out the template:

  • Select the schema that has the data you're interested in

  • Check Exclude duplicate values to remove any duplicates in the results (optional)

  • Use the checkboxes next to the field names to select which columns you'd like to include

  • Update the fields' display names to change the column names (optional)

  • Customize your SQL query by filtering your results based on a specific parameter

When you're done filling out the form, click Run Query to submit the form and see the results. You can keep the results in the form of the table, or configure a visualization as you normally would. The block will show up once you navigate back to your dashboard.

Please note that if you select Edit SQL to make custom edits to your query, make sure you're done filling out the form before you do this, because you won't be able to return to the form once you edit the SQL query.

If you are not sure if you have this feature enabled, reach out to your main Benchling point of contact or to Benchling Support

Did this answer your question?