AnsweredAssumed Answered

Redshift data type for GUID field in requests table.

Question asked by Philip McGachey on Mar 4, 2016
Latest reply on Jun 28, 2017 by Colin Murtaugh

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

Outcomes