I’m using an AWS Timestream dataset in QuickSight, which contains ISO8601 timestamps. According to this documentation, custom time zones are not supported for Timestream.
I need to convert these timestamps to the Europe/Berlin time zone and use them in my analysis. How can I achieve this within QuickSight?
I have already tried to insert a calculated field (time-eu-berlin). But it is converted back to UTC in my analysis?
Your calculation looks correct. Please add it at the dataset level. I tested your calculation by creating it in the dataset, and it works fine in the analysis since the calculation is converted to the desired time and stored in SPICE memory.
Different date formats are supported based on the type of dataset used. check the table to see details of supported date formats. refer this parseDate
I was able to import the data successfully with SPICE - the loaded data are now displayed correctly.
Is this also possible somehow using direct query?
I would be interested to know if you know best practices for efficiently managing large amounts of data in combination with SPICE. I am thinking of an approach in which, for example, one month’s data is loaded into SPICE and the remaining data is retrieved via Direct Query. Do you have any recommendations or experience with this?
