COMPRESSION = AUTO can automatically detect below compression techniques when FORMAT TYPE is CSV
GZIP
BZ2
BROTLI
ZSTD
DEFLATE
RAW_DEFLATE