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

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