Categories: Datatype, Variant Type, UUID Type

IS_UUID Preview

Returns TRUE if the input expression is a VARIANT<UUID>.

Syntax

IS_UUID(value VARIANT) → BOOLEAN

• value: The VARIANT value to check.

Examples

IS_UUID example

SELECT IS_UUID(TO_VARIANT(UUID '550e8400-e29b-41d4-a716-446655440000'))
-- TRUE

IS_UUID example

SELECT IS_UUID(TO_VARIANT(UUID()))
-- FALSE

IS_UUID example

SELECT IS_UUID(TO_VARIANT(GENERATE_UUID()))
-- TRUE

IS_UUID example

SELECT IS_UUID(TO_VARIANT(NULL))
-- NULL

IS_UUID example

SELECT IS_UUID(NULL)
-- NULL

Usage Notes

NULL handling for VARIANT inputs

If the input is SQL NULL (e.g., from a missing path), IS_UUID returns NULL.

Input	Result
VARIANT uuid	TRUE
VARIANT other type	FALSE
VARIANT null	FALSE
SQL NULL	NULL