Redshift data type for GUID field in requests table.

Jump to solution
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?


Phil McGachey

1 Solution
Community Novice

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

View solution in original post