We are in relatively good shape with our CD2 processes, though we have yet to go a full week without some kind of error, usually caused by the authentication token timing out (which leads to a 401 err...

Yes, our jobs failed 10/21 and 10/22. Just spot-checking, it does look like the failures are when checking the status endpoint (500 Server Error: Internal Server Error for url: https://api-gateway.ins...

Presentation TitleSurfing Learning Analytics on Canvas Without Wiping OutAbstract / Session OverviewIn this presentation, we’ll update you on year two of our Canvas Data journey. We’ll talk about read...

Thank you for the questions, @sgergely. 1. Our ETL process is based around Informatica, which is the tool of choice at our institution. We aren't using the DAP Client directly. We have one Inf...

Thanks for the question. @BobODell.  We have a daily set of daily jobs that grab data for each of the tables (including web_logs) and push it to S3. From there, we load into Redshift. For the most...

@akhelms Nice find on the pseudonyms change info. We were wondering about that ourselves. We pull daily data into a staging table before pushing it to the final table (this is a hack because Redsh...

@sgergely Can we assume that the analytics API that reports aggregate numbers (https://developerdocs.instructure.com/services/canvas/resources/analytics#method.analytics_api.student_in_course_part...

Thanks @stimme and @phanley -- that means the column is still informative even if blank. Good to know. 

Hi all -- The courses table in DAP has a tab_configuration column which holds a JSON array of various configurations for the course. We recently decided to try to take advantage of that information to...

Hi @KristineRoshau -- Are you saying that the data in your "web_application_action" column in the "web_logs" table are integers and not strings? Could that be a data processing err...