Currently looking at canvas.courses table. I want to link all the courses / modules to their respective main Programs so that different programs can be analysed separately. For instance - a computer science Y1 main program could have 6 modules/course...

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

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

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

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

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?

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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