How to load gzipped json data from a copy


Above COPY command works without gzip. But Now i want to use the gzip to speed up the process. Now im uploading a gzipped json file into S3 bucket. But the above copy command does not work? any idea how to load a gzipped json file from COPY in Redshift?


You are missing json_option ( Try setting it ‘auto’. See corrected example below:

Leave a Reply