CD1 to CD2 schema mapping document.

Hi ,

In the CD1 to CD2 schema mapping document below,

[PUBLIC]: CD1 to CD2 schema mapping - Google Sheets

enrollment_dim&fact sheet

user_id field is obfuscated using the command "

obfuscate_global(cast(enr.user_id AS bigint), g_shard_id)". But it's coming up with error in sql; "'obfuscate_global' is not a recognized built-in function name." in SQL. Am I missing any function associated with it here? Thank you in advance.

Find more posts tagged with

Accepted answers

All comments

There are no accepted answers yet

Unanswered Questions

Error when performing DAP syncdb on web_logs table
We are getting this error today when syncing the web_logs table and the sync fails. I have never seen this one. 'invalid input value for enum canvas_logs.web_logs__web_application_context_type: "SisBatch"' Has anyone else seen this?
Error initializing large table using dap on python 3.14
Hi — I've been struggling to initialize our "submissions" table using the dap CLI and I've narrowed down the problem to Python 3.14. I'm able to successfully run the same exact initdb command (on the same EC2 instance) under Python 3.13 and 3.12. On Python 3.14.2, the import successfully processes about 34 million records…
EDUCAUSE Insights: Data and Decision-Making
EDUCAUSE is full of inspiration, whether you’re onsite or following from afar. Join the evolution by sharing what sparks your curiosity, the questions you have, and the insights you discover. We'll learn from each other, expand our networks, and strengthen our Community. Your perspective matters, and the more we share,…
Problems with GraphQL in User Pageviews reports
Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page view report, either in the GUI or in the CSV file download. We and most…
Metrics Easy Button
I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key information for all students into a single Excel file—showing class attendance…