Amazon Athena
User Guide

Service Limits


You can contact AWS Support to request a limit increase for the limits listed here.

  • By default, limits on your account allow you to submit:

    • 20 DDL queries at the same time. DDL queries include CREATE TABLE and CREATE TABLE ADD PARTITION queries.

    • 20 DML queries at the same time. DML queries include SELECT and CREATE TABLE AS (CTAS) queries.

    After you submit your queries to Athena, it processes the queries by assigning resources based on the overall service load and the amount of incoming requests. We continuously monitor and make adjustments to the service so that your queries process as fast as possible.

    Athena service limits are shared across all workgroups in the account.

    These are soft limits and you can request a limit increase. These limits in Athena are defined as the number of queries that can be submitted to the service at the same time. You can submit up to 20 queries of the same type (DDL or DML) at a time. If you submit a query that exceeds the query limit, the Athena API displays an error message: "You have exceeded the limit for the number of queries you can run concurrently. Reduce the number of concurrent queries submitted by this account. Contact customer support to request a concurrent query limit increase.”

  • If you use Athena in regions where AWS Glue is available, migrate to AWS Glue Data Catalog. See Upgrading to the AWS Glue Data Catalog Step-by-Step.

    • If you have migrated to AWS Glue Data Catalog, for service limits on tables, databases, and partitions in Athena, see AWS Glue Limits.

    • If you have not migrated to AWS Glue Data Catalog, the number of partitions per table is 20,000. You can request a limit increase.

  • You may encounter a limit for Amazon S3 buckets per account, which is 100. Athena also needs a separate bucket to log results.

  • The query timeout is 30 minutes.

  • The maximum allowed query string length is 262144 bytes, where the strings are encoded in UTF-8. Use these tips for naming columns, tables, and databases in Athena.

  • The maximum number of workgroups you can create per Region in your account is 1000.

  • Athena APIs have the following default limits for the number of calls to the API per account (not per query):

    API Name Default Number of Calls per Second Burst Capacity
    BatchGetNamedQuery, ListNamedQueries, ListQueryExecutions 5 up to 10
    CreateNamedQuery, DeleteNamedQuery, GetNamedQuery 5 up to 20
    BatchGetQueryExecution 20 up to 40
    StartQueryExecution, StopQueryExecution 20 up to 80
    GetQueryExecution, GetQueryResults 100 up to 200

    For example, for StartQueryExecution, you can make up to 20 calls per second. In addition, if this API is not called for 4 seconds, your account accumulates a burst capacity of up to 80 calls. In this case, your application can make up to 80 calls to this API in burst mode.

    If you use any of these APIs and exceed the default limit for the number of calls per second, or the burst capacity in your account, the Athena API issues an error similar to the following: ""ClientError: An error occurred (ThrottlingException) when calling the <API_name> operation: Rate exceeded." Reduce the number of calls per second, or the burst capacity for the API for this account. You can contact AWS Support to request a limit increase.