CODEWITHSUNDEEP
amazon-web-servicesamazon-s3amazon-redshift
Samrat
Samrat

Reputation: 99

Can Amazon Redshift UNLOAD into Parquet or Avro format?

While unloading any data from redshift generally delimiter and zipping is specified along with required arguments

Example 

 UNLOAD ('SELECT * from  <schema>.<table_name>') 
TO '<s3_path>' 
DELIMITER AS '$' 
GZIP 
ALLOWOVERWRITE
iam_role 'arn:aws:iam::xxxxxxxxxxxxxxxxxx' 
escape addquotes;

Does redshift support the unloading in the different file-format such as Parquet or avro ? Is redshift going to add this support of the file-format for the unload?

Upvotes: 1

Views: 1426

Answers (2)

Yoshihide Ishiba
Yoshihide Ishiba

Reputation: 311

Redshidt can now unload data to S3 in Parquet format:

UNLOAD ('select-statement')
TO 's3://object-path/name-prefix'
FORMAT PARQUET

Documentation mentioned it at UNLOAD - Amazon Redshift

Upvotes: 4

John Rotenstein
John Rotenstein

Reputation: 269276

The UNLOAD documentation does not show Parquet or Avro as output formats.

You could use Amazon Athena to convert the output from UNLOAD into one of those formats.

Upvotes: 1

Related Questions