COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV

COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
A . GZIP
B. BZ2
C. BROTLI
D. ZSTD
E. DEFLATE
F. RAW_DEFLATE

View Answer

Answer: A,B,D,E,F

Explanation:

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. https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#type-csv