I was comparing submissions data and noticed a difference between the "graded_at" dates that were returned via Canvas Data in Redshift and the Submissions API. I suspect it is timezone-related since it matches some of the time but not all the time, but wanted to confirm what we are seeing and understand why.
I am looking at submissions_dim.graded_at and comparing to what gets returned via API /api/v1/courses/:course_id/students/submissions for graded_at value. e.g. for canvas course 618, assignment 4972, student 262554, Redshift returns 2/23/15 for graded_at while API returns 2/22/15. For canvas course 618, assignment 4889, student 262554, the dates match.
Please advise, thanks.