Im trying to extract multiple zip files containing json data, these are all stored under one bucket, under sperate folders as follows:
bucker/folder1/json.gzip
bucker/folder2/json.gzip
bucker/folder3/json.gzip
I have looked into athena and glue as a way to process and extract any data i need from the files. These seems to kinda work, but i want to look into using a database.
AWS DMS i think allows this?
But i have not found many resources showing how this can be done, or even if it can be done.
Anyone have any experience of doing something like this?