I have data stored in Amazon S3 bucket in parquet file format.
I want this data to be copied from S3 to Amazon Redshift, so I use copy commands to achieve this.
But, I need to do this manually. I want to achieve this with some sort of automation such that if any new file comes into S3, it should be copied to the required table in redshift.
Can you suggest what different approaches I can use?