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.