Refresh quick sight dataset when file uploaded to s3 bucket

Is it possible to refresh quick sight dataset when file uploaded to s3 bucket instead of scheduling refresh by specifying time and date to refresh.

I’d appreciate your help. Thank you.

Regards,
Sonal Jain

Hi Sonal. Yes, it is possible to refresh dataset when a file is uploaded to S3 bucket. You can use the S3 event trigger to invoke a lambda function. The lambda function can make a “create_ingestion” API call to initiate the data refresh (create_ingestion - Boto3 1.28.58 documentation).
S3 upload → S3 event trigger → Lambda → create_ingestion API Quicksight dataset refresh
There are limits on how many times a refresh can occur in a 24 hour period. This is also called out in the link shared above.

Hello @awsvig, thank you for the response and it is working but after first refresh if i am uploading file again then the dataset is not getting refreshed in quick sight and i am getting ‘IngestionStatus’: ‘COMPLETED’.

Thanks & Regards,
Sonal Jain