Data and Analytics Discussions

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

I've been asked to see if I can report on student attendance from within the data I'm getting from the CD2 downloads. I'm not finding much, probably because no one has been able to show me how they ta...

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

Has anyone run into any issues running Data 1 and Data 2 APIs on the same server? We use the CLI tool to pull tables from Data 1 nightly. We want to begin testing the process using Data 2 but want to ...

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

The following tables are what are institution uses for Canvas Data 1. I am a business analyst trying to research the difference between these tables with Canvas Data 1 versus 2. My question is, will t...

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

Has anyone noticed increasing failure rates with canvas_logs recently? I know there was an outage on Saturday, but we've been having intermittent issues since then and are wondering if we are the only...

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

Hello, I'm a little confused with the values in context_external_tools: workflow_state. In CD1 external_tool_activation_dim: workflow_state and the external_tool_activation_dim: privacy_level are 2 se...

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

Attaching the full trace error as a file, but including the top part here. I recognize that this might be something internal, but https://github.com/MagicStack/asyncpg/issues/309 indicates perhaps not...

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

What does the EOL for Canvas Data 1 on December 31, 2023 mean? Will it "go away"? Will the systems we've invested hundreds of hours of development time stop working? Any documentation on the EOL plan ...

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

Hi, We are using dap version 0.3.10.  Our goal is to download the Canvas Data 2 tables as parquet files.  As we are not maintaining a database, we can't leverage the `initdb` and `syncdb` features of ...

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

Hi, We are using dap version 0.3.10.  Our goal is to download the Canvas Data 2 tables as parquet files.  As we are not maintaining a database, we can't leverage the `initdb` and `syncdb` features of ...

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

Hi @Edina_Tipter and @LeventeHunyadi When accessing parquet datasets for submissions & late_policies there seems to be inconsistencies with interpretation from downstream processing jobs for schema on...

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

Hello Instructure! The recent release notes indicate CD1 is set for end of life on Dec 31. As I've been informed that our project to transition from CD1 to CD2 will take until June 2024 I need to ask ...

Community Champion Data and Analytics Group
CD1
  • 6 Likes
  • 1 Replies

Starting on Friday, 9/15/2023, I encountered the following error: aiohttp.client_exceptions.ClientConnectorError: Cannot connect to host api-gateway.instructure.com:443 ssl:default [Connection reset b...

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

I love the missing assignment report in new analytics but I am wondering if there is a way to get that report for every course at 1 time. I am in charge of academic intervention and if I could get all...

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

I've noticed that most of our table retrievals have been failing in the past hour (using CD2 REST api to retrieve tables. We've been getting 503 responses for most tables ('service unavailable'). Are ...

Community Contributor Data and Analytics Group
  • 6 Likes
  • 3 Replies

@Edina_Tipter and @LeventeHunyadi Since there is no Git issue tracking for this project, I will post my issue here. Would it be possible to expose the "retry-after" value by possibly throwing an error...

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

@Edina_Tipter and @LeventeHunyadi Since there is no Git issue tracking for this project, I will post my issue here. Below are description of the errors when running the `initdb` command using a MySQL ...

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

I've been working toward "validating" my query results from our Canvas Data 2 instance as compared to Admin Analytics and CD1. Looking at the current term (Fall, 2023), the AA enrollment numbers are: ...

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

Hello - does anyone have experience using the tab configuration field in the courses table? The CD1 position and visible fields didn't carry over to CD2. Instead, they are "derived from courses.tab_co...

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

There seems to be a few questions here about the definitions for what workflow_states for different contexts actually mean. I get this question a bit when providing data to people and it can be hard t...

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

I created a shell script that uses the DAP client to run the CD2 sync commands. The script works fine when run manually, but when I try to schedule it with CRON it fails with the stacktrace below. DAP...

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

I'm trying to explain to some internal folk the difference between the Assignments and Quizzes. I "think": there are four types of classic quizzes (graded quiz, practice quiz, graded survey, ungraded ...

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

I can init and sync all the tables except Submissions. It has changed lately, and seems to get farther. I get no error messages, it just stops after downloading 5/11 (is that 5 of 11 objects?). It doe...

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

I'm trying to query the Hosted Data Management backend to understand how much "completion" of module items varies based on the requirement type set for the module item. For example, when the requireme...

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

Hi, Instructure team,Recently, we are doing a detailed comparison between Canvas Data 1 and Canvas Data 2 exported via the CLI tool by comparing data schemas, table relationships, and the information ...

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

In the New Analytics/Weekly Online Activity, under Resources several course individuals are listed. How can a course participant be listed as a Resource? This seems very odd to me. Thanks for any inpu...

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

We use a blueprint course as the basis of all our credit-bearing courses each term. It includes a module with general college information, help resources, etc. How would I go about tracking how much i...

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

Full transparency, I am a SQL DBA.  My predecessor has created a Python script with an embedded SQL script to extract data from numerous tables and saved the data to a CSV file.  This is being done we...

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

Hiya, I was just trying to see what people had set as the copyright holder on the files uploaded to our Canvas instance. Looking at the list of CD2 tables I could see a table for folders:  https://dat...

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

The documentation contains details about Filter Identifies a subset of data to fetch from a table. (This feature is not currently implemented.)   When is this going to be made available?  This fea...

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

Howdy, A little while ago I asked how to determine the date a student first accesses a course without the use of Canvas Data. I got the exact info I needed - using New Analytics - Course Activity Repo...

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

Data and Analytics Blog

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

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

  • 0 Likes
  • 2 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...

  • 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
  • 3 Likes
  • 0 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 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.

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? 珞 T...

(Instructure)
The Product Blog
  • 1 Likes
  • 0 Replies

Exciting times in analytics at Canvas! At the end of 2023, we’re going to default the Admin Analytics and New Analytics (which are course-level analytics) feature options to ON for all customers.    ...

(Instructure)
The Product Blog
  • 2 Likes
  • 0 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 a...

(Instructure)
The Product Blog
  • 4 Likes
  • 16 Replies

Filter Updates in the July 5th Canvas Deploy (Updated Date) Many of you have told us that you need more from your Admin Analytics filters because when you’re reviewing your data, filtering by account...

(Instructure)
The Product Blog
  • 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 migr...

(Instructure)
The Product Blog
  • 6 Likes
  • 15 Replies

You asked. We answered! I’m thrilled to let you know that Admin Analytics will be available as a Feature Option with the March 29th Canvas deploy. What Admin Analytics is a new, in-app analytics spac...

(Instructure)
The Product Blog
  • 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 ...

(Instructure)
The Product Blog
  • 5 Likes
  • 0 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 grow...

(Instructure)
The Product Blog
  • 9 Likes
  • 12 Replies

  It is time to share progress on the Canvas Data 2 product development. First and foremost, I am happy to announce that we have achieved an important milestone -  the first version of the Canvas Dat...

(Instructure)
The Product Blog
  • 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. ...

(Instructure)
The Product Blog
  • 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 ...

(Instructure)
The Product Blog
  • 9 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 ques...

(Instructure)
The Product Blog
  • 10 Likes
  • 8 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. I think t...

(Instructure)
The Product Blog
  • 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 Canv...

(Community Participant)
The Product Blog
  • 0 Likes
  • 0 Replies