Data and Analytics Discussions

Discuss, share tips, and ask questions about data and analytics across all our products

Howdy, I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff. I use CD2 CLI to download CD2 tables. I then import into a database and ...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 1 Replies

I am able to call the schema endpoint, but I am getting a 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/table/' + $splitValue + '/data' The error is: Failure: Fa...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hello,   I am trying to use DAPSession.stream_resource to stream resources/files directly into an S3 bucket. The idea is to pipe the stream directly into S3 without downloading and storing the entire ...

Community Member Data and Analytics Group
  • 0 Likes
  • 4 Replies

Hi all,We'd like to sync Canvas Data2 to our data warehouse, which is on Snowflake. Snowflake uses its own SQL dialect.The DAP Client documentation states that it only supports Postgres and MySQL. Pri...

Community Member Data and Analytics Group
  • 0 Likes
  • 5 Replies

In the CD2 data I'm working with I have noticed that a course in the Courses table has a NULL value for the Grading_Standard_ID column.  However, in the Grading_Standards table there is a row where th...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi everyone! I created a GUI client for Canvas Data 2 to do snapshot or incremental pulls.  So I wanted to share my Github repository for it.    https://github.com/coldplazma/Canvas-Data2-client/tree/...

Community Member Data and Analytics Group
  • 2 Likes
  • 0 Replies

Howdy, I use CD2 CLI to download CD2 tables. I then import into a database. I am trying to set up a query to show all assignment submissions that are not yet graded. It seems to me that the submission...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 3 Replies

Hi All,I have been looking over the ER diagram and documentation for Canvas Data 2 trying to find some sort of indicator for the primary instructor of a course. In many cases we have multiple teacher ...

Community Member Data and Analytics Group
  • 0 Likes
  • 5 Replies

I am still attempting to get all of our tables syncing again after the changes with 1.0, and when trying to update the web_conferences table I am receiving the following error: pysqlsync.formation.obj...

Community Participant Data and Analytics Group
  • 0 Likes
  • 3 Replies

I used the initdb command to create a table. The table is created successfully with some data. Then when I try to use the syncdb command the following error appears:INFO:pysqlsync.postgres:PostgreSQL ...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hello I was wondering if anybody else has encountered files returned by the incremental queries in the CD2 API being in empty parts? In the screenshot we ran an incremental query but seem to consisten...

Community Participant Data and Analytics Group
  • 0 Likes
  • 3 Replies

Hi all,  Is it possible to extract a user Feature Usage data, PageView Data and Device Usage/used from Canvas Data 2? I'm fairly new to data analytics and have been scouring the tables from CD2 but un...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi Everyone,Our organisation recently got access to Canvas Data 2 and I have been comparing data pulled from CD2 to Canvas' internal reports and have noticed some large discrepancies.For example when ...

Community Member Data and Analytics Group
  • 0 Likes
  • 0 Replies

What are the new capabilities that came with the transition to Canvas Data 2? What new reports or benefits have been realized?  For example:  late_policies: We can now see if assignments have a missin...

Community Champion Data and Analytics Group
  • 0 Likes
  • 3 Replies

Hi all! We use new analytics for online attendance. It seems it isn't capturing records for several students across multiple grade levels and classes. It is turned on in all courses, everything seems ...

Community Member Data and Analytics Group
  • 0 Likes
  • 4 Replies

Hi, After updating the dap-client to v1.0.0 we appear to be experiencing an issue when attempting a syncdb on tables against the pre 1.0.0 syncs that were successful against our on site MySQL database...

Community Member Data and Analytics Group
  • 0 Likes
  • 7 Replies

So, not super familiar with Azure but we've managed to set up a pipeline (but getting occasional fails) and debating finisihing incremental approach. I do ultimately want to get this into a postgres d...

Community Participant Data and Analytics Group
  • 0 Likes
  • 0 Replies

Hi -- I'm having trouble getting dap syncdb to work in a reliable/predictable manner w/r/t the application of upstream table schema changes to my local database. For some reason it seems to be trying ...

Community Champion Data and Analytics Group
  • 0 Likes
  • 9 Replies

A higher-up asked my boss and me whether it's possible to track which faculty members are using the Attendance (Roll Call) tool in their courses. Since we have it disabled by default in all of our cre...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi, I've just updated to the latest v1.0.0 version of the dap-client plus updated the cryptography to v42.0.5 & even when I now attempt to run just 'dap --version' I get the aforementioned DLL load er...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

After upgrading to the 1.0.0 DAP client yesterday, I'm now getting a very specific error: ERROR - [Errno 28] No space left on device It appears that the DAP client is now loading up my /tmp location (...

Community Participant Data and Analytics Group
  • 0 Likes
  • 17 Replies

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull in...

Community Member Data and Analytics Group
  • 0 Likes
  • 3 Replies

Greetings, I'm working on a Canvas Data 2 query I'd like assistance with. The goal is to identify courses where the Canvas Gradebook is not being used. Scenarios I can envision are courses that do not...

Community Explorer Data and Analytics Group
  • 1 Likes
  • 1 Replies

Hi all, I was able to populate local PostgreSQL using the Python dap client, but there seems to be a discrepancy in the number of rows imported compared to what I see in the Canvas web app.For example...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

A couple of years ago, I submitted this question to the community: https://community.canvaslms.com/t5/Data-and-Analytics-Group/How-to-Track-External-App-Usage/m-p/529110#M1466 Now that Canvas Data Por...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 9 Replies

We are working on some data models to be displayed in PowerBI. I have a question regarding assignments when there is not a submission type, the assignment table will have a value of None. So, I can ca...

Community Member Data and Analytics Group
  • 0 Likes
  • 1 Replies

Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs.It states that web_logs defines as follow:Store...

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

