Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

This API is working great for students:  https://xxx.test.instructure.com/api/v1/courses/:courseid/analytics/users/:userid/activity But it is limited to student data.  How are folks using the API to get high level activity data by course? 

Community Participant
Data and Analytics Group
  • 0 Likes
  • 2 Replies

I'm working on an archiving scheme for our past courses. As part of this, I'm interested in finding a way to generate a report featuring all the courses that have had no user access in five or more years. How might one find this out using Canvas data...

  • 0 Likes
  • 2 Replies

Is there a way to tell via CD2 if a course is using Enhanced Rubrics?  I didn't see it in the entity diagram for Rubrics table, but I might have missed something... Thanks Ian

Community Contributor
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hi,  When I try to export a table through dap intidb command for a table from canvas space: context_module_progress. I use the following command:  dap --loglevel debug initdb --connection-string "mssql://username:password@prodsqlserver.database.wind...

Community Member
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hello,  I'm posting here for our developer. I hope someone can help steer us in the right direction. We have been running the CD2 API for almost a year. We have run a full reload of the tables once with a column addition, and process delta runs daily...

Community Participant
Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hi,I am trying to load two tables from canvas namespace into SSMS through the use of DAP command line interface:This is the command that I am using:dap initdb --connection-string "mssql://username:password@princedev.database.windows.net:1433/princedb...

  • 0 Likes
  • 2 Replies

I've read carefully two threads that discuss the contents of the quizzes and assignment tables in CD2:  https://community.canvaslms.com/t5/Data-and-Analytics-Group/Assignments-vs-Quizzes/m-p/576490#M1836https://community.canvaslms.com/t5/Data-and-Ana...

Community Contributor
Data and Analytics Group
  • 1 Likes
  • 3 Replies

I don't think this is the intended behavior. But please correct me if I am wrong.Table: pseudonymColumn: value_unique_idData: `NORMALIZATION-COLLISION-d5863032-ag94-4593-6g6d-adf9371f2eb9-xxxxx@gmail.com`spit-balling:So I'm beginning to think that th...

Community Participant
Data and Analytics Group
  • 0 Likes
  • 0 Replies

I am currently assuming that a web_logs record is never updated inside of Canvas Data 2. Is this assumption true? Background: I am currently importing Canvas Data 2 web_logs records via the dap sync command regularly. I have a process that regularly ...

  • 0 Likes
  • 1 Replies

Hi there, We're new to the DAP CLI (for MSSQL) and we managed to get the initdb and syncdb working with MSSQL using SQL Authentication. However does anyone managed to connect to the MSSQL with Windows Authentication and if so, how should the connecti...

  • 0 Likes
  • 2 Replies

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

Community Contributor
Data and Analytics Group
  • 1 Likes
  • 0 Replies

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

  • 0 Likes
  • 1 Replies

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? ========================================...

  • 0 Likes
  • 3 Replies

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

  • 0 Likes
  • 2 Replies

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

  • 0 Likes
  • 2 Replies

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

Community Contributor
Data and Analytics Group
  • 1 Likes
  • 5 Replies

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!

  • 1 Likes
  • 1 Replies

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

  • 3 Likes
  • 2 Replies

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

Community Member
Data and Analytics Group
  • 1 Likes
  • 0 Replies

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

  • 0 Likes
  • 5 Replies

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

  • 0 Likes
  • 2 Replies

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

  • 0 Likes
  • 2 Replies

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

  • 1 Likes
  • 2 Replies

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

  • 0 Likes
  • 7 Replies

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

  • 0 Likes
  • 9 Replies

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.

Community Participant
Data and Analytics Group
  • 0 Likes
  • 0 Replies

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  

  • 1 Likes
  • 2 Replies

Has anyone experience this issue?  When we run syncdb to refresh our CD2 enrollments table to postgres, the process hangs and does not finish.  All other tables sync successfully.  Some enrollments data are being loaded to the database.  We can confi...

  • 0 Likes
  • 2 Replies

Hi everyone  Im hoping someone else out there has found a way to resolve this challenge.... Problem definition: We use assignments with rubric assessments for grading, but we want to have visibility of the movements within the rubrics so it is easy ...

Community Explorer
Data and Analytics Group
  • 0 Likes
  • 0 Replies

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

  • 1 Likes
  • 6 Replies