Discrepancy between Canvas Data 1 and Canvas Data 2

[JiaqiCheng]

Hi, Instructure team,

Recently, we are doing a detailed comparison between Canvas Data 1 and Canvas Data 2 exported via the CLI tool by comparing data schemas, table relationships, and the information shown in the tables.

But we have found some discrepancies between Canvas Data 1 and Canvas Data 2 by comparing them with the information shown on Canvas Web UI.

For example, when we check a specific assignment under a student in Canvas Data 1 and Canvas Data 2, all the learning outcomes have a score of "2" in Canvas Data 1 while there are only two learning outcomes with a score of "2.0".

But when we check this assignment of this student on Canvas Web UI, we found all the learning results have a score of "2" matching Canvas Data 1. 

Could you tell us what the issue is for causing the discrepancy and whether this issue is also reported by other customers?

Thanks.

[heyuan]

Hello, I wonder whether this post received any update from Canvas team?

We encountered the same issue where Canvas Data 2 are missing some records comparing to Canvas Data 1, especially in some of the larger tables like users, quiz submissions. We have tried to do snapshot loading several times thinking we might've missed something but that doesn't fix the differences.

Look forward to hearing an update on this! 

[reynlds]

I have my own issue with CD1/CD2 discrepancies being tracked here:  CD2 not in sync with Admin Analytics or CD1 number... - Instructure Community (canvaslms.com)

[JiaqiCheng]

Hi, I didn't receive any update from the Canvas team. Recently, I did a few rounds of tests again (in the past three days). I think Canvas Data 2 looks good now. You can give it a try. Please be aware that Canvas Data 2 has a smaller data latency compared to Canvas Data 1 (24 ~ 36 h).    Kind regards.