Limitations for the Amazon RDS Data API (original) (raw)

RDS Data API has the following limitations:

• You can only execute Data API queries on writer instances in a DB cluster. However, writer instances can accept both write and read queries.
• With Aurora global databases, you can enable Data API on both the primary and secondary DB clusters. However, a secondary cluster doesn't have a writer instance until it's promoted to be the primary. Data API requires access to the writer instance for query processing, even for read queries. As a result, read and write queries sent to the secondary cluster fail while it lacks a writer instance. Once a secondary cluster is promoted and has a writer instance available, Data API queries on that DB instance succeed.
• Data API isn't supported on T DB instance classes.
• For Aurora Serverless v2 and provisioned DB clusters, RDS Data API doesn't support some data types. For the list of supported types, see Comparing Amazon RDS Data API behaviors for Aurora Serverless v2 and provisioned clusters with Aurora Serverless v1 clusters.
• For Aurora PostgreSQL version 14 and higher databases, Data API only supportsscram-sha-256 for password encryption.
• The response size limit is 1 MiB. If the call returns more than 1 MiB of response data, the call is terminated.
• For Aurora Serverless v1, the maximum number of requests per second is 1,000. For all other supported databases, there is no limit.
• The Data API size limit is 64 KB per row in the result set returned by the database. Make sure that each row in a result set is 64 KB or less.

Region and version availability for the Amazon RDS Data API

Data API with Aurora Serverless v2 compared with Aurora Serverless v1

Did this page help you? - Yes

Thanks for letting us know we're doing a good job!

If you've got a moment, please tell us what we did right so we can do more of it.

Did this page help you? - No

Thanks for letting us know this page needs work. We're sorry we let you down.

If you've got a moment, please tell us how we can make the documentation better.