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 p...

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 codeThanks if you have any insights! Please let me know if I'm looking in t...

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!

Is the data from New Quizzes available in CD2?  If so, in which table(s)?

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 t...

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 studen...

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 "N...

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 cha...

@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 h...

I'd like the details of these elements to understand what it means and how it's calculated on this API endpoint: https://canvas.instructure.com/doc/api/analytics.html#method.analytics_api.course_student_summaries  

HI, I'm looking to migrate our CD2 setup from postgres to MSSQL and I'm running into an issue. Does anybody have information on properly setting the DAP for MSSQL server? I'm not finding any information beyond the basic connection string used and i'm...

Hi all, Can someone please help me understand what the Assignment_Overrides.Set_Type = 'Noop' means? I can't seem to find any documentation on it. Thanks all  Rachel

When running the following from the command-line, I get an error that prevents me from synchronizing the collaborations table: >dap initdb --namespace canvas --table collaborations 2025-02-12 14:16:09,376 - INFO - Query started with job ID: 5bb1d1c0-...

Wondering if anyone would be willing to share how they might be forwarding Canvas activity logs to an external logging system (Splunk or syslog)?  More specifically, how you are getting analytics out externally to see student activity logs of assignm...

Hi all,I am trying to figure out how to identify if an assignment grade is visible to a student (posted) using CD2 data.The submissions table workflow state only has a 'graded' state but that doesn't identify if it is available to students.Any help w...

Hi All,Our group noticed a few tables producing error messages with the updates to the enumeration types recently. Upgrading the DAP client to the 1.3.1 didn't seem to fix the problem with the enum type update, but I did notice a change in the syntax...