-
New Quizzes now available in CD2/DAP
I just noticed an update (posted about a week ago) to the canvas product roadmap that seems to indicate that "New Quizzes data is now available in DAP/CD2, providing seamless access to key data points for analysis. Institutions can now retrieve quiz performance metrics, student data, and outcomes at scale." However, there…
-
DAP initdb error: missing dependency asyncpg
When I try to run the following command: dap initdb --namespace canvas --table accounts I receive the error: missing dependency: `asyncpg`; you may need to run `pip install pysqlsync` although pysqlsync is installed already. (pysqlsync 0.8.3) Any advice on what steps need to be taken to fix this? Running Python 3.14.0 and…
-
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…
-
Profiling and/or quality assurance testing Canvas data
Has anyone implemented some form of data profiling, quality assurance checks, or similar mechanisms to identify significant changes and/or problems in the data you're bringing in from DAP? If so, would you be willing to share what you're doing as examples? For context, Instructure delivered a change this summer that…
-
Is there a way to average course completion time for a student cohort?
I am aware that Canvas offers a limited analytics suite for courses. I am also aware that you can track the course time spent per student. We would like to average how long it takes our students to complete our courses, but as far as I can tell, there is no display of that average. I also don't think I can find a way to…
-
As an Administrator, how can I enable the Roll Call Attendance Reports in the Analytics Hub?
This is what I currently see, but we do not have that feature enable and it would be highly needed to pull attendance reports across different courses. Many thank in advance. Guido Reverdito
-
With dap cli, lightweight method to determine if data has been updated since last syncdb
The issue -- we currently pull reports from the api/v1/reports several times a day, and the person who is responsible for those jobs that has complained to me on multiple occasions that they take a long time and often get stuck or fail, because of the size of the reports. It looks like all of the data in those reports is…
-
tab_configuration data missing from some records in courses table
Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to determine which files are visible to students (one component of which is whether or not the "Files" section of a course…
-
Submissions Incremental Query job run time
I am developing a AWS process that uses a Step Function to coordinate Lambda Calls in order to get data from the DAP client for our data lake. However, I am running into an issue with the Submissions table where it is taking almost an hour for an Incremental query of about 10 days of data, but the Snapshot query takes only…
-
Descriptions/codes for numbers in the web_logs.web_application_action column?
Hello - I am trying to decipher the web_application_action column in the web_logs table. Per the schema, the integers returns should be referring to "The action in the Canvas web application used to service this request." I can not find any reference for what these numbers actually mean, either in the DAP documentation or…
-
Answer_ID Is Empty For Calculated Question Answered Wrong
Using Canvas Data 2 data, I'm looking at student answers for Calculated questions. When a question is correctly answered, the Answer_ID is populated. When the question is incorrectly answered the Answer_ID is empty/blank, in fact the name/value pair isn't even in the JSON. How am I supposed to match the student's…
-
shard id in course_id column of web_logs table
Hi all, We have a small number of records for the CD2 web_logs table where the course_id column is populated by what looks like the shard id (flashbacks to CD1) and not the course id. (I don't mean the shard_id + course_id, but just the four digit shard_id.) I'm just curious if anyone else has seen this and has any insight…
-
Analytics API / Metrics calculation logic
Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data. We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP), instead of relying on API calls. For example, could you please advise…
-
Error when trying to use logging
We upgraded to the new DAP CLI 2.0.0 and are trying to use the new logging feature but we're getting "Error: No such option: --loglevel" This is our command: dap initdb --table attachments --namespace canvas --loglevel debug