Can you create an automatic data update from aws s3 t?

[OBUILE]

I want my dataset to automatically update itself any time there is new data in aws s3 is it possible?

[duncan]

Hello @OBUILE , welcome to the Quicksight community!

Have you looked into using a Lambda like the solution in this post suggest?:

Refresh Quicksight Dataset-Lambda

I have a dataset in Quicksight which has the files from S3(dropped in s3) for the months after May. The dataset has the June files, I dropped a latest file in S3. on **july 11,2023 ** . I want to create a lambda which on execution with automatically refresh the quicksight dataset and show the july 11 file, could someone help in providing the steps and lambda function and ways to do this.

[duncan]

Hello @OBUILE !

Did my post help you with your solution or are you still having trouble with this issue? We have not heard from in some time but would still like to help. If we do not hear from you in 3 days this post will be archived.

[OBUILE]

Hello thank you I managed to resolve the issue

[duncan]

Hello @OBUILE , no problem!

Could you share your solution to help the community?

[OBUILE]

To update the data from S3 to Quicksight automatically in real time this was achieved through the help of AWS Athena and Glue to crawl data from S3 to Athena which then becomes the dataset in Quicksight, so the data updates in the dashboard each time there is an update or new item in S3 bucket