I’ve always wondered about the lengths of the cookie ID fields/types in Redshift:
Given most cookie IDs are 36 character UUIDs, wouldn’t it be more efficient to use CHAR(36) on them? Querying our dataset, these fields all max out at 36 chars. I’m guessing they’re this long in case custom cookie IDs are passed, however I haven’t seen a reference for this in the trackers I’ve used.
Also, why is domain_sessionid set to char(128) while the rest are all varchars?