snowflake.snowpark.functions.decompress_binary

snowflake.snowpark.functions.decompress_binary(input_data: Union[snowflake.snowpark.column.Column, str], method: Union[snowflake.snowpark.column.Column, str]) → Column[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.44.0/src/snowflake/snowpark/_functions/scalar_functions.py#L4038-L4061)

Decompresses binary data using the specified compression method.

Parameters:

  • input_data (ColumnOrName) – The binary data to decompress.

  • method (ColumnOrName) – The compression method used to decompress the data.

Returns:

The decompressed binary data.

Return type:

Column

Examples::
>>> from snowflake.snowpark.functions import lit
>>> from snowflake.snowpark.functions import to_binary, lit
>>> df = session.create_dataframe([['0920536E6F77666C616B65']], schema=["compressed_hex"])
>>> df.select(decompress_binary(to_binary(df["compressed_hex"]), lit("SNAPPY")).alias("decompressed")).collect()
[Row(DECOMPRESSED=bytearray(b'Snowflake'))]
Copy
Language: English