What is the max length of the data column of type "unique identifier"?
Kristin.R.531
Posts: 8 Analytics Builder Transition
in Development
In some of the data set ERDs, there are columns identified as "unique identifier" data type (i.e. Activity Feed Post Log > LogId). We are warehousing data from these sets. I can code this column as a varchar but how long do these strings get?
Tagged:
Best Answer
-
Hi Kristin, These identifiers are GUIDs that follow the 'standard' GUID format XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX and are 36 characters in length. Hope that helps!
Answers
-
Thanks, @Chris.S.534 ! I am assisting on a project outside my normal duties so I'm not familiar with 'standards' and couldn't find a data dictionary. :-)