Files in aws config bucket are in .gz format how to convert in json or any other format to display in quick sight

Question & Answer
,
1

files in aws config bucket are in .gz format how to convert in json or any other format to display in quick sight
or to query via amazon Athena

2

Hi @Hardeep_Singh ,

welcome to the community :tada:

I am not sure if this is the right forum, but lets try.

.gz is a zip file ending. If you want to do it only one time, then you can download the file, unzip it with a zip-tool and upload it to the bucket.

To automate this you could use a lambda function that runs python code to do so.

Nevertheless the question is, what is inside the zip-file. Is the data in a usefull dataformat like json or csv?

Best regards,
Nico

1 Like
3

Please look into the following, if you have further questions let us know.

1 Like
4

Hi @Hardeep_Singh,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!