Prompted by the most recent Canvas release notes, we looked into the Page Views feature, and we were happy with the new documented changes. However, we notice that more user actions are done by GraphQL API, which does not provide details in the page ...

  I am currently teaching five courses this semester with more than 70 students. To track their progress, I currently have to review each course and section individually, which is very time-consuming. Ideally, I would like to consolidate key informat...

Has anyone implemented some form of data profiling, quality assurance checks, or similar mechanisms to identify significant changes and/or problems in the data you're bringing in from DAP? If so, would you be willing to share what you're doing as exa...

I am aware that Canvas offers a limited analytics suite for courses. I am also aware that you can track the course time spent per student. We would like to average how long it takes our students to complete our courses, but as far as I can tell, ther...

This is what I currently see, but we do not have that feature enable and it would be highly needed to pull attendance reports across different courses. Many thank in advance. Guido Reverdito  

The issue -- we currently pull reports from the api/v1/reports several times a day, and the person who is responsible for those jobs that has complained to me on multiple occasions that they take a long time and often get stuck or fail, because of th...

Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to determine which files are visible to students (on...

Using Canvas Data 2 data, I'm looking at student answers for Calculated questions.  When a question is correctly answered, the Answer_ID is populated.  When the question is incorrectly answered the Answer_ID is empty/blank, in fact the name/value pai...

Hi all, We have a small number of records for the CD2 web_logs table where the course_id column is populated by what looks like the shard id (flashbacks to CD1) and not the course id. (I don't mean the shard_id + course_id, but just the four digit sh...

Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data.We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP...

We upgraded to the new DAP CLI 2.0.0 and are trying to use the new logging feature but we're getting "Error: No such option: --loglevel" This is our command: dap initdb --table attachments --namespace canvas --loglevel debug  

Hello all, I am sitting in a session at instructurecon right now and a lot of people are asking questions about getting started with their reporting and analytics goals. I thought I would make this post so that people could connect.

The context_modules_progressions table is said to show which items a student has completed, started and not started in a module.   https://developerdocs.instructure.com/services/dap/dataset/dataset-namespaces/dataset-canvas#dap_schemas.canvas.context...

Hello friends! I am reaching out to better understand what the wider community, or those willing to have a quick email chat, is doing with regards to understanding their Outcomes.   Previously, we had a person from our Data & Research Team who would ...

Hello, We are currently using the Analytics API provided in the Instructure Developer Documentation Portal to retrieve certain metrics-related data.We would like to know if it’s possible to replicate these datasets using the Canvas Data Platform (CDP...

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