snowflake.snowpark.functions.try_hex_decode_binary¶

snowflake.snowpark.functions.try_hex_decode_binary(input_expr: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.47.0/src/snowflake/snowpark/_functions/scalar_functions.py#L4363-L4381)¶

Decodes a hex-encoded string to binary data. Returns None if the input is not a valid hex string.

Parameters:: input_expr (ColumnOrName) – A hex-encoded string to decode to binary data.
Returns:: The decoded binary data as bytearray, or None if input is invalid.
Return type:: Column

Examples::

>>> from snowflake.snowpark.functions import col
>>> df = session.create_dataframe([["41426162"], ["48656C6C6F"], ["576F726C64"]], schema=["hex_string"])
>>> df.select(try_hex_decode_binary(col("hex_string")).alias("decoded_binary")).collect()
[Row(DECODED_BINARY=bytearray(b'ABab')), Row(DECODED_BINARY=bytearray(b'Hello')), Row(DECODED_BINARY=bytearray(b'World'))]