Where can I find my amino acid sequence data via Insights/SQL?

Abby P
Abby P
  • Updated

Issue

I can't find where AA sequence data is stored in the data warehouse via SQL/Insights.

Environment

Insights

Cause

The Data Warehouse is a read-only SQL database that is synced from the Benchling Cloud App. So, the Data Warehouse is a separate database that is synced from the Cloud App on a regular basis, but does not automatically contain all of the same data.

Amino acid sequences are available in the $bnch.aa_sequence table, currently being implemented across tenants. The AA sequences are also stored in the Cloud App and are accessible via the API/SDK. 

Resolution steps

This data is available via SDK/API and through the $bnch.aa_sequence warehouse table.

Was this article helpful?

Have more questions? Submit a request