Issues with timestamp columns from Athena (Iceberg) based DataSet

Question & Answer
, ,
1

Hi,
I’ve added to QuickSight a new Athena (v2) DataSource pointed to an Iceberg table in S3. The table contains a column which is of timestamp type. Querying the table in Athena I can correctly see the datetime results in the column, values like 2023-01-18 10:28:23.000 UTC.
In QuickSight, when I prepare a new Dataset based on the DataSource mentioned above, first: in the data preview the timestamp column is empty for each row, the reported type for that column is Date. Second: when I build an analysis I can use that field and its values, but I’m able only to retrieve the date part and not the time… and I need to show also the time.
Any suggestion?
Thank you.

2

Did you make sure that in your analysis, for that field, you don’t have it aggregated to the date?

image
image1635×1179 109 KB

1 Like
3

Thank you @Max, now aggregating by “Second” I’m able to see the full date/time.

1 Like