[ARCHIVED] Is any SIS ID of user in Canvas Data Portal?

Jump to solution
ctcck
Community Member

I have just reviewed the database schema of Canvas Data Portal.

For some reasons, I would like to obtain sis_id as well as email of user (e.g. in user_dim table). Anyone has idea about it?

Please advance.

Labels (2)
1 Solution
bneporadny
Community Champion

Hi Kenneth,

The SIS ID you provide when creating the user account within Canvas can be found in the #pseudonym_dim table. Column is call #sis_user_id

Hope this helps.

View solution in original post