The most recent content from our members.
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…
This behavior has been resolved and deployed to the production environment as of 9/8/25. Description Since the implementation of the new identity service login the new logins that should not show for local admins is included in the Canvas Data 2 Pseudonyms table. Expected Behavior Please remove these from the table as end…
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…
Presenter * Mark Reynolds, University of Illinois Description Canvas Data 2 is a great source of information regarding your Canvas service. However, there are challenges in obtaining the data in a quick and efficient manner. We go beyond processing individual tables with yet another "easy peasy" solution using tools that…
Introduction It was great seeing everyone this past week, and thank you to all who attended our Canvas Data 2 Meetup on Thursday, July 11! As promised, @JenniferLash and I wanted to follow up so we can continue the awesome and engaging discussion we all had on Thursday, as well as invite others who may find this post to…
Hello, With the deployment of the 1.3.0 client, I've decided to TRY and migrate from Postgres into my native SQL Server environment. I have successfully initialized ~88 tables, but I know that's not enough. I'm seeing an issue within the Assignments table that probably exists in other tables. The script that's creating the…
@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…
We recently did a new snapshot of our catalog tables and noticed that the enrollments table contained duplicates of most records. Other tables seemed OK. Has anyone else noticed duplicate records in snapshots? Thanks.
Hi everyone, I’m looking for ways to evaluate and improve student retention at our university, and I’m particularly interested in leveraging data from Canvas Data 2 as well as other sources to identify and support struggling students. At the moment, I’m exploring the best ways to analyze and apply data effectively to flag…
I have recently joined as a Senior Product Manager for the Instructure Data & Insights team. I’m overseeing the DAP Query API and the DAP CLI client and library. I look forward to meeting many of you to discuss your data and analytics priorities. As I started to work on shaping the roadmap for these products, I'm eager to…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.