Which of the below mentioned compression techniques are applicable for CSV file format?

Which of the below mentioned compression techniques are applicable for CSV file format?
A . GZIP
B. BZ2
C. BROTLI
D. ZSTD
E. DEFLATE
F. RAW_DEFLATE
G. LZIP

View Answer

Answer: A, B, C, D, E, F

Explanation

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv

Supported Values

Notes

AUTO

Compression algorithm detected automatically, except for Brotli-compressed files, which cannot currently be detected automatically. If loading Brotli-compressed files, explicitly use BROTLI instead of AUTO. GZIP

BZ2

BROTLI

Must be specified when loading Brotli-compressed files.

ZSTD

Zstandard v0.8 (and higher) supported.

DEFLATE

Deflate-compressed files (with zlib header, RFC1950).

RAW_DEFLATE

Raw Deflate-compressed files (without header, RFC1951).

NONE

Data files to load have not been compressed.