Warehouse and Data
Querying the Benchling Warehouse with SQL, plus a per-domain reference for every table it exposes.
The Benchling Warehouse is a read-only SQL database that mirrors your tenant’s data. Use it when you are more comfortable in SQL than in the REST API, when you need large amounts of data at once, or when you are connecting a third-party analytics or visualization tool.
The Warehouse uses its own credentials, separate from the API authentication methods described in Authentication. Data syncs on a delay, so if you need values guaranteed current, read them through the REST API instead.
Getting Started
Getting Started with the Warehouse covers requesting access, connecting, and running your first query.
Querying the Warehouse
- Warehouse Tables explains how the schema is laid out and the joins you will reach for most.
- Multi-Tables covers the
$rawtables and the per-schema tables built on top of them. - Custom Warehouse Views walks through defining your own views from the Insights SQL editor.
- SQL Queries Hints (Advanced) collects performance notes for large queries.
Table Reference
A per-domain reference for the tables the Warehouse exposes.
Users, Teams and Projects · Registry · Molecular Biology · Results and Runs · Notebook · Notebook Entry Tables · Notebook Review Tables · Notebook Worksheet Tables · Inventory · Requests · [Beta] Biologics · [Beta] Procedures · Workflows · Legacy Workflows · Mixtures and Batches · Studies · Deprecated Tables
Moving data in and out
For loading data into Benchling or exporting it through the API rather than the Warehouse, see Importing Data with the Bulk Import API and Exporting Data with the Bulk Export API. The Data Lake Integration accelerator covers the export, change-monitoring, and insert components of a data lake pipeline.