S3 Download Tool pulling invalid characters

[zakers33]

I am trying to pull in a json.gz file through the S3 download tool and am able to get data to pull through, but the characters are all invalid. However, if I download the file to my PC and then insert into Alteryx using the Input Data tool it will format the json.gz file as a csv and pull information correctly.

How can I pull in the json.gz file as a csv through the s3 download tool so that the data will display correctly? I've included screengrabs of the output of each method.

[CristianoJ · Accepted solution]

Hello,

The Amazon S3 Download Tool only supports the following file formats:  .yxdb, .avro, .csv, and .json.

Even thought you mentioned you have a json, it is actually a compressed version of it but with extension .gz.

You will not be able to automatically open your .gz file using the Amazon S3 Download tool.