Categories:

String & binary functions (Compression/Decompression)

DECOMPRESS_STRING¶

Decompresses the compressed BINARY input parameter to a string.

See also:

COMPRESS , DECOMPRESS_BINARY

Syntax¶

DECOMPRESS_STRING(<input>, <method>)
Copy

Arguments¶

Required:

input

A BINARY value (or expression) with data that was compressed using one of the compression methods specified in COMPRESS.

method

The compression method originally used to compress the input. See COMPRESS for a list of compression methods.

The DECOMPRESS_STRING method, unlike the COMPRESS method, does not require you to specify the compression level. If you do specify the compression level, DECOMPRESS_STRING ignores it and uses the actual compression level.

Returns¶

A string with decompressed data.

Usage notes¶

  • If the compression method is unknown or invalid, the query fails.

  • The compression method name (e.g. ZLIB) is case insensitive.

  • If you use DECOMPRESS_STRING to decompress a compressed BINARY value, rather than a compressed string value, you do not necessarily get an error; instead, the function attempts to treat the BINARY value as a sequence of hexadecimal digits and then attempts to convert those hexadecimal digits into printable characters. Snowflake recommends that you use the DECOMPRESS_BINARY function to decompress compressed data if the original data was BINARY.

Examples¶

This shows how to compress a string and then decompress back to the original value.

SELECT COMPRESS('Snowflake', 'SNAPPY');
+---------------------------------+
| COMPRESS('SNOWFLAKE', 'SNAPPY') |
|---------------------------------|
| 0920536E6F77666C616B65          |
+---------------------------------+
Copy
SELECT DECOMPRESS_STRING(TO_BINARY('0920536E6F77666C616B65', 'HEX'), 'SNAPPY');
+-------------------------------------------------------------------------+
| DECOMPRESS_STRING(TO_BINARY('0920536E6F77666C616B65', 'HEX'), 'SNAPPY') |
|-------------------------------------------------------------------------|
| Snowflake                                                               |
+-------------------------------------------------------------------------+
Copy