-
Sharing: Airflow (tested in 2.10) DAG workflow for syncing Canvas Data to Postgres
In case it's helpful for anyone, here's my working-and-also-work-in-progress DAG ("Directed Acyclic Graph" -- it's a fancy word for "workflow" or "batch job") for Apache Airflow. It will probably work as far back as 2.4, and I currently have it running on Airflow 2.10. If you're familiar with python, it's probably pretty…
-
Minimum roles/permissions required for DAP automation.
We want to setup automation for replication of data from DAP to our internal SQL environment. A secret issued to an account admin was used for testing, but we want to scope to a user with only read permissions to data in Canvas and DAP and no other permission within canvas. I have reviewed the information…
-
Page view vs Participation
Canvas has this definition (see below) for page views vs participation. I'm trying to figure out how to determine this within the Canvas Data 2 data set? What tables and filters are needed to determine this? ==================================================== from Canvas…
-
Interactions Over Time Admin Analytics Report
In an attempt to generate internal queries and reporting that mimic the Interactions Over Time report (in addition to the other reports on the overview dashboard) from Canvas Admin Analytics. We have: Identified student enrollments for enrollment types = “StudentEnrollment” where WORKFLOW_STATE IN ('active',…
-
Canvas Data 2 Documentation Down?
Hi all, Is the Canvas Data 2 documentation down? I get an access denied message when I try to access materials like the information on CD2 tables. XML file error, access denied code Thanks if you have any insights! Please let me know if I'm looking in the wrong place…
-
CD2: Microsoft Sync State (for MS Teams)
We are trying to find out who is actively using the MS Teams/O365 integrations. I can find out which courses have the "Teams Assignments" in the Course Navigation. Unfortunately, it was added by default to alot of courses. So we're only trying to find those that have the Integrations > Microsoft Sync State enabled at the…
-
Integrating Canvas with PowerBI?
Anyone had any success with integrating Canvas with PowerBI? Our analytics team would like to be able to grab info out of Canvas easily. Thanks!
-
New Quizzes
Is the data from New Quizzes available in CD2? If so, in which table(s)?
-
Data Services sends incorrect Content-Type when request signing is on
When using Data Services, you can choose to have the request signed and get a JWT payload. However, Canvas Data Services still sends the request with "Content-Type: application/json", whereas it should be "Content-Type: text/plain". Canvas Data Services is not part of the canvas-lms github repo, so where should I report…
-
CD2 Python Client Library Typing Error
I recently (18 March 2025) started getting a typing error when fetching jobs from snapshot queries using the python client library. I haven't changed anything since I started getting this error, so I'm inclined to believe there is an issue with the typing logic. This is my stacktrace: File…
-
Getting aiohttp.client_exceptions.ServerTimeoutError: Connection timeout to https://api-gateway.inst
It occurs intermittently during individual table syncs. 2025-03-11 06:15:19,229 - DEBUG course_account_associations table has been updated 2025-03-11 06:54:49,916 - DEBUG enrollments table has been updated 2025-03-11 07:33:28,644 - DEBUG course_sections table has been updated 2025-03-11 08:12:36,144 - DEBUG courses table…
-
CD2 - Assignment Override Precedence
Hi all, Hoping someone can assist. I am currently working on identifying a assignment due date at an individual student level. When there are multiple overrides set I am having trouble figuring out which override(s) take precedence. Example: a student has an individual override and is enrolled in a section which is also…
-
New Analytics; Time Students Spend in Canvas (on a weekly basis)
Hi, Is there a way to generate the time students spend in Canvas on a weekly basis? The total time is available under the "People" menu; however, I would like to have a summary of time spent and number of logins on a weekly basis. I explored the "New Analytics" report; unfortunately the New Analytics reports do not help me…
-
Canvas Python DAP, custom TEMP FOLDER location
Hello, Does anybody know how to set up a custom location for the files downloaded by the dap? Basically need to setup the temporary folder in a much larger drive, instead of the dap using the windows default temp folder for each user. I'd like to change this just for the dap instead of changing the default in windows for…
-
Canvas Data 2 schema version errors
@sgergely It seems that schema versions for a number of tables in the the canvas namespace have reverted. For example, "rubrics" had been at version 2 in mid February, but shows version 1 when downloaded today from DAP. The following tables seem to have issues: access_tokens assignment_overrides assignments attachments…