Adding to what Ed said above, a previous release provided a spreadsheet version of the schema.  This is critical to our development effort as it brings all the columns and tables into a single documen...

If the grading standard row is no longer "assigned" then it would seem logical to me that the Context_ID column would be set to NULL.  Except that it's a NOT NULL column, so it's left "hanging" there....

Enrollments are a free-for-all in our instance of Canvas.  I threw up my hands/keyboard and decided that going back to the SIS for the primary instructor was the path of least resistance.  We maintain...

sis_batches may be one of those tables that they include in the DDL script but is not available in the export.  That table is in the latest DDL script I'm using but I explicitly don't import any of th...

I didn't try the JSON version of the SQL script.  I used the PostgreSQL version.  I did not load the script directly into Oracle because the two database vendors structures are different (enumerated d...

Thanks for taking a look at your data.  It gives me confirmation that I may not be on the wrong track. At this time, I don't do anything through the API.  I work with just the CD2 data.

For the data warehouse, I was going to provide percentages (mean, min, max) for the assignments in addition to the points that are stored in Canvas.  But I can't do that for an assignment with zero po...

For assignments where the points_possible value is set to zero, I see that is a way to create an extra credit assignment.  Is there any other explanation for setting up an assignment that way? The rea...

Is this something that I should be opening a ticket for?

I'll state up front that I may not understand the purpose of the OVERRIDDEN columns found in the assignment_overrides table.  However, given the documentation associated with the columns, then one or ...