Hi @Markus
Since the AT TIME ZONE function in Athena returns a string with the timezone suffix, you can use the following approach to get only the timestamp part by casting and cleaning up the string. This workaround removes the timezone label from the timestamp, providing you with the local time as a pure timestamp value.
Example:
CAST(REPLACE(CAST(rwk_date AT TIME ZONE 'UTC' AT TIME ZONE 'Europe/Berlin' AS VARCHAR), ' Europe/Berlin', '') AS TIMESTAMP) AS rwk_date_local
Please refer to the below documentation this might be helpful for you.