Last Updated on April 28, 2021

Below is a reference for all attribute names and attribute values in AWS Pricing API for Amazon Athena.

Note: All the list below are in alphabetical order.

Service Code: AmazonAthena

Python Code to get Attribute Names for AmazonAthena using Boto3

import boto3

pricing_client = boto3.client('pricing', region_name='us-east-1')

response = pricing_client.describe_services(ServiceCode='AmazonAthena')

attribute_names = response['Services'][0]['AttributeNames']

print(attribute_names)

Attribute Name List for AmazonAthena

• description
• freeQueryTypes
• location
• locationType
• productFamily
• servicecode
• servicename
• termType
• usagetype

Python Code to get the Attribute Values List for AmazonAthena using Boto3

import boto3

pricing_client = boto3.client('pricing', region_name='us-east-1')

response = pricing_client.describe_services(ServiceCode='AmazonAthena')

attribute_names = response['Services'][0]['AttributeNames']

for attribute_name in attribute_names:

    attribute_values = []

    response_iterator = pricing_client.get_paginator('get_attribute_values').paginate(
        ServiceCode='AmazonAthena',
        AttributeName=attribute_name
    )

    for response in response_iterator:
        for attribute_value in response['AttributeValues']:
            attribute_values.append(attribute_value['Value'])

    print('Attribute Name:', attribute_name)
    print(attribute_values)
    print()

Attribute Values List for AmazonAthena

Attribute Name: description
Values:

Charged for total data scanned per query with a minimum 10MB for each successful or cancelled queries

Attribute Name: freeQueryTypes
Values:

Data definition queries (DDL), Failed Queries and statements used to create or load partitions

Attribute Name: location
Values:

Africa (Cape Town)
Asia Pacific (Hong Kong)
Asia Pacific (Mumbai)
Asia Pacific (Seoul)
Asia Pacific (Singapore)
Asia Pacific (Sydney)
Asia Pacific (Tokyo)
AWS GovCloud (US-East)
AWS GovCloud (US-West)
Canada (Central)
EU (Frankfurt)
EU (Ireland)
EU (London)
EU (Milan)
EU (Paris)
EU (Stockholm)
Middle East (Bahrain)
South America (Sao Paulo)
US East (N. Virginia)
US East (Ohio)
US West (N. California)
US West (Oregon)

Attribute Name: locationType
Values:

AWS Region

Attribute Name: productFamily
Values:

Athena Queries

Attribute Name: servicecode
Values:

AmazonAthena

Attribute Name: servicename
Values:

Amazon Athena

Attribute Name: termType
Values:

OnDemand

Attribute Name: usagetype
Values:

AFS1-DataScannedInTB
APE1-DataScannedInTB
APN1-DataScannedInTB
APN2-DataScannedInTB
APS1-DataScannedInTB
APS2-DataScannedInTB
APS3-DataScannedInTB
CAN1-DataScannedInTB
EU-DataScannedInTB
EUC1-DataScannedInTB
EUN1-DataScannedInTB
EUS1-DataScannedInTB
EUW2-DataScannedInTB
EUW3-DataScannedInTB
MES1-DataScannedInTB
SAE1-DataScannedInTB
UGE1-DataScannedInTB
UGW1-DataScannedInTB
USE1-DataScannedInTB
USE2-DataScannedInTB
USW1-DataScannedInTB
USW2-DataScannedInTB

We hope the above list of attribute names and values helps when using the AWS Pricing API for Amazon Athena.

If the list is outdated, let us know in the comments below. We’ll update it as soon as we can.