Hi all,My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back ...

Community Member Data and Analytics Group
  • 0 Likes
  • 4 Replies

Hi all,   I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the c...

Community Explorer Data and Analytics Group
  • 0 Likes
  • 7 Replies

Data and Analytics Blog

Read tips and tricks about Instructure's data and analytics features

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

Instructure Data and Analytics Group
  • 1 Likes
  • 0 Replies

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

Instructure Alumni Data and Analytics Group
  • 1 Likes
  • 16 Replies

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

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

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

Instructure Data and Analytics Group
  • 8 Likes
  • 2 Replies

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

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 1 Replies

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

Community Member Data and Analytics Group
  • 0 Likes
  • 2 Replies

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

Community Champion Data and Analytics Group
  • 0 Likes
  • 0 Replies

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

Instructure Alumni Data and Analytics Group
  • 2 Likes
  • 1 Replies

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

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

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

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 0 Replies

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

Instructure Alumni Data and Analytics Group
  • 0 Likes
  • 2 Replies

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

Instructure Data and Analytics Group
  • 3 Likes
  • 1 Replies

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

Instructure Alumni Data and Analytics Group
  • 10 Likes
  • 1 Replies

Data and Analytics Blog

Read the latest updates for Data and Analytics products from the Product Blog.

Data Access Platform CLI & Client Library is now GA

(Instructure)
The Product Blog

Canvas Data

Canvas LMS

Developers

  • 5 Likes
  • 29 Replies

The Data & Insights team is continuing to look at how we can improve the experience when using the Data Access Platform (DAP) Query API directly and we'd like to get your input.

(Instructure)
The Product Blog

Canvas Data

  • 3 Likes
  • 10 Replies

As the end of 2023 is approaching, we offer you a brief retrospective of what’s new with Canvas Data, an important reminder about migrating data to Canvas Data 2 as Canvas Data 1 reaches end-of-life this year, and references to useful resources for c...

(Instructure)
The Product Blog

Canvas Data

Canvas LMS

  • 3 Likes
  • 12 Replies

In the November 8th Canvas deploy, Admin Analytics will release a new navigation.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 5 Likes
  • 5 Replies

Great news for Catalog users (and future Catalog users) : I am happy to announce that as per our commitments, Catalog data is available, labeled as BETA, via the CD2 API and CLI. Isn’t it great? 珞

(Instructure Alumni)
The Product Blog

Canvas Catalog

Canvas Data

  • 2 Likes
  • 0 Replies

TLDR: The Admin Analytics and New Analytics feature options will default ON in the December 16 Canvas release.

(Instructure)
The Product Blog

Admin Analytics

Canvas LMS

  • 3 Likes
  • 4 Replies

As we are approaching our next significant release, Canvas Data 2 will include weblogs (currently requests table in CD1). Important note:  the target release date has changed from 21 June to 5 July and the deploy notes were updated accordingly. Here ...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 4 Likes
  • 16 Replies

I’m excited to let you know that we’re planning to release filter updates to Admin Analytics in the July 5th Canvas deploy and changes to the Overview dashboard in the June 21st Canvas deploy. 

(Instructure)
The Product Blog
Comments closed

Admin Analytics

Canvas LMS

  • 2 Likes
  • 4 Replies

We've appreciated all the great feedback on Canvas Data 2 since we released it in March. Today we are going to share some updates on planned features as well as guidance related to timelines and migration.

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 6 Likes
  • 21 Replies

Admin Analytics will be available as a Feature Option with the March 29th Canvas deploy.

(Instructure)
The Product Blog
Comments closed

Admin Analytics

Canvas LMS

  • 11 Likes
  • 18 Replies

The day is fast approaching when customers can opt in to Canvas Data 2.  It’s been a major development effort and finally, the big day is the 18th of March. YEEEY. 拾 Read on to learn more about this exciting news and what it means for your institutio...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 5 Likes
  • 1 Replies

We are very excited to share that Canvas Data 2 has evolved from infancy into adolescence. We started last year in June with inputs and feedback from 13 Alpha customers from two regions and have grown to over 100 Beta customers around the world. The ...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 9 Likes
  • 12 Replies

It is time to share progress on the Canvas Data 2 product development.

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

  • 11 Likes
  • 13 Replies

First, a big THANK YOU to all who have completed the CD2 survey. I was really excited to see how this number has been growing day by day, a number that shows a great interest in what we are building. The amount of responses will guide us in the produ...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 6 Likes
  • 19 Replies

As promised, in this blog post I will share some further news on our progress with Canvas Data 2. In my previous post I mentioned why we needed to re-architecture our data pipeline and what things we are working on. This time, I would like to give yo...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 10 Likes
  • 9 Replies

Let’s just start in medias res because I am pretty sure that most of you are curious about not just the state of the Canvas Data 2 but also about what comes next (and why it didn’t come yet). The questions I expect you might be wondering about are:  ...

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

  • 11 Likes
  • 14 Replies

When I think about education and what it means to me, one word irrevocably comes to my mind which is “Ikigai”—the Japanese word referring to something that gives a person a sense of purpose. Let's talk about Ikigal in your world and mine.

(Instructure Alumni)
The Product Blog
Comments closed

Canvas Data

Canvas LMS

General Education

  • 4 Likes
  • 0 Replies

Hi, @dlyons! I am the account admin for our district. We monitor the use of accommodations for our students and would like to pull usage data for the use of the Microsoft Immersive Reader tool in Canvas. Normally, students use other add-on tools that...

(Community Participant)
The Product Blog

Canvas

Canvas Data

Canvas Partners

  • 0 Likes
  • 0 Replies