does anyone know if its possible, and if so how, to add a date timestap to Quicksight file export (CSV/Excel)? The help section on data exports is pretty basic and doesn’t mention anything abut such a setting - Exporting data from Amazon QuickSight analyses - Amazon QuickSight
I have a client who clamoring for such a stamp to be added to data exports.
Hi @quicksightenthusiast - Welcome to AWS QuickSight community and thanks for posting the question. When you export the data in csv there is a date timestamp field added but it is in the sequential timestamp (a Unix epoch data type).
There was a discussion in past ( Export to CSV/Excel limitation) to have some flexibility in giving the name and date timestamp to the file name but it is in the feature request .
Hi @eperts @Max @Koushik_Muthanna - Need your help on this. Not sure whether this functionality is in the product pipeline or not . Export to CSV/Excel limitation
Regards - Sanjeeb
As Sanjeeb mentioned export timestamp is part of exported filename but it is in Epoch format. I have noted your feedback that for end user timestamp in human readable (non Epoch) datetime is useful. At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.
If datetime in non-Epoch format is must for your requirement, another option you may consider is adding parameter in table header (may be in small font) While you export data on this table current datetime export timestamp is available in file in nonEpoch format explain in screenshot below.
Thanks @AnwarAli . This is a work around solution where the the header is having the date.
Regards - Sanjeeb
thanks, going to give it a try