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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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