I am seeing 'Result exceeded maximum size of 500 MB' error while downloading a large file from S3 bucket.
Thanks for sharing the error you're hitting. It looks like this is a known limit. Can you verify the file size?
"There is a hard limit on query return size of 500MB on on premise deployments, and 100MB on organizations using the cloud hosted version of Retool. There isn't currently a way to get around this, and honestly I would expect any app that is iterating over 500MB of data from postgres using javascript to perform poorly and crash some of your user's browsers. Reducing the amount of data that you need to pull in to an app is pretty key for web apps. Our performance doc does say 500k as an example of too large of a dataset, but it sounds like in your case you might be storing files in each of these rows since ~8k of them are 556MB?"