I am trying to digest data to give me a visual in the following format Location ID Type Metric This Month Last Month MoM % Change 12345 A Metric 1 45 23 48.88% 12345 B Metric 1 54 52 3.85% 67890 A Metric 1 74 89 -20.27% 67890 B Metric 1 23 26 -13.04% 65432 A Metric 1 76 63 17.11% 6…

Can you prepare the table in athena in the way you need it? Otherwise the data transformation (union) needs to be done live. That needs time and ends up in the time out. My suggestion is to transform the data in your table instead of using the custom sql. Best regards, Nico

How to Pivot an AWS Athena table via SQL

Q&A

vignessh.b November 4, 2025, 2:51am 8

@hcorbett (cc: @Nico ) Have you tried the new data preparation experience in Quick Sight that was recently launched? It now provides Pivot, Unpivot, Append, Aggregate (ListAgg, ListAgg Distinct) and many more features in data preparation through a visual interface.

1 Like

Topic		Replies	Views
Can we pivot data in Quick Sight? Q&A formatting , data-preparation	1	1499	March 23, 2022
How to pivot data table without access to dataset? Q&A analysis , calculations , Business-Intelligence-Engineer	3	25	May 29, 2025
Table formatting Q&A analysis , pivot-table , Business-Intelligence-Engineer	9	50	December 20, 2024
Pivot table swap column and value Q&A pivot-table , Business-Intelligence-Engineer	5	282	March 28, 2024
A scheduled dashboard (weekly & monthly) with automatic dates for queries and title Q&A data-source , analysis , formatting	15	2077	February 20, 2023

How to Pivot an AWS Athena table via SQL

Related topics