I have a function on Postgres that imports data from my AWS-S3 bucket. Is there a way to trigger that function whenever a new file is uploaded to the bucket?
p.s. my Postgres database is running on AWS RDS
I have a function on Postgres that imports data from my AWS-S3 bucket. Is there a way to trigger that function whenever a new file is uploaded to the bucket?
p.s. my Postgres database is running on AWS RDS
Yes, You can create AWS lambda function and add events in your s3 bucket to trigger lambda function whenever object gets uploaded in s3 bucket and then call that postgres function from aws lambda function.
follow the tutorial for more info https://www.tutorialspoint.com/aws_lambda/aws_lambda_using_lambda_function_with_amazon_s3.htm