I am trying to update a field for a single record in an AWS Athena Iceberg table.
The query executes and updates the field in the database. Confirmed by querying the table directly in Athena.
After the query executes, Retool throws a 502 error. What could be causing this?
Hello @digidoc1010 Welcome to the Retool Community,
The 502 error you're encountering in Retool after a successful Athena Iceberg table update suggests a communication or timeout issue between Retool and Athena, not a problem with the update itself since you've confirmed it in Athena. Here's a possible causes :
1. Query Timeout: Iceberg updates can be slow. Increase Retool's query timeout and match it to Athena's execution time. Consider asynchronous updates if supported.
2. Network: Check network stability between Retool and Athena. Verify VPC/proxy config if applicable.
3. Retool Resources: Check Retool logs for errors or resource limits. Contact support if needed.
Thank you for your reply. I don't think it is any of those reasons. There are other queries that take much longer to run so I don't think it's a timeout, network, or resource issue. This is the simplest query I am using in the application, and it runs in less than 3 sec. It is interesting to me that it only happens with this UPDATE query and it is the only UPDATE query in the application. All other queries including INSERT queries run just fine with no errors.
