We are exploring Aurora Serverless as a database storage for one of our projects. We are using data APIs to perform a Proof of Concept (POC), but we are receiving a “Database returned more than the allowed response size limit” exception.
- Is there an in-built solution for this? Is there a token mechanism similar to DynamoDB in Aurora Serverless?
- We need to quickly fetch 50,000 records. Should we use Aurora or Aurora Serverless?
- Database: Aurora PostgreSQL Serverless
import boto3; client = boto3.client('rds-data') import sys; sql_statement = "select * from table_name limit 1000" response = client.execute_statement( database='mydb', secretArn='<secret_arn', resourceArn='<resource_arn>', sql=sql_statement ) print(response);