-
CD2 - How many assessment submissions have been graded
Howdy, I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff. I use CD2 CLI to download CD2 tables. I then import into a database and then run SQL queries on the data. In the submissions table, it's my understanding that there are not entries for every…
-
Canvas Data 2 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/t
I am able to call the schema endpoint, but I am getting a 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/table/' + $splitValue + '/data' The error is: Failure: Failed to execute the request, or the endpoint responded an error, Reason: Got response 404 - Not Found from the endpoint,…
-
Using DAPSession.stream_resource
Hello, I am trying to use DAPSession.stream_resource to stream resources/files directly into an S3 bucket. The idea is to pipe the stream directly into S3 without downloading and storing the entire file locally first, and then reuploading it into S3. However, I am not sure how to use that method. First, I am not sure how…
-
CD2 Adding new dialect - Snowflake
Hi all, We'd like to sync Canvas Data2 to our data warehouse, which is on Snowflake. Snowflake uses its own SQL dialect. The DAP Client documentation states that it only supports Postgres and MySQL. Prior to the release of v1.0.0, there were instructions on how to create plugins for other SQL dialects for the DAP client…
-
Discrepancy Between Course and Grading Standards
In the CD2 data I'm working with I have noticed that a course in the Courses table has a NULL value for the Grading_Standard_ID column. However, in the Grading_Standards table there is a row where the Context_ID column has the ID of the course. Is this something that a user could have messed up? Or is Canvas not keeping…
-
Canvas Data 2 GUI Python Client
Hi everyone! I created a GUI client for Canvas Data 2 to do snapshot or incremental pulls. So I wanted to share my Github repository for it. https://github.com/coldplazma/Canvas-Data2-client/tree/main
-
CD2 Ungraded Submissions
Howdy, I use CD2 CLI to download CD2 tables. I then import into a database. I am trying to set up a query to show all assignment submissions that are not yet graded. It seems to me that the submissions table that I download using the CD2 CLI is not showing separate entries for multiple submissions of the same assignment by…
-
Course Primary Instructor
Hi All, I have been looking over the ER diagram and documentation for Canvas Data 2 trying to find some sort of indicator for the primary instructor of a course. In many cases we have multiple teacher enrollments for a given course, and we'd only like to report the primary instructor. Does such a thing exist?
-
Error with 1.0: operation not permitted; cannot drop values in an enumeration: dimdim
I am still attempting to get all of our tables syncing again after the changes with 1.0, and when trying to update the web_conferences table I am receiving the following error: pysqlsync.formation.object_types.FormationError: operation not permitted; cannot drop values in an enumeration: dimdim. Full Lambda stack trace is…
-
DAP 1.0.0 syncdb error in PostgreSQL - table not initialized, use "initdb"
I used the initdb command to create a table. The table is created successfully with some data. Then when I try to use the syncdb command the following error appears: INFO:pysqlsync.postgres:PostgreSQL version 16.0.2 final 2024-03-06 15:48:52,993 - ERROR - table not initialized, use `initdb` Has anyone seen this error and…
-
Canvas Data 2 API - Incremental Query Empty Files?
Hello I was wondering if anybody else has encountered files returned by the incremental queries in the CD2 API being in empty parts? In the screenshot we ran an incremental query but seem to consistently get a part 0 that's empty, that doesn't feel intended. Thanks
-
Canvas Data 2 - User's Feature Usage, PageViews and Device Usage
Hi all, Is it possible to extract a user Feature Usage data, PageView Data and Device Usage/used from Canvas Data 2? I'm fairly new to data analytics and have been scouring the tables from CD2 but unfortunatly thus far I've not really found and tables which would relate to this sort of data. I see in the Canvas Live API…
-
Discrepancy between internal Canvas reports and Canvas Data 2
Hi Everyone, Our organisation recently got access to Canvas Data 2 and I have been comparing data pulled from CD2 to Canvas' internal reports and have noticed some large discrepancies. For example when looking at the enrollments table from CD2, I get around 10% of the rows expected. The same is true for users, quizzes,…
-
Benefits and successes of CD2?
What are the new capabilities that came with the transition to Canvas Data 2? What new reports or benefits have been realized? For example: * late_policies: We can now see if assignments have a missing submission policy set and how many points are deducted when an assignment is missing. That helped us see where a person…
-
Online attendance
Hi all! We use new analytics for online attendance. It seems it isn't capturing records for several students across multiple grade levels and classes. It is turned on in all courses, everything seems to look good on our end. Any thoughts on what is happening here and how to rectify?