-
CD2: Tables holding scores or points for each student
I am attempting to use SQL to query the tables to identify the current score or points/points possible by student for each class and for each assignment as well as any quizzes (etc...). If there is a specific table that maintains the current value for this that would be great however if it is derived on the fly can you…
-
Canvas Data 2: Substitute for web_logs available?
Good morning, we were looking at Canvas Data 2, and at the data available to us. We do not have access to web_logs. We have found out that we do not have web_logs because we subscribed to the service: Managed Teaching and Learning. We found that to have access to web_logs, we would need to switch to Managed Canvas Data…
-
DAP client SSL Error
Installed the instructure-dap-client in Python 3.10 (tried 3.11 as well). Getting an error each time we try to invoke it: [SSLCertVerificationError: (1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: unable to get local issuer certificate (_ssl.c:1129)')] We are able to use both CURL and the Python Requests…
-
Getting New Quiz Responses from Canvas Data 2
I have an instructor that created new quizzes for an entrance survey and an exit survey that gauges students' knowledge pre & post course. I've downloaded our Canvas Data 2, and loaded it all into PowerBI. I've looked at the schema online, but I'm having a difficult time figuring out what the related tables for this should…
-
Identify Courses with Classic Quizzes
I'm part of the support team at a small private college (around 1500 students) and we're working towards migrating all our courses' classic quizzes to new quizzes. I was curious if there was a way to quickly identify the specific course sections that are utilizing classic quizzes, so that we don't have to open each course…
-
What table has the Rubric Criterion scores?
We are trying to pull rubric scores into our data lake. We have been able to locate and pull the outcome scores, but we have not been able to find the regular rubric criterion scores anywhere. Is it possible to pull the regular criterion scores similarly to the outcome scores?
-
ERROR - Cannot connect to host api-gateway.instructure.com:443 ssl
Hello, I am trying to configure DAP client on a new Windows server, followed all the instructions as per the documentation. When trying to fetch the list of tables using "dap list --namespace canvas", I got the below errors. Any help in resolving this error is really appreciated. Thank you. C:\Users\attilisatish>dap list…
-
Assistance with SQL Query Extracting Student Scores For Assignments and Courses in Canvas Data 2
The goal is to create a SQL query to extract the student (prefer the student ID), the course, the assignment, and the associated grade. I have the following query but it is not what I want or need. I am purposefully limiting it to a particular term but need all of the courses, assignments, scores by student. SELECT…
-
Is Canvas Data 2 available on the self-hosted Canvas Community version?
Hi Community, I am inquiring whether Canvas Data 2 is available on the self-hosted Canvas Community version. If so, how can we generate the client secret/key? It appears that the identity services for generating the secrets are only available for the Instructure-hosted instance. Best regards, Jasmine
-
DAP initdb on submissions table throws a date error
When I run initdb on the submissions table I get a "year 0 is out of range" error. It seems like I'm dealing with a bad row of data. What are the best options for resolving this? I assume I could ask our canvas admin to clean up that row of data, but that doesn't guarantee there won't be other/future rows with the same…
-
Canvas Data 2 Missing Some Learning Outcomes
Hello Everyone, We use learning outcomes quite a bit in our work. Faculty add Learning outcomes to their traditional rubrics and use them for grading in speedgrader. I don't know if it matters or not, but for the sake of completeness I'll add that faculty are instructed to do the following when adding an outcome to a…
-
Canvas Data 2 Header Files & Folder/File Names
I am working on a Python script that will download all of the files in the tables available to us in the Canvas namespace. I noticed when I unzip the .gz files, some have 1 file, the others have 2 files. The ones with 2 files in them appear to be a header file and an actual data file, but the data file also includes the…
-
Could Instructure report on CD2 status on a table by table basis?
I have an alert in place that warns me when our CD2 data retrieval process has been unable to retrieve any given table for at least a couple of days (BTW each day we retrieve snapshot data once, and incremental data every 4 hours after that, with 3 attempts each time around on each table). I received one such alert early…
-
2023-12-18 DAP Querying service is overloaded or under maintenance
Just got the following 503 { "error": { "uuid": "8a31f148-167e-4e83-981a-1982caf43480", "message": "DAP Querying service is overloaded or under maintenance.", "type": "Overloaded" }}
-
Cloud Access to CD2
Our data team asked the following: Does CD2 keep the actual tables in s3 containers as parquet or other file types ? And could they provide a url to the s3 container? Our fabric allows for linking directly to s3 containers. That's above my knowledge, but I kind of doubt Instructure will give us any other access than the…