Yesterday I was looking at the number of published courses for our Summer 1 term. When I looked at yesterday's course_dim workflow_status, it showed X number of courses as Active -- assuming that is the indicator that a course is published. However, ...

I was recently tasked by the college leadership to figure out a way to get more data out of Canvas. How hard could that be right? After poking at the request for a few weeks like it was a dead rat, I decided to give Canvas Data a try. The result was ...

We're finally getting back to setting up CD2. A year ago, when we tested it, we were using data-access-platform-cli 3.0.0.That version is no longer available on npm; most recent is v 3.1.4.However, when we try to use the dap command, we're getting an...

Our institution is looking for a way to pull a list of all quiz accommodations (New Quizzes) that have been added to students in all courses in the current term, for auditing purposes. Our CSM has recommended we sign up for Managed Teaching & Learnin...

I am trying to identify daily request data before I load the files into database or S3 bucket.  I only need data from Aug 2021 to Mar 2022.  I am using get_sync_file_urls to get all the URLs for the request data.  What I noticed is URL has "daily dat...

While I'm no programmer, I am trying my hardest to understand API calls and running scripts. I know of this API call: GET: /v1/external_tools/visible_course_nav_tools Can this API, combined with some scripting, allow me to identify whether or not a s...

Hi Canvas Community! I used canvas for almost 5 years and now i'm backing to it as a freelancer working with reports (Canvas Data, Pbi). One of the requests i have is to help the institution to know about failed loging attempts. With that, they can r...

I a setting up a query to check for users that need to be removed from our system. We allocated two fields that would be helpful user_email and created_by_sis. However, I can not find them in canvas data tables. Can anyone help?

Hi- I keep getting this error. Any ideas?   canvasDataCli sync -c config.js fetching current list of files from API... no files exist for account, cannot sync an error occured [ApiError] {   errorCode: 404,

Hello everyone, At our institute, we still have to start with the use of Canvas Data and we are orienting ourselves on different aspects of Canvas Data. Should we self-host or use Amazon Redshift, which analytical tools should we use how, can we use ...

I'm trying to retrieve all of the tables at dates in the past to get a consistent picture for that date.   So I ran a list command to identify the datadump id and then ran a grab for selected data dumps.  What I'm finding is that very old data dumps ...

Hi, would anybody have a Google Data Studio Dashboard template for Canvas courses they like to share? I am new to Google DS and ran into some issues displaying data correctly. If I could look at a dashboard template I might find some solutions.  Many...

In case you missed the Instructurecon Canvas Data 2 presentation:    https://vimeo.com/625100989 What to expect

The same question was asked three years ago but I can't find a good answer. I can't retrieve  grading_period_fact, grading_period_score_fact, grading_period_dim,  grading_period_group_dim, grading_period_score_dim tables from Canvas using API call. I...

hi, all Washington State University has recently moved to Canvas and we are pilot testing an early academic warning system in some of our 100-level courses.  We’re looking for a consistent and scalable way to pull scores on a set of early assignments...

Hello All,   I am new to being a Canvas Admin so if this sounds dumb it might be.   We are trying to find a way to make a custom report due to large groups of students being on quarantine, we would like to create a group with those students and see ...

I've started a Git Repo dedicated to Canvas Data Queries: reynlds-illinois/canvas_data_queries: Canvas Data queries through Athena on AWS. (github.com) Over the next few days I'll be uploading everything I've written so far. I'm also going to be coll...

Hi Friends and Community !   I'm a data engineer from ACUE, please excuse me if this has been asked and updated already, but I wonder what is the latest status on Canvas Data 2 ? Is it already production ready ? I read through all the links I can fin...

Sharing some findings from testing we did exploring this question. Problem/Question One of the schools we work with wanted to create a visual showing discussion activity with details about who originally created the topic or thread.  They discovered ...

Hello, I am new to the Data Services work.  We have been on Canvas for about a year and half. I am trying to gather some information for the dean's office. We create a TA role for some of our full-time faculty that is used to observe the adjuncts' cl...

I'm relying on Canvas Data API (actually using this Python wrapper) to extract data for institutional research. The FAQ in this forum says "due to the nature and potential size of the requests table, we only provide the previous day's data." Does it ...

I can now retrieve data from Canvas Data 2. My DAP version is 1.0.18.  Since it is so different from canvasdatacli, I was curious if anyone was working on processes to retrieve data and load it into AWS S3.

I have a case open - but I was curious if pseudonym_dim and pseudonym_fact disappeared from canvas data I  in any other schools.   I noticed it on 6/24/2021.

I was trying to create some analytics around quiz submissions across multiple courses, but I noted that quiz_submission_dim and _fact don't match. Delving deeper I find that submissions to quizzes that are not graded assignments are only included in ...