Amazon Athena endpoints and quotas - AWS General Reference

Amazon Athena endpoints and quotas

The following are the service endpoints and service quotas for this service. To connect programmatically to an AWS service, you use an endpoint. In addition to the standard AWS endpoints, some AWS services offer FIPS endpoints in selected Regions. For more information, see AWS service endpoints. Service quotas, also referred to as limits, are the maximum number of service resources or operations for your AWS account. For more information, see AWS service quotas.

Service Endpoints

Region Name Region Endpoint Protocol
US East (Ohio) us-east-2 athena.us-east-2.amazonaws.com HTTPS
US East (N. Virginia) us-east-1 athena.us-east-1.amazonaws.com HTTPS
US West (N. California) us-west-1 athena.us-west-1.amazonaws.com HTTPS
US West (Oregon) us-west-2 athena.us-west-2.amazonaws.com HTTPS
Asia Pacific (Hong Kong) ap-east-1 athena.ap-east-1.amazonaws.com HTTPS
Asia Pacific (Mumbai) ap-south-1 athena.ap-south-1.amazonaws.com HTTPS
Asia Pacific (Seoul) ap-northeast-2 athena.ap-northeast-2.amazonaws.com HTTPS
Asia Pacific (Singapore) ap-southeast-1 athena.ap-southeast-1.amazonaws.com HTTPS
Asia Pacific (Sydney) ap-southeast-2 athena.ap-southeast-2.amazonaws.com HTTPS
Asia Pacific (Tokyo) ap-northeast-1 athena.ap-northeast-1.amazonaws.com HTTPS
Canada (Central) ca-central-1 athena.ca-central-1.amazonaws.com HTTPS
China (Beijing) cn-north-1 athena.cn-north-1.amazonaws.com.cn HTTPS
China (Ningxia) cn-northwest-1 athena.cn-northwest-1.amazonaws.com.cn HTTPS
Europe (Frankfurt) eu-central-1 athena.eu-central-1.amazonaws.com HTTPS
Europe (Ireland) eu-west-1 athena.eu-west-1.amazonaws.com HTTPS
Europe (London) eu-west-2 athena.eu-west-2.amazonaws.com HTTPS
Europe (Milan) eu-south-1 athena.eu-south-1.amazonaws.com HTTPS
Europe (Paris) eu-west-3 athena.eu-west-3.amazonaws.com HTTPS
Europe (Stockholm) eu-north-1 athena.eu-north-1.amazonaws.com HTTPS
Middle East (Bahrain) me-south-1 athena.me-south-1.amazonaws.com HTTPS
South America (São Paulo) sa-east-1 athena.sa-east-1.amazonaws.com HTTPS
AWS GovCloud (US-East) us-gov-east-1

athena.us-gov-east-1.amazonaws.com

athena-fips.us-gov-east-1.amazonaws.com

HTTPS

HTTPS

AWS GovCloud (US) us-gov-west-1

athena.us-gov-west-1.amazonaws.com

athena-fips.us-gov-west-1.amazonaws.com

HTTPS

HTTPS

To download the latest version of the JDBC driver and its documentation, see Using Athena with the JDBC Driver.

For more information about the previous versions of the JDBC driver and their documentation, see Using the Previous Version of the JDBC Driver.

To download the latest and previous versions of the ODBC driver and their documentation, see Connecting to Athena with ODBC.

Service Quotas

Resource Default
Number of active DDL queries. DDL queries include CREATE TABLE and CREATE TABLE ADD PARTITION queries. 20

Number of active DML queries. DML queries include SELECT and CREATE TABLE AS (CTAS) queries.

20
DDL query timeout 600 minutes
DML query timeout 30 minutes
Maximum allowed query string length 262144 bytes

Athena APIs have the following default quotas 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 quota 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. To request a quota increase, contact AWS Support. Open the AWS Support Center page, sign in if necessary, and choose Create case. Choose Service limit increase. Complete and submit the form.

Note

This quota cannot be changed in the Athena Service Quotas console.

For information about quotas for databases, tables, and partitions, see Service Quotas. If you have not migrated to AWS Glue Data Catalog, the number of partitions per table is 20,000.