Is there any file size limit to read or upload a file from/to aws s3 using the s3 resource. If yes, do we have any alternate approach to use the large file uploads n reading through retool app

Hi Retool team,
I have few questions while working with retool. Can you please help me here!

  1. Is there any file size limit to read or upload a file from/to aws s3 using the s3 resource? If yes, do we have any alternate approach to use the large file uploads n reading through retool app.
  2. Is there any limitation to read the number of rows from a datasource? Say, my sql query resulting 1.2 million records into a table but im not able to read all those.

Kindly help me with these queries.

Thanks