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

I used the initdb command to create a table. The table is created successfully with some data. Then when I try to use the syncdb command the following error appears:INFO:pysqlsync.postgres:PostgreSQL version 16.0.2 final2024-03-06 15:48:52,993 - ERRO...

Hi all,  Is it possible to extract a user Feature Usage data, PageView Data and Device Usage/used from Canvas Data 2? I'm fairly new to data analytics and have been scouring the tables from CD2 but unfortunatly thus far I've not really found and tabl...

Hi Everyone,Our organisation recently got access to Canvas Data 2 and I have been comparing data pulled from CD2 to Canvas' internal reports and have noticed some large discrepancies.For example when looking at the enrollments table from CD2, I get a...

What are the new capabilities that came with the transition to Canvas Data 2? What new reports or benefits have been realized?  For example:  late_policies: We can now see if assignments have a missing submission policy set and how many points are de...

Hi all! We use new analytics for online attendance. It seems it isn't capturing records for several students across multiple grade levels and classes. It is turned on in all courses, everything seems to look good on our end. Any thoughts on what is h...

So, not super familiar with Azure but we've managed to set up a pipeline (but getting occasional fails) and debating finisihing incremental approach. I do ultimately want to get this into a postgres db. At the moment I get far more reliable data usin...

Hi, I've just updated to the latest v1.0.0 version of the dap-client plus updated the cryptography to v42.0.5 & even when I now attempt to run just 'dap --version' I get the aforementioned DLL load error. Anyone else experiencing this? Anyone resolve...

When using CD2, is there a way to retrieve the total rows in a specific CD2 table? I am using CD2 to load data in a visualization tool. After pulling data using a full snapshot, i periodically pull incremental snapshot for changes I also collect qual...