I'm updating our init and sync code to reflect what is prescribed in the documentation's Instructions and I am receiving the following error when i run pip install           × Building wheel for ts...

I need to find data from a course on the number of new enrollments in the course within a certain timeframe. Is there a report I can run that will give me that information? Thanks!

Hi, currently I am working on Canvas Data2 bulk data and I noticed that there is data related to which user has read the topics or replied posted by other users. Does anyone know by what action/criter...

Hello, Using the CD2 API, what is the suggested way to get the Users from the User's List on UI?  I have tried using Users and Pseudonyms but I am receiving more results compared to my original logic ...

Hello!I am new to developing with Canvas data and had two questions:1.  I saw a question from January about new quizzes and the response was that New quizzzes are not in the CD2 data.  Is that still t...

Note: Relying on my DBA since some of this is a bit over my head. Our scheduled "dap syncdb" process keeps blowing up our CPU. Our DBA used an "explain plan" to see where our performance issue are. Be...

Hello All, I'm hoping someone can help me understand something that I can seem to get my head around. I'm trying to see a list of a users page views past the last 100 entries. I have the following que...

Just this morning 5/13, we began to sporadically receive the error below when running our table syncs. We have changed nothing on our servers. Has anyone else seen this?   ERROR - malformed HTTP respo...

I have a professor who teaches a course that runs from May to June, so not the full Summer term. When they go to New Analytics it shows that there is no new analytics. We waited the 24 hours like it s...

I was wondering if anyone has found a good way to find course pages (pages that are not directly associated with a learning module) in CD2? I was hoping that content_tags would have a way to do it wit...

For assignments where the points_possible value is set to zero, I see that is a way to create an extra credit assignment.  Is there any other explanation for setting up an assignment that way? The rea...

A quiz in a course had it's due date changed from Feb 18th to March 30th.    The teacher insists that they didn't do it, and what I can see in PageViews corroborates this.    There are no other teache...

I noticed as of this morning that the handy  [PUBLIC]: CD1 to CD2 schema mapping: https://docs.google.com/spreadsheets/d/1kqCXAD9K45L0QeEtbuuMAFp2fW8o0oC8EBzJf58SjrY/edit#gid=822574172 Has been moved ...

Hey all, CD2 has been a big pain implementing for my organization, once we finally got the DAP tool working now we have v1.1 out with this mandatory namespace issues now and a mountain of new errors.W...

Hi All, I am trying to find where in Canvas Data2 tables can i determine the number of page views a student has on a particular course. I saw a few community page solutions that talks about utilising ...

I'll state up front that I may not understand the purpose of the OVERRIDDEN columns found in the assignment_overrides table.  However, given the documentation associated with the columns, then one or ...

Hi I'm looking for advice about working with web_logs and in particular how we might track students' usage through remote_ips. I'm currently maintaining a small server running MariaDB which uses the d...

From the PostgreSQL DDL script for the "assignments" table, the columns EXCLUDE_BIBLIO and  EXCLUDE_QUOTED have the same comment. Here's the comment:  Selecting this option will exclude text appearing...

Hi Folks!After running into the issue of no data being inserted after syncdb, I reinstalled everything, including python, DAP client, PostgreSQL and upgraded to tsv2py 0.6.2. That seemed to solve the ...

Has anybody that was using the Harvard Data 1 extract successfully converted it to use Data 2 and was it just changing the API data?

We are looking to download certain table data, transform it, and then upload to our Azure DataLake storage.The solution I have been working on involves a Python Azure Function app. Since the DAP parqu...

Good morning folks!After updating to the new stable release of the DAP CLI tool, I was able to smooth out some existing issues which some of you have already experienced:TCI_KEEPIDLE issue was an OS/P...

I'm trying to extract all clicks to a specific URL from web logs, with user ID-level detail. However, when filtering the logs to that URL, I noticed some users have multiple records (5-10) with timest...

Hi - I'm using DAPClient 1,1 and postgres 16 With an incremental query I've discovered we seem to have started losing pseudonym "id"'s. e.g. users.id 2720 has pseudonym.id 2689, but in the pseudonymn ...

Hi,    Does anyone have any idea how to track the usage of SCORM packages across the entire instance. I need the number of packages deployed and the number of courses that have at least one package de...

On several table downloads using initdb I'm getting dozens of the error below. This has only been on a few tables so far. I have tried dropping the table and re-running, that worked once but not on th...

Hello all, our team is new to developing solutions to pull data from Canvas.  I have been lurking in the forums for a bit, trying to gather as much information I can to set up the correct tools that w...

Hi All,Our group recently rebuilt our entire Canvas database with the release of DAP 1.1.0 (we were behind and using a deprecated version until that point). After dropping and initdb'ing all our table...

Hey Community,I’m currently trying to migrate my application to use Canvas Data 2 and I’ve been running against a problem and was wondering if you could help.Example:RootAccountSubAccount1Account1Acco...

Confession: I am not a developer or an SQL expert, but I can view certain kinds of code, sort of learn it, and make adjustments as needed. Otherwise, I rely heavily on ChatGPT, particularly when it co...

We are announcing the end of the beta for the older versions (0.x) of the DAP CLI as we fully transition to the latest and most advanced version, v1.1.0. This move ensures that all users are leveragi...

I have recently joined as a Senior Product Manager for the Instructure Data & Insights team. I’m overseeing the DAP Query API and the DAP CLI client and library. I look forward to meeting many of you...

Intro: When accessing your data via the DAP CLI or the API, it is important to understand where your data lives. DAP has a few different namespaces to break out the different data points that are ava...

Overview: Introducing the GA release of the Data Access Platform CLI & Client Library! In this post, we'll walk you through everything you need to know to effectively utilize the Data Access Platform...

In the past two days, our weblogs (including user_agents table) data processing experienced some issues while completing the query jobs for customers in the North Virginia region. As an effort to prev...

This is a notice to customers, that our data processing experienced some issues and queries returned 502 while execution time started to increase. We have set the Canvas Data 2 status to Performance d...

What is Canvas Data 2? Canvas Data is a comprehensive analytics solution. It offers administrators and institutions the ability to access and analyze data related to student and course activities wi...

A bug fix that was released on September 22nd may affect your integrations:What was the problem that we fixed? For the tables that use the function compose_version_global, the resulting id’s can be in...

Queries for Canvas metrics.  Anyone have sql queries for clicks, views for assignments by college. And other metric queries for external ,tools used, submissions in a day by college. If you have a sta...

Back at the start of the year I had the idea to repurpose some of the reports we had previously created to support our residential campuses.  This included a modified version of an early warning repor...

In the past two days, our Canvas Data data processing experienced some issues while building files for Canvas Data customers in the North Virginia region. Some customers might not see the latest data ...

Since Caliper events were introduced, some Caliper events have been mistakenly classified as events triggered by an application (where an agent is a software application), instead of end-user trigged ...

We have identified a root cause of the request data loss and remedied the situation. Unfortunately, the volume of requests was very high and up to 20% of request logs were omitted from the Canvas Data...

Due to the unprecedented volume of requests coming to Canvas application servers, our request data sharing process for the North Virginia region has experienced some request log data loss on 8/24, 8/2...

In the Canvas Data (2018-12-11) release, an identifier that is a reserved word in some systems (such as AWS Redshift) was introduced in some Outcomes Tables. The ‘percent’ column in the learning_outco...

We're proud to introduce a Canvas Network course being offered FREE by Jing Qi and Brian Reid of Dartmouth College. The course is titled "Analytics in Course Design: Leveraging Canvas Data," and will ...