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?
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.
Retrieving data ...