Why is my creator_id column from my entry table on Insights different from the actual authors of my entries?

Sewon
Sewon
  • Updated

Issue

I want to pull the authors of my notebook entries onto my Insights dashboard but pulling the creator_id column from the <myorg>.entry$raw table is different from the actual authors of the entries. Also, even when I have more than 1 authors for an entry, only 1 user shows up via this column.

 

Environment

Insights, Notebook

 

Cause

The creator_id column is the user that created the entry and not necessarily the author of that entry. For example, User A can create Entry A but change the authorship to User B after creation. User A will still be recorded as the creator in the creator_id column but they aren't the author of the entry.

 

Resolution steps

If you wish to pull the authors (and not the creator) of an entry, join the <myorg>.author$raw table to your entry table instead of using the creator_id column.

 

Was this article helpful?

Have more questions? Submit a request