Menu
Amazon Redshift
Database Developer Guide (API Version 2012-12-01)

File Compression Parameters

You can load from compressed data files by specifying the following parameters.

File Compression Parameters

BZIP2

A value that specifies that the input file or files are in compressed bzip2 format (.bz2 files). The COPY operation reads each compressed file and uncompresses the data as it loads.

GZIP

A value that specifies that the input file or files are in compressed gzip format (.gz files). The COPY operation reads each compressed file and uncompresses the data as it loads.

LZOP

A value that specifies that the input file or files are in compressed lzop format (.lzo files). The COPY operation reads each compressed file and uncompresses the data as it loads.

Note

COPY does not support files that are compressed using the lzop --filter option.