Skip to main content

Variant Type Preview

Function NameDescription
IS_BIGINTReturns TRUE if the input expression is a BIGINT value.
IS_BOOLEANReturns TRUE if the input expression is a VARIANT<BOOLEAN>.
IS_DATEReturns TRUE if the input expression is a VARIANT<DATE>.
IS_DECIMALReturns TRUE if the input expression is a VARIANT<DECIMAL>.
IS_DOUBLEReturns TRUE if the input expression is a VARIANT<DOUBLE>.
IS_FLOATReturns TRUE if the input expression is a VARIANT<FLOAT>.
IS_INTReturns TRUE if the input expression is an integer value.
IS_LISTReturns TRUE if the input expression is a VARIANT<ARRAY>.
IS_STRUCTReturns TRUE if the input expression is a VARIANT<STRUCT>.
IS_TIMESTAMPReturns TRUE if the input expression is a VARIANT<TIMESTAMP>.
IS_TIMEReturns TRUE if the input expression is a VARIANT<TIME>.
IS_UUIDReturns TRUE if the input expression is a VARIANT<UUID>.
IS_VARBINARYReturns TRUE if the input expression is a VARIANT<VARBINARY>.
IS_VARCHARReturns TRUE if the input expression is a VARCHAR value.
IS_VARIANT_NULLReturns TRUE if the input expression is a VARIANT<NULL> (as opposed to SQL NULL).
PARSE_JSONParses a JSON string into a VARIANT value.
TO_JSONConverts a VARIANT value to a JSON string.
TO_VARIANTConverts a value to VARIANT type.
TRY_PARSE_JSONParses a JSON string into a VARIANT value, returning NULL if the JSON is invalid.
TRY_VARIANT_GETExtracts a value from a VARIANT using a path expression, returning NULL if the cast fails.
TYPEOFReports the type (in string format) of the input expression.
VARIANT_GETExtracts a value from a VARIANT using a path expression, optionally casting to a target type.