Data and Analytics Group Discussions

Data and Analytics Group questions and discussion forum

My script to pull incremental data from tables errored out early this morning and is still unable to run now, I am getting the following error: Received error in response: invalid_clientTraceback (most recent call last):File "/scriptpath/canvas_updat...

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

Hi,  Does anyone know a way to find student IDs or user emails from CD2? I have checked users and accounts tables in the canvas namespace - but they don't have "email" column. I only have the primary key of userID and accountID and only their full na...

  • 0 Likes
  • 8 Replies

With CD1 I used to be able to get a list of all the items in the navigation bar for a course. In the CD2 documentation it says that I should be able to find this information in the Courses table... tab_configuration (Annotated[bounded_str, JsonStrin...

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

We're doing some reporting on student progress in modules, and the data we see in context_module_progressions doesn't entirely match our expectations. Sometimes a student enrolled in the course doesn't have a record in context_module_progressions.  W...

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

The Unizin Faculty Development subcommittee is thrilled to announce the launch of the Stepping Stones Community, a public Google Group. This community will serve as a hub for our HigherEd peers worldwide to connect, collaborate, and share resources r...

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

When I use new analytics, go to run a report for missing work, is there a wat to set a date range? I know I can pull the data in to excel and sort, but is there a way to do this within Canvas?

  • 0 Likes
  • 1 Replies

We've been using the Data Access Platform for a couple of weeks now to manage our Canvas data in our own data warehouse and overall have been having a great experience with the tool! However, we've found that the submission_versions table doesn't exp...

  • 0 Likes
  • 1 Replies

Hi, We are looking at utilizing our Redshift data but we lost our SMEs that knew more about it.  We were wondering if there's a school that would be willing to talk to us about your setup experience, usage, and how things are currently going.  We're ...

  • 0 Likes
  • 1 Replies

Aside from the Account Admin permission "Users - act as" is there any other admin permission that controls/grants access to an account admin to view conversations in the Inbox between teachers and students? In other words, if "Users - act as" is not ...

  • 0 Likes
  • 1 Replies

Happened to go into https://identity.instructure.com/ and noticed that new keys can go for THREE YEARS!   Yay!

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

The discussion_topics__discussion_type enumeration does not include the "not_threaded" value added as part of the Discussion Redesign feature. I believe the discussions with this value are currently showing as '__dap_unspecified__', and I would like ...

  • 3 Likes
  • 2 Replies

I've used Postman and am able to get data from Canvas Data Portal 2.  I'm trying to do the same thing in Python.  I'm able to get all the preliminary steps (GetJWT, Dispatch query, get status of query) in python, but get a bad request format when try...

  • 0 Likes
  • 5 Replies

Hi Team,I am developer working at Fivetran.I am currently working on pulling data from Canvas using the API and have encountered some issues. According to the Canvas Data 2 API documentation, I need to specify a date from which to pull the data. Howe...

  • 0 Likes
  • 2 Replies

As far as I can tell there currently isnt a way to get the account settings using Canvas Data 2 but I would love to be corrected.I can see that the genuine Canvas backend has a feature_flag table for this as well as a settings column in the accounts ...

  • 7 Likes
  • 6 Replies

We are looking for a way to create a report showing all the settings selected for quizzes and assignments in a spreadsheet. We are finding that when we create multiple quizzes or assignments, we sometimes miss enabling certain settings every time (i....

  • 0 Likes
  • 4 Replies

I'm trying to see if students bother to look at the responses I give on the discussion board after their participation deadline.  As a result, I've exported the course activity via 'New Analytics'.  In the "Content Type" column of the csv file I down...

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

Problem I've noticed there are entries in most course content items for a migration_id. My assumption was this was a way to join with the content_migrations table, but the id in that table doesn't match the format of the migration_id.  What I'm Tryin...

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

A disgruntled teacher when through and deleted a bunch of stuff from a bunch of courses. I need to be able to answer this question, and seemingly cannot due to inadequate Canvas logging.    "What did a faculty person delete, from where, and when"? If...

  • 1 Likes
  • 2 Replies

I wasn't sure if this is the best place to post this, but didn't find a group specifically for CD2 questions in the options and wasn't successful in finding any previous thread on this specific topic.We are pulling our data using CD2, but have not be...

  • 0 Likes
  • 4 Replies

I am at an institution that uses Canvas LMS, but I came from one that used a version of Desire2Learn/Brightspace.  While I like a lot about what Canvas offers, I find myself missing a really valuable feature for course design and student engagement e...

  • 1 Likes
  • 2 Replies

I am trying to populate a database with ALL the tables in the Canvas namespace. I am following the instructions on this documentation to initialize my database using the initdb command. Below is my CLI:   dap initdb --connection-string my_connection_...

  • 0 Likes
  • 4 Replies

I'm seeing a lot of students that do not have a value within the Enrollments table in their "last_activity_at" attribute.  I resync'd my data this morning into Postgres and found a case where a student showed no activity, but had completed several as...

  • 0 Likes
  • 1 Replies

Why does listing tables from canvas_logs namespace still return the user_agents table? I thought this table was deprecated/sunset? Is there a plan to stop listing it? This dap command returns the following: dap --base-url $DAP_API_URL --client-id $DA...

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

Hello,  I am looking at the New Analytics for my course and it is showing zero participations, but I know students have submitted quizzes. This is listed as what counts as a participation so why is it not generating numbers on the graph (image attach...

  • 0 Likes
  • 1 Replies

Tagging @sgergely since this is mostly a question for him, but I suspect it'll be of interest to folks like @ColinMurtaugh and likely others. For a few years, we've been using a mixture of CD1 requests and Canvas Live Events. They both have their pro...

  • 2 Likes
  • 12 Replies

Hi all,I am getting this error SELECT cls.relnameFROM pg_catalog.pg_class AS cls INNER JOIN pg_catalog.pg_namespace AS nsp ON cls.relnamespace = nsp.oidWHERE nsp.nspname = 'instructure_dap' AND (cls.relkind = 'c');when syncing the table with dap 1.1....

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

Got my hands on the LTI tables in CD2 now, trying to query if I can list all LTI 1.1 and 1.3 related to a specific course. Context_External_Tools (LTI 1 and 1.3) - has two kinds of tools (context_type) - Account, Course if context_type: course, then ...

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

The CD1 Requests table included a significant disclaimer: "The data in the requests table is a 'best effort' attempt, and is not guaranteed to be complete or wholly accurate. This data is meant to be used for rollups and analysis in the aggregate, _n...

  • 2 Likes
  • 3 Replies

Mostly a question for @ sgergely and @GergelyTar - I was just wondering if there's anything on the DAP client roadmap for syncing to an S3 location and/or using Iceberg? We're going w/ PostgreSQL for convenience in making our transition from CD1 to...

  • 0 Likes
  • 6 Replies

Hello, I'm using Python to automatically sync our CANVAS data into our database. However, I'd prefer to not have the results of each table's syncing printed out (e.g. "No rows to upsert", "No rows to delete"). Is there a way to add a line (or so) to ...

  • 0 Likes
  • 1 Replies