CD2 assignments data changed/updated?

Question

In our CD2 Assignments table, we're noticing a weird discrepancy:

- ran a query in 2/2025 and saw 50 assignments in one class from 2018

- ran the query in 2/2026 and there were fewer (only 40 assignments)

We looked at the Assignments table, specifically at the ts field. On 10/1/25, 100% of the records in that table (6.5 million) had a ts = '2025-10-01'. It's like the entire table was refreshed/updated. We have assignments going back to 2018 so there's no reason the ts field should be updated. This is happening with a number of assignments (2,000 assignments in a sample of 10,000), so it's not isolated.

Any ideas why all of the CD2 Assignments records would have been updated on 10/1/25?

Mike Sharkey

Arizona State University

MikeSharkey04157880 · Answer

the "ts" timestamp field is the one that looks off. Not sure why that updated in 2025 for assignments from 2018

Jeff_F · Answer

@MikeSharkey04157880 - which datetime field from the assignments table are you referring to? Created at, updated at, etc.

canvas | Instructure Developer Documentation Portal

With that info I can look at our RedShift and try to replicate.