Search code examples
google-bigqueryuuid

generating primary key in bigquery


I would like to possibly use GENERATE_UUID() to create a primary key, but only against certain compound keys (columns) of the table, and not from the data of whole row, is that possible?


Solution

  • I think what I'll do is I'll break the key creation step into another process (view) & join the original back to the new view w/ the UUID'd data. Also, I'll use something like Farm fingerprint to create the uuid