Amazon Athena
User Guide  | API Reference

Service Limits

Note

You can contact AWS Support to request a limit increase for the limits listed here.
  • By default, concurrency limits on your account allow you to submit five concurrent queries at a time. This is a soft limit and you can request a limit increase for concurrent queries.
  • Query timeout: 30 minutes
  • Number of databases: 100
  • Table: 100 per database
  • Number of partitions: 20k per table
  • You may encounter a limit for Amazon S3 buckets per account, which is 100. Athena also needs a separate bucket to log results.

Other Notable Limitations#

  • User-defined functions (UDFs or UDAFs) are not supported.
  • Stored procedures are not supported.
  • Certain DDL functions are not supported. For more information, see Unsupported DDL.
  • A particular subset of data types are supported. For more information, see the reference for data_type in CREATE TABLE.