How and when should I use schema specific tables or the single “registry_entity” table?

  • Updated

Schema Specific Table

Let’s say I want to connect a registry table myosin_motor_protein to a results table procession_assay and pull certain values out from these 2 schemas. The query would look like so:

SELECT assay.timestamp AS "Time",
assay.fluorescence_rfu AS "Fluorescence",$ as "Myosin",
myosin.created_date AS "Created Date",
myosin.procession_rate AS "Procession Rate",
myosin.protein_family AS "Protein Family",
myosin.color as "Color"

FROM alab.myosin_motor_protein AS myosin

LEFT JOIN alab.procession_assay$raw AS assay
ON assay.entity =

Here’s what the output might look like:

“Registry_Entity“ Table

By using the overarching registry_entity, schema$raw and field$raw tables, and then narrowing down by particular schema, the query results show all of the data that you’ve specified by schema using the WHERE clause.

SELECT,, field.field_name, field.value
FROM registry_entity
LEFT JOIN schema$raw schema
ON registry_entity .schema_id =
LEFT JOIN field$raw field
ON = field.schema_id
AND = field.registry_entity_id
WHERE = 'Myosin Motor Protein'
ORDER BY, field_name

Here’s what the output might look like:

Pre-Schema vs "Registry_Entity" Comparison

Was this article helpful?

Have more questions? Submit a request