Issue
You are working on an Insights dashboard that involves displaying the full name of a user but the schema table only contains a creator_id column, which displays their user ID (e.g. ent_......).
Environment
Insights
Cause
The "creator_id" column is intended to store the user's API ID instead of their full name.
Resolution steps
Join the [your_org].user table on the id column and the creator_id column from your table of interest. Then, in your SELECT column, pull the name column.
For example:
SELECT benchling.user.name
FROM benchling.example_table
LEFT JOIN benchling.user
ON benchling.example_table.creator_id = benchling.user.id