Utility functions in GoogleSQL

GoogleSQL for Spanner supports the following utility functions.

Function list

NameSummary
GENERATE_UUID Produces a random universally unique identifier (UUID) as aSTRING value.

GENERATE_UUID

GENERATE_UUID()

Description

Returns a random universally unique identifier (UUID) as aSTRING.The returnedSTRING consists of 32 hexadecimaldigits in five groups separated by hyphens in the form 8-4-4-4-12. Thehexadecimal digits represent 122 random bits and 6 fixed bits, in compliancewithRFC 4122 section 4.4.The returnedSTRING is lowercase.

Return Data Type

STRING

Example

The following query generates a random UUID.

SELECTGENERATE_UUID()ASuuid;/*--------------------------------------+ | uuid                                 | +--------------------------------------+ | 4192bff0-e1e0-43ce-a4db-912808c32493 | +--------------------------------------*/

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2025-12-15 UTC.