Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

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

  • 4 Likes
  • 1 Replies

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

  • 0 Likes
  • 3 Replies

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

  • 0 Likes
  • 5 Replies

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

  • 0 Likes
  • 3 Replies

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 final2024-03-06 15:48:52,993 - ERRO...

  • 1 Likes
  • 12 Replies

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

  • 0 Likes
  • 3 Replies

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

  • 0 Likes
  • 2 Replies

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

  • 1 Likes
  • 4 Replies

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

Community Champion
Data and Analytics Group
  • 1 Likes
  • 4 Replies

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

  • 0 Likes
  • 4 Replies

Hi, After updating the dap-client to v1.0.0 we appear to be experiencing an issue when attempting a syncdb on tables against the pre 1.0.0 syncs that were successful against our on site MySQL database. When we attempt a syncdb on the accounts table i...

  • 0 Likes
  • 7 Replies

So, not super familiar with Azure but we've managed to set up a pipeline (but getting occasional fails) and debating finisihing incremental approach. I do ultimately want to get this into a postgres db. At the moment I get far more reliable data usin...

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

Hi -- I'm having trouble getting dap syncdb to work in a reliable/predictable manner w/r/t the application of upstream table schema changes to my local database. For some reason it seems to be trying to execute ALTER TABLE statements every time, even...

  • 0 Likes
  • 9 Replies

A higher-up asked my boss and me whether it's possible to track which faculty members are using the Attendance (Roll Call) tool in their courses. Since we have it disabled by default in all of our credit-bearing courses, we thought we might be able t...

  • 0 Likes
  • 2 Replies

Hi, I've just updated to the latest v1.0.0 version of the dap-client plus updated the cryptography to v42.0.5 & even when I now attempt to run just 'dap --version' I get the aforementioned DLL load error. Anyone else experiencing this? Anyone resolve...

  • 0 Likes
  • 2 Replies

After upgrading to the 1.0.0 DAP client yesterday, I'm now getting a very specific error: ERROR - [Errno 28] No space left on device It appears that the DAP client is now loading up my /tmp location (which is very limited) for holding and assembly of...

  • 0 Likes
  • 19 Replies

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull incremental snapshot for changes I also collect qual...

  • 0 Likes
  • 4 Replies

Greetings, I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not have assignments with gradebook entries or assign...

  • 2 Likes
  • 3 Replies

Hi all, I was able to populate local PostgreSQL using the Python dap client, but there seems to be a discrepancy in the number of rows imported compared to what I see in the Canvas web app.For example, I can see more than 900 courses in the Canvas we...

  • 0 Likes
  • 1 Replies

A couple of years ago, I submitted this question to the community: https://community.canvaslms.com/t5/Data-and-Analytics-Group/How-to-Track-External-App-Usage/m-p/529110#M1466 Now that Canvas Data Portal has gone away, I don't know how to retrieve da...

  • 0 Likes
  • 9 Replies

We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can calculate the number of assignments submitted by stu...

  • 0 Likes
  • 1 Replies

Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs.It states that web_logs defines as follow:Stores the Canvas web application server access/request...

  • 0 Likes
  • 2 Replies

Hi all,My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back the web_logs data from 2014? If no, is there any c...

  • 0 Likes
  • 4 Replies

Hi all,   I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the code to retrieve the web_logs with datetime range. ...

  • 0 Likes
  • 7 Replies

Hi everyone,does anyone have any experience or lessons learned in regards to processing the CD2 web_logs table in AWS (Glue / Athena / etc)?We don't have any immediate specific use cases, but we know that researchers will want to query data eventuall...

  • 0 Likes
  • 33 Replies

Greetings, I'm curious how others are using and managing the Canvas web_logs data and activity reporting. There's a lot of, often vague but genuine, interest in this data for things like, Querying course activity for things like administrative drops,...

  • 1 Likes
  • 1 Replies

I have an instructor that uses both PDFs and links to websites for students to access and read.  The analytics will show if they downloaded the PDFs but not if they accessed the links.  Is there a way to get analytics to document student access to we...

  • 0 Likes
  • 1 Replies

Our organization would like to have access to Canvas Data 2. Going through Canvas Data 2 blogs, it says to contact the Customer Success Manager to get unboarded. I have no direct contact with CSM where can I find them?

  • 1 Likes
  • 1 Replies

I'm working with exported data from CD2.  I'm trying to understand how a version of a quiz submission (QUIZ_SUBMISSIONS.QUIZ_VERSION) relates to the version of the quiz.  I don't see a version assigned at the quiz level in the QUIZZES table.  So how ...

  • 0 Likes
  • 2 Replies