I work for Perspectum Ltd and have a paid retool version under the account firstname.lastname@example.org
As part of a new project, we are trying to present Application load balancer logs via retool interface and encountering the below errors when attempting to read records from Athena
One of the below errors are seen every time I perform a Run or Preview Operation
invalid JSON response body at http://172.20.16.162:80/api/runQuery reason: Unexpected token E in JSON at position 0
http://172.20.16.162:80/api/runQuery failed, reason: socket hang up
The s3 bucket holding Athena query results is rightly getting updated with the results every time I perform a "Run" operation from retool App. Running the same query in Athena console takes 18 seconds odd to show the results and as the next step, my plan is to add partitions and reduce the query time for the select operation.
However, I see the "timeout" in retool console is 120 seconds, and the Athena query result even though it takes 18 seconds(definitely needs fixing) seems well within retool 's limits.
Can you please advise how to fix this issue?