Redshift data type for GUID field in requests table.

Jump to solution
phil_mcgachey
Community Novice

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?

Thanks

Phil McGachey

1 Solution
lfeng
Instructure Alumni
Instructure Alumni

Hi Phil - we are using varchar (50) for that field in Redshift.    Thanks, Linda

View solution in original post