-
How is "NA" a permissible value in the "criterion_use_range" field?
I recently received a data dump of ALL rubric data from our Canvas instance so that I could analyse how our rubrics are being set up. One field I was interested to investigate was the ratio of rubrics using point vs using ranges. This field seems to be captured by "criterion_use_range" and contains values TRUE (i.e. is…
-
What determines CD2 new_quizzes.quizzes.practice_quiz value?
The new_quizzes.quizzes table has a practice_quiz boolean field described as "whether the quiz is a practice quiz." The does not correspond to a configurable field, as far as I can tell. I wonder, how is this field's value determined? What is a practice new quiz?
-
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 today syncing 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?
-
Gathering Duration Data for How long a Student Spends on an Assignment. Specifically minutes, seconds, and hours.
Hello everyone, I was wondering if there is a way for the Canvas LMS to track the specific amount of time that a student spends on each assignment in a course. I am not referring to page views, I'm referring to gathering the date, time in minutes, seconds, and hours that a student spent working on each assignment in a…
-
CD2 assignments data changed/updated?
In our CD2 Assignments table, we're noticing a weird discrepancy: - ran a query in 2/2025 and saw 50 assignments in one class from 2018 - ran the query in 2/2026 and there were fewer (only 40 assignments) We looked at the Assignments table, specifically at the ts field. On 10/1/25, 100% of the records in that table (6.5…
-
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…
-
Logic behind "Interactions by Category" in Admin Analytics
Hi Community, We are currently diving into the Admin Analytics to provide data-driven feedback to our higher education programs regarding course design and student engagement. Specifically, I am looking at the "Interactions by Category" chart (see attached screenshot). To interpret the data correctly, we are trying to…
-
What happens if I initdb after syncdb?
I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine. I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore. Now I am trying to syncdb and get the following error. ✗ ERROR: Operation syncdb failed. Reason: Table not…
-
Wrong Grade Showing in Canvas Data
We are working on a project to import grades from Canvas into Banner. During the testing phase we discovered a few students who show the correct grade in the gradebook but when we pull Canvas Data the grade is different. When we go to the gradebook and export grades we get the same incorrect grade as Canvas Data. When we…
-
Filtering noise from web_logs table for student activity
Our organization has been asked to provide data and reporting on student activity in Canvas, essentially the number of times a student has accessed courses and resources. The activity is stored in the "web_logs" table which records granular actions, similar to api calls and http requests. There is an abundance of noise in…
-
Connecting DAP to Power Bi dataflows
Hey folks I've finally managed to wrestle all of my DAP queries into Power Bi dataflows, and it was quite an ordeal. I'm currently using dataflows with DAP as a surrogate databasing solution as we do not currently have access to a SQL server that can store our info, otherwise I would probably be fetching this data using…
-
Inconsistencies in user submission attempts (new quizzes) across tables and interface
Looking for any insight as to why my CD2 submissions table and API submissions are returning an 'attempt' number that is different from CD2 submissions_version and from the New Quizzes moderate page. Also, extra attempts are always NULL even after attempts are added via New Quizzes moderate (possibly related to New Quizzes…
-
Seeking advice on CD2, ETL and presentation processes
Hey there, My institution is going to be implementing CD2 in SQL Server and Power BI in the not to distant future. I'm reaching out to see if anyone might be interested in sharing techniques, and lessons learned in any of the following: how they orgainzed the data, if and how they went about in dimensional modeling of…
-
Sample Data
I know this gets asked every couple of years, so I guess I'll take up the call this year. We're developing an application that uses CD2. We've been getting by generating fake data on a table-by-table basis as we need it, but we're getting to a point where what we really need is the full CD2 schema with data that's safe for…