The most recent content from our members.
I am trying to migrate a cd2 / dap web_logs database from my local machine to a google cloud virtual machine. I created a postgres dump of the local database, uploaded it to the cloud, and used postgres restore. Now I am trying to syncdb and get the following error. ✗ ERROR: Operation syncdb failed. Reason: Table not…
Our organization has been asked to provide data and reporting on student activity in Canvas, essentially the number of times a student has accessed courses and resources. The activity is stored in the "web_logs" table which records granular actions, similar to api calls and http requests. There is an abundance of noise in…
Hi all, We have a small number of records for the CD2 web_logs table where the course_id column is populated by what looks like the shard id (flashbacks to CD1) and not the course id. (I don't mean the shard_id + course_id, but just the four digit shard_id.) I'm just curious if anyone else has seen this and has any insight…
Hi everyone, I’m looking for ways to evaluate and improve student retention at our university, and I’m particularly interested in leveraging data from Canvas Data 2 as well as other sources to identify and support struggling students. At the moment, I’m exploring the best ways to analyze and apply data effectively to flag…
Hi everyone, does anyone have any experience or lessons learned in regards to processing the CD2 web_logs table in AWS (Glue / Athena / etc)? We don't have any immediate specific use cases, but we know that researchers will want to query data eventually. So one option would be to just download the data as parquet files…
Hi all, According the datasets from CD2, https://data-access-platform-api.s3.eu-central-1.amazonaws.com/tables/catalog.html#schemas.canvas_logs.web_logs. It states that web_logs defines as follow: Stores the Canvas web application server access/request logs. Logs include all interactions made with your instance of Canvas,…
Hi all, My institution starts to use Canvas since 2014, and now we focus on CD2 web_logs. As I know that the DAP API can only retrieve the latest 30 days data. May I ask is it possible way to get back the web_logs data from 2014? If no, is there any charged service can do that? Many thanks
Hi all, I refer the section 'Getting latest changes with an incremental query' from the link https://data-access-platform-api.s3.amazonaws.com/client/README.html#command-line-usage and program the code to retrieve the web_logs with datetime range.…
Good morning, we were looking at Canvas Data 2, and at the data available to us. We do not have access to web_logs. We have found out that we do not have web_logs because we subscribed to the service: Managed Teaching and Learning. We found that to have access to web_logs, we would need to switch to Managed Canvas Data…
Hi support, I try to initial the database of web_logs table with API 'initdb'. dap initdb --connection-string postgresql://scott:password@localhost/testdb --namespace canvas_logs --table web_logs The connection error prompts up and the process has been stopped.…
Sign in to enhance your access to articles, forums, and events—and to participate by sharing insights, engaging in discussions, and connecting with your network of edtech peers.