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 athena-fips.us-east-2.amazonaws.com |
HTTPS HTTPS |
| US East (N. Virginia) | us-east-1 |
athena.us-east-1.amazonaws.com athena-fips.us-east-1.amazonaws.com |
HTTPS HTTPS |
| US West (N. California) | us-west-1 |
athena.us-west-1.amazonaws.com athena-fips.us-west-1.amazonaws.com |
HTTPS HTTPS |
| US West (Oregon) | us-west-2 |
athena.us-west-2.amazonaws.com athena-fips.us-west-2.amazonaws.com |
HTTPS HTTPS |
| Africa (Cape Town) | af-south-1 | athena.af-south-1.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-West) | 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
|
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
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.
