About

phil_mcgachey
Philip McGachey
Rank:
Community Novice
Title:
Joined:
Jul 10, 2015 5:59:12 AM
Posts:
11
Solutions:
0
Likes Received:
31
Bio:
An amazing Instructure Community member

Most Liked Posts

Hi, RubyThis isn't an answer to Marlee's original question, but it's possible that the solution that we've started looking into at Harvard might be along the lines of what you're asking. Our first pas...
Likes: 8
We're pulling the flat files from the Canvas Data API to load into our own AWS data warehouse, ultimately ending up in Redshift. We're a little behind, and have just hit the first dump that uses versi...
Likes: 4
Hi, ZacThanks for the response. You're right - I'd been looking at the number in the database and assuming it was a bigint - it turns out that my code was smarter than I was, and was treating it as a ...
Likes: 3
Hi, JamesThanks for flagging the update - I'd missed it in the release notes. Pulling data into our pipeline from the API's quite a bit slower than using the data files, but having the field available...
Likes: 3
We use a number of third-party and in-house LTI tools to provide specialized functionality within Canvas. Some of these tools collect analytic data that we'd like to correlate to our Canvas (and other...
Likes: 3

Most Recent Posts

Hi, JamesThanks for flagging the update - I'd missed it in the release notes. Pulling data into our pipeline from the API's quite a bit slower than using the data files, but having the field available...
Feb 7, 2017 4:06:42 AM
Hi, ChrisThat's right - thanks.Phil
Nov 18, 2016 5:02:36 PM
Hi, thereOver the weekend, our verification process started failing on the submission_dim table - there are a number of rows where the submission_type is set to 'basic_lti_launch', which isn't one of <!-- --><!-- -->...
Sep 26, 2016 10:11:23 AM
We use a number of third-party and in-house LTI tools to provide specialized functionality within Canvas. Some of these tools collect analytic data that we'd like to correlate to our Canvas (and other...
Sep 12, 2016 10:49:38 AM
Hi, allWe have an automated system that downloads and verifies the Canvas Data files using the API before feeding the data into our ETL and processing pipeline. Part of this verification involves chec...
Jun 29, 2016 6:24:47 AM

Latest Badges

25 Likes Received

25 Likes Received

Earned: 2024-01-05

First Like Received

First Like Received

Earned: 2024-01-05

Instructure Community: 8 Year

Instructure Community: 8 Year

8 Years with Instructure Community

Earned: 2024-01-03

Instructure Community: 7 Year

Instructure Community: 7 Year

7 Years with Instructure Community

Earned: 2024-01-03