20 October 2018 · victor ·       Add to Favorites   Report

Generate a Unique value UUIDs in Google BigQuery

UUID stands for a universally unique identifier (UUID)

GENERATE_UUID() Returns a random universally unique identifier as a STRING. The returned STRING consists of 32 hexadecimal digits in five groups separated by hyphens in the form 8-4-4-4-12. The hexadecimal digits represent 122 random bits and 6 fixed bits, in compliance with RFC 4122 section 4.4. The returned STRING is lowercase.

SELECT GENERATE_UUID() AS uuid;

The above query generates a result like the following:

+--------------------------------------+
| uuid |
+--------------------------------------+
| 4192bff0-e1e0-43ce-a4db-912808c32493 |
+--------------------------------------+

victor

posted on 20 October 2018

Read great educational content like this and a lot more !

Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too

Copied