We're having issues with the SQL generated by the DAP. I was on the 1.3.1, and now using 1.4.0,  to see if that might resolve the issue. I'm using the python dap module to sync/init  and using the MS SQL Dialect for our canvas data 2 tables and I not...

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? 

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

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

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

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

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