Snapshot in S3 for a dashboard data source

Question & Answer
,
1

Good morning,
Every month we take a report for authority and we store in an S3 bucket.
I want to use the snapshot as source for my dashboard, my question is :
Having different snapshot in my S3 is there a way to select one in particular ( for example the snapshot of two month ago) for the dashboard?
Like a sort of menu where chose the snapshot?

Thanks
Francesco

2

Hello @Francesco7,

Welcome to the QuickSight community, it is great having you here!

Not directly, at this moment in time, you cannot select a different datasoruce for your dashboards, one thing I think it could work, is, If all the S3 files have a filename like a snapshot_id or shapshot_date you could have them all included in the same manifest file, and then filter them in the dashboard?

Hope this works!

3

Thanks Andres make sense, Do you mean like adding a column with the date of the snapshot and then put a filter on it on Dashboard? Brillant!!
A final question, do you think is possible to directly APPEND the new snapshot to the existing one, so to use a single source for Quicksight, or should I use an intermediary/staging table to append them ( even more sense from a safety perspective).

4

I am glad you like the idea :slight_smile:. If you have a manifest file pointing to an S3 prefix, and then all the files under that prefix will be used by the data source. Therefore you only need to add the extra column to the snapshots and just drop the new ones in S3.

URIPrefixes – Use this array to list URI prefixes for S3 buckets and folders. All files in a specified bucket or folder are imported. Amazon QuickSight recursively retrieves files from child folders.

The option of having a single data source where you do some EtL with the new snapshots into a new dataset will also work off course if you find any issues with this approach, and has an upside that you do not need to change the snapshots.

5

Hi @Francesco7,
It’s been awhile since we last heard from you, did you have any additional questions regarding your topic?

If we do not hear back within the next 3 business days, I’ll go ahead and mark as solved.

Thank you!

6

Hi @Francesco7,
Since we haven’t heard back, I’ll close this topic out. However, if you have any additional questions, feel free to create a new post in the community and if related to this case, link this topic for relevant information.

Thank you!