AnsweredAssumed Answered

Deobfuscate user_dim.id?

Question asked by George Payne2 on Apr 15, 2020

Canvas Data portal question: how do I link from somewhere (say Quiz_submission_fact.user_id) to a user? the "id" field in the user_dim table (downloaded) is described as "obfuscated" and does not match format of user_id elsewhere.

 

Sorry if this is an FAQ/obvious, but I did search and did not find it. How do I de-obfuscate? I need to link to the user and to their pseudonym (sis_id).

 

I am using file downloads, if relevant.

Outcomes