UUID_STRING | Snowflake Documentation (original) (raw)

Generates either a version 4 (random) or version 5 (named) RFC 4122-compliant universally unique identifier (UUID) as a formatted string.

Syntax¶

UUID_STRING()

UUID_STRING( '' , '' )

Arguments¶

'_uuid_'

A valid UUID string. This value is the namespace used to generate the returned UUID.

'_name_'

The name used to generate the returned UUID.

Returns¶

This function returns a 128-bit value, formatted as a string (VARCHAR data type).

Usage notes¶

UUID_STRING supports generating two versions of UUIDs, both compliant with RFC 4122:

• A version 4 (random) UUID is returned when no arguments are provided to the function. For random-number generation, the 64-bit Mersenne twister known as MT19937-64 is used.
• A version 5 (named) UUID can be produced by providing a _uuid_ string (known as the namespace) as the first argument and a _name_ string as the second argument.

Examples¶

Generate a random UUID:

+--------------------------------------+

Generate a named UUID:

SELECT UUID_STRING('fe971b24-9572-4005-b22f-351e9c09274d','foo');

+-----------------------------------------------------------+

Create a table and insert random UUIDs:

CREATE OR REPLACE TABLE uuid_insert_test(random_uuid VARCHAR(36), test VARCHAR(10));

INSERT INTO uuid_insert_test (random_uuid, test) SELECT UUID_STRING(), 'test1'; INSERT INTO uuid_insert_test (random_uuid, test) SELECT UUID_STRING(), 'test2'; INSERT INTO uuid_insert_test (random_uuid, test) SELECT UUID_STRING(), 'test3'; INSERT INTO uuid_insert_test (random_uuid, test) SELECT UUID_STRING(), 'test4'; INSERT INTO uuid_insert_test (random_uuid, test) SELECT UUID_STRING(), 'test5';

SELECT * FROM uuid_insert_test;

+--------------------------------------+-------+ | RANDOM_UUID | TEST | |--------------------------------------+-------| | 7745a0cf-d136-406b-9289-38072d242871 | test1 | | 8c31e031-a6bf-479d-9abb-b7909f298ba1 | test2 | | e65d5641-01c0-4126-b80d-c5ae6d4848be | test3 | | bd02bf4e-fa5d-498d-8a9a-d38200f1ca30 | test4 | | 4df2a34e-ad65-46b4-a51a-3eb9394aeb83 | test5 | +--------------------------------------+-------+