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 version 1.6.0 of the schema, which changes the type of the id field in requests to a guid. Right now we're storing the id field as a BigInt in Redshift, but I wanted to make sure that we don't lose precision in case the GUIDs in the data set are wider than 8 bytes. What Redshift type are you using to store the ID?
Solved! Go to Solution.