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

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

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

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

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

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

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

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

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

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

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.

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

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

I need to implement an attendance monitoring system that triggers alerts when a student's attendance rate falls below 85%. However, to avoid false alarms at the start of a course when the sample size is small (e.g., missing 1 out of 2 classes would s...

Hi all, I am needing to identify the students who have access to a discussion, page/wiki or module via CD2 when access has been limited to certain sections and or students via the 'Assign Access' feature. Is someone able to help point me in the right...

After updating to the latest and greatest Canvas Data 2 dap client cli version, I notice the dap_meta table (which stored the timestamps of when all the tables were last updated) seems to have been renamed to dap_meta_backup, and there is no replacem...