I've been trying to find a way to decode a base64 column in a bigquery table to a GUID/UUID. Does anyone know of a function in SQL that I can do this with or would I have to use a different language than SQL.
Asked
Active
Viewed 1,006 times
0
-
do you have any sample data to verify? – Felipe Hoffa Oct 15 '19 at 23:22
1 Answers
1
If understand correctly, SELECT FROM_BASE64(guid_column) AS id should do it for you.
khan
- 7,005
- 15
- 48
- 70