Good morning folks!After updating to the new stable release of the DAP CLI tool, I was able to smooth out some existing issues which some of you have already experienced:TCI_KEEPIDLE issue was an OS/Python issue "Please use initdb" when trying to use...

I'm trying to extract all clicks to a specific URL from web logs, with user ID-level detail. However, when filtering the logs to that URL, I noticed some users have multiple records (5-10) with timestamps only a few seconds apart. This suggests repea...

Hi - I'm using DAPClient 1,1 and postgres 16 With an incremental query I've discovered we seem to have started losing pseudonym "id"'s. e.g. users.id 2720 has pseudonym.id 2689, but in the pseudonymn table 2689 has been skipped, so has 2693. Confirme...

Hi,    Does anyone have any idea how to track the usage of SCORM packages across the entire instance. I need the number of packages deployed and the number of courses that have at least one package deployed

To follow standard best practices in online courses, we require our facilitators to send welcome messages (sometimes more than one) to participants before the course is published.  The roster in grades and people shows student logins or SIS ID's (whi...

On several table downloads using initdb I'm getting dozens of the error below. This has only been on a few tables so far. I have tried dropping the table and re-running, that worked once but not on the conversation_messages table.  We're using Python...

It would be immensely helpful if the Canvas Sys Admin (or course teacher if that was possible) was able to see the progress New Analytics was making.  If it goes over 24 hours, usually teachers will contact support thinking something is wrong, and th...

Confession: I am not a developer or an SQL expert, but I can view certain kinds of code, sort of learn it, and make adjustments as needed. Otherwise, I rely heavily on ChatGPT, particularly when it comes to SQL.  That said, I was wondering if someon...

When we are running our DAP synchronizer python script, we are running into issues going back to Feb 27. This was the last time it ran successfully and we noticed it 2 days ago. When diving into the issue we are finding that several tables now are tr...

I am getting a 403 error on the job endpoint specifically. Please see the message below ********************** Got response: HTTP/1.1 403 Forbidden [Server: CloudFront, Date: Fri, 22 Mar 2024 13:53:34 GMT, Content-Type: text/html, Content-Length: 915...

I believe that I have followed the install directions for placing the Canvas Data 2 Command Line tool on my machine. I've created my Canvas Data 2 API key.I thought I would try out the simple command below, which is supposed to return a list of table...

We devised a simple workaround to utilize dap 0.3.18 to load our production MySQL 5.7.15 tables. All of our CD2 SQL queries have been tested and deployed into production using the non-prefixed table names, e.g. assignments rather than canvas__assignm...

Hi , In the CD1 to CD2 schema mapping document below,[PUBLIC]: CD1 to CD2 schema mapping - Google Sheetsenrollment_dim&fact sheet user_id field is obfuscated using the command "obfuscate_global(cast(enr.user_id AS bigint), g_shard_id)".  But it's com...

Can somebody please answer this question for me.  I am experiencing very confusing anomalies between data obtained via API calls and corresponding data obtained via the New Analytics UI.Specifically, I ran the following API call to extract details of...

I was working on switching over a process I had previously been using CD1 Requests for to show the break down of the types of Operating Systems and Browsers are used by our faculty and students. When I was comparing the data I noticed there was subst...

Howdy, I am trying to gather information on the number of assessment submissions are being marked by each of our marking staff. I use CD2 CLI to download CD2 tables. I then import into a database and then run SQL queries on the data. In the submissio...

I am able to call the schema endpoint, but I am getting a 404 error on the data endpoint 'https://api-gateway.instructure.com/dap/query/canvas/table/' + $splitValue + '/data' The error is: Failure: Failed to execute the request, or the endpoint respo...

Hello,   I am trying to use DAPSession.stream_resource to stream resources/files directly into an S3 bucket. The idea is to pipe the stream directly into S3 without downloading and storing the entire file locally first, and then reuploading it into S...

Hi all,We'd like to sync Canvas Data2 to our data warehouse, which is on Snowflake. Snowflake uses its own SQL dialect.The DAP Client documentation states that it only supports Postgres and MySQL. Prior to the release of v1.0.0, there were instructio...

Hi everyone! I created a GUI client for Canvas Data 2 to do snapshot or incremental pulls.  So I wanted to share my Github repository for it.    https://github.com/coldplazma/Canvas-Data2-client/tree/main