Service Limits


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 run 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. See Unsupported DDL.
  • A particular subset of datatypes is supported. See the reference for data_type in CREATE TABLE.