[ARCHIVED] User Data

[nick_yee]

Morning All,

I am trying to determine the role associated with a user in the User_dim table. I haven't been able to find an entity relationship diagram for Canvas Data so any help much appreciated in terms of tables and fields I need.

[robotcars]

Hi nick.yee,

CD has a role_dim set Canvas Data Portal, but it doesn't contain account roles, only course roles. Account roles aren't available in CD. So the only roles associated with users in CD are found in enrollment_dim.type where they link the user, course, and role. Here's a related discussion where  @James  does some lifting and sharing to fill the gap.

https://community.canvaslms.com/message/63016-re-is-there-a-quick-way-to-get-the-user-list-for-each-...