Sai Sci Tech

Amazon Redshift AWS Price List API all Attribute Names and Values

Last Updated on April 28, 2021

Below is a reference for all attribute names and attribute values in AWS Price List API for Amazon Redshift.

Note: All the list below are in alphabetical order.

Service Code: AmazonRedshift

Python Code to get Attribute Names for AmazonRedshift using Boto3

import boto3

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

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

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

print(attribute_names)

Attribute Name List for AmazonRedshift

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

import boto3

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

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

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='AmazonRedshift',
        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 AmazonRedshift

Attribute Name: concurrencyscalingfreeusage
Values:

No
Yes

Attribute Name: currentGeneration
Values:

No
Yes

Attribute Name: description
Values:

Data scanned per query for each successful or cancelled query
Storage charges with Redshift managed storage

Attribute Name: ecu
Values:

104
116
12.375
14
148.5
35
37.125
4.4
7
99

Attribute Name: group
Values:

Redshift-FreeTrial-InstanceUsage

Attribute Name: groupDescription
Values:

Monthly free usage of DC1.Large instance type hours per month for 2 months
Monthly free usage of DC2.Large instance type hours per month for 2 months

Attribute Name: instanceType
Values:

dc1.8xlarge
dc1.large
dc2.8xlarge
dc2.large
ds1.8xlarge
ds1.xlarge
ds2.8xlarge
ds2.xlarge
ra3.16xlarge
ra3.4xlarge
ra3.xlplus

Attribute Name: io
Values:

0.20 GB/s
0.30 GB/s
0.40 GB/s
0.60 GB/s
0.65 GB/s
2.00 GB/s
2.40 GB/s
3.30 GB/s
3.70 GB/s
7.50 GB/s
8.00 GB/s

Attribute Name: LeaseContractLength
Values:

1yr
3yr

Attribute Name: location
Values:

Africa (Cape Town)
Asia Pacific (Hong Kong)
Asia Pacific (Mumbai)
Asia Pacific (Osaka)
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: memory
Values:

120 GiB
15 GiB
244 GiB
31 GiB
32 GiB
384 GiB
96 GiB

Attribute Name: OfferingClass
Values:

standard

Attribute Name: operation
Values:

RunComputeNode:0001

Attribute Name: pricingUnit
Values:

GB-Mo

Attribute Name: productFamily
Values:

Bundle
Compute Instance
Redshift Concurrency Scaling
Redshift Data Scan
Redshift Managed Storage
Storage Snapshot

Attribute Name: PurchaseOption
Values:

All Upfront
No Upfront
Partial Upfront

Attribute Name: Restriction
Values:

Limited SKU Usage

Attribute Name: servicecode
Values:

AmazonRedshift

Attribute Name: servicename
Values:

Amazon Redshift

Attribute Name: storage
Values:

0.16TB SSD
16TB HDD
2.56TB SSD
2TB HDD
32TB RMS
64TB RMS

Attribute Name: storageMedia
Values:

Amazon S3

Attribute Name: termType
Values:

OnDemand
Reserved

Attribute Name: usageFamily
Values:

Dense Compute
Dense Storage
RA3

Attribute Name: usagetype
Values:

AFS1-DataScanned                 APN1-CSFreeUsage:ra3.4xlarge     APN2-Node:dw2.large              APS1-Node:ds2.xlarge             APS2-RMS:ra3.16xlarge            CAN1-Node:ds2.xlarge             EU-CS:ra3.xlplus                 EUC1-Node:dc2.large              EUN1-Node:ra3.16xlarge           EUW2-Node:ra3.4xlarge            MES1-CSFreeUsage:dc2.large       SAE1-DataScanned                 UGE1-RMS:ra3.16xlarge            USE2-CS:ds2.xlarge               USW1-CSFreeUsage:ra3.xlplus      USW2-Node:dc2.8xlarge            
AFS1-Node:dc2.8xlarge            APN1-CSFreeUsage:ra3.xlplus      APN2-Node:ra3.16xlarge           APS1-Node:dw.hs1.8xlarge         APS2-RMS:ra3.4xlarge             CAN1-Node:dw2.8xlarge            EU-CSFreeUsage:dc2.8xlarge       EUC1-Node:ds2.8xlarge            EUN1-Node:ra3.4xlarge            EUW2-Node:ra3.xlplus             MES1-CSFreeUsage:ds2.8xlarge     SAE1-Node:dc2.8xlarge            UGE1-RMS:ra3.4xlarge             USE2-CS:ra3.16xlarge             USW1-DataScanned                 USW2-Node:dc2.large              
AFS1-Node:dc2.large              APN1-DataScanned                 APN2-Node:ra3.4xlarge            APS1-Node:dw.hs1.xlarge          APS2-RMS:ra3.xlplus              CAN1-Node:dw2.large              EU-CSFreeUsage:dc2.large         EUC1-Node:ds2.xlarge             EUN1-Node:ra3.xlplus             EUW2-Redshift:PaidSnapshots      MES1-CSFreeUsage:ds2.xlarge      SAE1-Node:dc2.large              UGE1-RMS:ra3.xlplus              USE2-CS:ra3.4xlarge              USW1-Node:dc2.8xlarge            USW2-Node:ds2.8xlarge            
AFS1-Node:ds2.8xlarge            APN1-Node:dc2.8xlarge            APN2-Node:ra3.xlplus             APS1-Node:dw2.8xlarge            APS3-CS:ra3.16xlarge             CAN1-Node:ra3.16xlarge           EU-CSFreeUsage:ds2.8xlarge       EUC1-Node:dw.hs1.8xlarge         EUN1-Redshift:PaidSnapshots      EUW2-RMS:ra3.16xlarge            MES1-DataScanned                 SAE1-Node:ds2.8xlarge            UGW1-CS:dc2.8xlarge              USE2-CS:ra3.xlplus               USW1-Node:dc2.large              USW2-Node:ds2.xlarge             
AFS1-Node:ds2.xlarge             APN1-Node:dc2.large              APN2-Redshift:PaidSnapshots      APS1-Node:dw2.large              APS3-CS:ra3.4xlarge              CAN1-Node:ra3.4xlarge            EU-CSFreeUsage:ds2.xlarge        EUC1-Node:dw.hs1.xlarge          EUS1-DataScanned                 EUW2-RMS:ra3.4xlarge             MES1-Node:dc2.8xlarge            SAE1-Node:ds2.xlarge             UGW1-CS:dc2.large                USE2-CSFreeUsage:dc2.8xlarge     USW1-Node:ds2.8xlarge            USW2-Node:dw.hs1.8xlarge         
AFS1-Redshift:PaidSnapshots      APN1-Node:ds2.8xlarge            APN2-RMS:ra3.16xlarge            APS1-Node:ra3.16xlarge           APS3-CSFreeUsage:ra3.16xlarge    CAN1-Node:ra3.xlplus             EU-CSFreeUsage:ra3.16xlarge      EUC1-Node:dw2.8xlarge            EUS1-Node:dc2.8xlarge            EUW3-CS:ra3.16xlarge             MES1-Node:dc2.large              SAE1-Node:dw2.8xlarge            UGW1-CS:ds2.8xlarge              USE2-CSFreeUsage:dc2.large       USW1-Node:ds2.xlarge             USW2-Node:dw.hs1.xlarge          
APE1-CS:dc2.8xlarge              APN1-Node:ds2.xlarge             APN2-RMS:ra3.4xlarge             APS1-Node:ra3.4xlarge            APS3-CSFreeUsage:ra3.4xlarge     CAN1-Redshift:PaidSnapshots      EU-CSFreeUsage:ra3.4xlarge       EUC1-Node:dw2.large              EUS1-Node:dc2.large              EUW3-CS:ra3.4xlarge              MES1-Node:ds2.8xlarge            SAE1-Node:dw2.large              UGW1-CS:ds2.xlarge               USE2-CSFreeUsage:ds2.8xlarge     USW1-Node:dw2.8xlarge            USW2-Node:dw2.8xlarge            
APE1-CS:dc2.large                APN1-Node:dw.hs1.8xlarge         APN2-RMS:ra3.xlplus              APS1-Node:ra3.xlplus             APS3-DataScanned                 CAN1-RMS:ra3.16xlarge            EU-CSFreeUsage:ra3.xlplus        EUC1-Node:ra3.16xlarge           EUS1-Node:ds2.8xlarge            EUW3-CS:ra3.xlplus               MES1-Node:ds2.xlarge             SAE1-Node:ra3.16xlarge           UGW1-CSFreeUsage:dc2.8xlarge     USE2-CSFreeUsage:ds2.xlarge      USW1-Node:dw2.large              USW2-Node:dw2.large              
APE1-CS:ds2.8xlarge              APN1-Node:dw.hs1.xlarge          APN3-CS:dc2.8xlarge              APS1-Redshift:PaidSnapshots      APS3-Node:dc2.8xlarge            CAN1-RMS:ra3.4xlarge             EU-DataScanned                   EUC1-Node:ra3.4xlarge            EUS1-Node:ds2.xlarge             EUW3-CSFreeUsage:ra3.16xlarge    MES1-Redshift:PaidSnapshots      SAE1-Node:ra3.4xlarge            UGW1-CSFreeUsage:dc2.large       USE2-CSFreeUsage:ra3.16xlarge    USW1-Node:ra3.16xlarge           USW2-Node:ra3.16xlarge           
APE1-CS:ds2.xlarge               APN1-Node:dw2.8xlarge            APN3-CS:dc2.large                APS1-RMS:ra3.16xlarge            APS3-Node:dc2.large              CAN1-RMS:ra3.xlplus              EU-Node:dc2.8xlarge              EUC1-Node:ra3.xlplus             EUS1-Redshift:PaidSnapshots      EUW3-CSFreeUsage:ra3.4xlarge     Node:dc2.8xlarge                 SAE1-Node:ra3.xlplus             UGW1-CSFreeUsage:ds2.8xlarge     USE2-CSFreeUsage:ra3.4xlarge     USW1-Node:ra3.4xlarge            USW2-Node:ra3.4xlarge            
APE1-CSFreeUsage:dc2.8xlarge     APN1-Node:dw2.large              APN3-CS:ds2.8xlarge              APS1-RMS:ra3.4xlarge             APS3-Node:ds2.8xlarge            CS:dc2.8xlarge                   EU-Node:dc2.large                EUC1-Redshift:PaidSnapshots      EUW2-CS:dc2.8xlarge              EUW3-CSFreeUsage:ra3.xlplus      Node:dc2.large                   SAE1-Redshift:PaidSnapshots      UGW1-CSFreeUsage:ds2.xlarge      USE2-CSFreeUsage:ra3.xlplus      USW1-Node:ra3.xlplus             USW2-Node:ra3.xlplus             
APE1-CSFreeUsage:dc2.large       APN1-Node:ra3.16xlarge           APN3-CS:ds2.xlarge               APS2-CS:ra3.16xlarge             APS3-Node:ds2.xlarge             CS:dc2.large                     EU-Node:ds2.8xlarge              EUC1-RMS:ra3.16xlarge            EUW2-CS:dc2.large                EUW3-DataScanned                 Node:ds2.8xlarge                 SAE1-RMS:ra3.16xlarge            UGW1-DataScanned                 USE2-DataScanned                 USW1-Redshift:PaidSnapshots      USW2-Redshift:PaidSnapshots      
APE1-CSFreeUsage:ds2.8xlarge     APN1-Node:ra3.4xlarge            APN3-CSFreeUsage:dc2.8xlarge     APS2-CS:ra3.4xlarge              APS3-Node:dw2.8xlarge            CS:ds2.8xlarge                   EU-Node:ds2.xlarge               EUC1-RMS:ra3.4xlarge             EUW2-CS:ds2.8xlarge              EUW3-Node:dc2.8xlarge            Node:ds2.xlarge                  SAE1-RMS:ra3.4xlarge             UGW1-Node:dc2.8xlarge            USE2-Node:dc2.8xlarge            USW1-RMS:ra3.16xlarge            USW2-RMS:ra3.16xlarge            
APE1-CSFreeUsage:ds2.xlarge      APN1-Node:ra3.xlplus             APN3-CSFreeUsage:dc2.large       APS2-CS:ra3.xlplus               APS3-Node:dw2.large              CS:ds2.xlarge                    EU-Node:dw.hs1.8xlarge           EUN1-CS:dc2.8xlarge              EUW2-CS:ds2.xlarge               EUW3-Node:dc2.large              Node:dw.hs1.8xlarge              SAE1-RMS:ra3.xlplus              UGW1-Node:dc2.large              USE2-Node:dc2.large              USW1-RMS:ra3.4xlarge             USW2-RMS:ra3.4xlarge             
APE1-Node:dc2.8xlarge            APN1-Redshift:PaidSnapshots      APN3-CSFreeUsage:ds2.8xlarge     APS2-CSFreeUsage:ra3.16xlarge    APS3-Node:ra3.16xlarge           CS:ra3.16xlarge                  EU-Node:dw.hs1.xlarge            EUN1-CS:dc2.large                EUW2-CS:ra3.16xlarge             EUW3-Node:ds2.8xlarge            Node:dw.hs1.xlarge               UGE1-CS:dc2.8xlarge              UGW1-Node:ds2.8xlarge            USE2-Node:ds2.8xlarge            USW1-RMS:ra3.xlplus              USW2-RMS:ra3.xlplus              
APE1-Node:dc2.large              APN1-RMS:ra3.16xlarge            APN3-CSFreeUsage:ds2.xlarge      APS2-CSFreeUsage:ra3.4xlarge     APS3-Node:ra3.4xlarge            CS:ra3.4xlarge                   EU-Node:dw2.8xlarge              EUN1-CS:ds2.8xlarge              EUW2-CS:ra3.4xlarge              EUW3-Node:ds2.xlarge             Node:dw2.8xlarge                 UGE1-CS:dc2.large                UGW1-Node:ds2.xlarge             USE2-Node:ds2.xlarge             USW2-CS:dc2.8xlarge              
APE1-Node:ds2.8xlarge            APN1-RMS:ra3.4xlarge             APN3-DataScanned                 APS2-CSFreeUsage:ra3.xlplus      APS3-Node:ra3.xlplus             CS:ra3.xlplus                    EU-Node:dw2.large                EUN1-CS:ds2.xlarge               EUW2-CSFreeUsage:dc2.8xlarge     EUW3-Node:ra3.16xlarge           Node:dw2.large                   UGE1-CS:ds2.8xlarge              UGW1-Node:dw.hs1.8xlarge         USE2-Node:dw2.8xlarge            USW2-CS:dc2.large                
APE1-Node:ds2.xlarge             APN1-RMS:ra3.xlplus              APN3-Node:dc2.8xlarge            APS2-DataScanned                 APS3-Redshift:PaidSnapshots      CSFreeUsage:dc2.8xlarge          EU-Node:ra3.16xlarge             EUN1-CSFreeUsage:dc2.8xlarge     EUW2-CSFreeUsage:dc2.large       EUW3-Node:ra3.4xlarge            Node:ra3.16xlarge                UGE1-CS:ds2.xlarge               UGW1-Node:dw.hs1.xlarge          USE2-Node:dw2.large              USW2-CS:ds2.8xlarge              
APN1-CS:dc2.8xlarge              APN2-CS:ra3.16xlarge             APN3-Node:dc2.large              APS2-Node:dc2.8xlarge            APS3-RMS:ra3.16xlarge            CSFreeUsage:dc2.large            EU-Node:ra3.4xlarge              EUN1-CSFreeUsage:dc2.large       EUW2-CSFreeUsage:ds2.8xlarge     EUW3-Node:ra3.xlplus             Node:ra3.4xlarge                 UGE1-CSFreeUsage:dc2.8xlarge     UGW1-Node:dw2.8xlarge            USE2-Node:ra3.16xlarge           USW2-CS:ds2.xlarge               
APN1-CS:dc2.large                APN2-CS:ra3.4xlarge              APN3-Node:ds2.8xlarge            APS2-Node:dc2.large              APS3-RMS:ra3.4xlarge             CSFreeUsage:ds2.8xlarge          EU-Node:ra3.xlplus               EUN1-CSFreeUsage:ds2.8xlarge     EUW2-CSFreeUsage:ds2.xlarge      EUW3-Redshift:PaidSnapshots      Node:ra3.xlplus                  UGE1-CSFreeUsage:dc2.large       UGW1-Node:dw2.large              USE2-Node:ra3.4xlarge            USW2-CS:ra3.16xlarge             
APN1-CS:ds2.8xlarge              APN2-CS:ra3.xlplus               APN3-Node:ds2.xlarge             APS2-Node:ds2.8xlarge            CAN1-CS:ra3.16xlarge             CSFreeUsage:ds2.xlarge           EU-Redshift:PaidSnapshots        EUN1-CSFreeUsage:ds2.xlarge      EUW2-CSFreeUsage:ra3.16xlarge    EUW3-RMS:ra3.16xlarge            Redshift:PaidSnapshots           UGE1-CSFreeUsage:ds2.8xlarge     UGW1-Node:ra3.16xlarge           USE2-Node:ra3.xlplus             USW2-CS:ra3.4xlarge              
APN1-CS:ds2.xlarge               APN2-CSFreeUsage:ra3.16xlarge    APN3-Redshift:PaidSnapshots      APS2-Node:ds2.xlarge             CAN1-CS:ra3.4xlarge              CSFreeUsage:ra3.16xlarge         EU-RMS:ra3.16xlarge              EUN1-DataScanned                 EUW2-CSFreeUsage:ra3.4xlarge     EUW3-RMS:ra3.4xlarge             RMS:ra3.16xlarge                 UGE1-CSFreeUsage:ds2.xlarge      UGW1-Node:ra3.4xlarge            USE2-Redshift:PaidSnapshots      USW2-CS:ra3.xlplus               
APN1-CS:ra3.16xlarge             APN2-CSFreeUsage:ra3.4xlarge     APS1-CS:ra3.16xlarge             APS2-Node:dw.hs1.8xlarge         CAN1-CS:ra3.xlplus               CSFreeUsage:ra3.4xlarge          EU-RMS:ra3.4xlarge               EUN1-Node:dc2.8xlarge            EUW2-DataScanned                 EUW3-RMS:ra3.xlplus              RMS:ra3.4xlarge                  UGE1-DataScanned                 UGW1-Redshift:PaidSnapshots      USE2-RMS:ra3.16xlarge            USW2-CSFreeUsage:dc2.8xlarge     
APN1-CS:ra3.4xlarge              APN2-CSFreeUsage:ra3.xlplus      APS1-CS:ra3.4xlarge              APS2-Node:dw.hs1.xlarge          CAN1-CSFreeUsage:ra3.16xlarge    CSFreeUsage:ra3.xlplus           EU-RMS:ra3.xlplus                EUN1-Node:dc2.large              EUW2-Node:dc2.8xlarge            Global-Node:dc2.large            RMS:ra3.xlplus                   UGE1-Node:dc2.8xlarge            UGW1-RMS:ra3.16xlarge            USE2-RMS:ra3.4xlarge             USW2-CSFreeUsage:dc2.large       
APN1-CS:ra3.xlplus               APN2-DataScanned                 APS1-CSFreeUsage:ra3.16xlarge    APS2-Node:dw2.8xlarge            CAN1-CSFreeUsage:ra3.4xlarge     EU-CS:dc2.8xlarge                EUC1-CS:ra3.16xlarge             EUN1-Node:ds2.8xlarge            EUW2-Node:dc2.large              Global-Node:dw2.large            SAE1-CS:ra3.16xlarge             UGE1-Node:dc2.large              UGW1-RMS:ra3.4xlarge             USE2-RMS:ra3.xlplus              USW2-CSFreeUsage:ds2.8xlarge     
APN1-CSFreeUsage:dc2.8xlarge     APN2-Node:dc2.8xlarge            APS1-CSFreeUsage:ra3.4xlarge     APS2-Node:dw2.large              CAN1-CSFreeUsage:ra3.xlplus      EU-CS:dc2.large                  EUC1-CS:ra3.4xlarge              EUN1-Node:ds2.xlarge             EUW2-Node:ds2.8xlarge            MES1-CS:dc2.8xlarge              SAE1-CS:ra3.4xlarge              UGE1-Node:ds2.8xlarge            UGW1-RMS:ra3.xlplus              USW1-CS:ra3.16xlarge             USW2-CSFreeUsage:ds2.xlarge      
APN1-CSFreeUsage:dc2.large       APN2-Node:dc2.large              APS1-DataScanned                 APS2-Node:ra3.16xlarge           CAN1-DataScanned                 EU-CS:ds2.8xlarge                EUC1-CSFreeUsage:ra3.16xlarge    EUN1-Node:dw.hs1.8xlarge         EUW2-Node:ds2.xlarge             MES1-CS:dc2.large                SAE1-CS:ra3.xlplus               UGE1-Node:ds2.xlarge             USE1-DataScanned                 USW1-CS:ra3.4xlarge              USW2-CSFreeUsage:ra3.16xlarge    
APN1-CSFreeUsage:ds2.8xlarge     APN2-Node:ds2.8xlarge            APS1-Node:dc2.8xlarge            APS2-Node:ra3.4xlarge            CAN1-Node:dc2.8xlarge            EU-CS:ds2.xlarge                 EUC1-CSFreeUsage:ra3.4xlarge     EUN1-Node:dw.hs1.xlarge          EUW2-Node:dw2.8xlarge            MES1-CS:ds2.8xlarge              SAE1-CSFreeUsage:ra3.16xlarge    UGE1-Node:ra3.16xlarge           USE2-CS:dc2.8xlarge              USW1-CS:ra3.xlplus               USW2-CSFreeUsage:ra3.4xlarge     
APN1-CSFreeUsage:ds2.xlarge      APN2-Node:ds2.xlarge             APS1-Node:dc2.large              APS2-Node:ra3.xlplus             CAN1-Node:dc2.large              EU-CS:ra3.16xlarge               EUC1-DataScanned                 EUN1-Node:dw2.8xlarge            EUW2-Node:dw2.large              MES1-CS:ds2.xlarge               SAE1-CSFreeUsage:ra3.4xlarge     UGE1-Node:ra3.4xlarge            USE2-CS:dc2.large                USW1-CSFreeUsage:ra3.16xlarge    USW2-CSFreeUsage:ra3.xlplus      
APN1-CSFreeUsage:ra3.16xlarge    APN2-Node:dw2.8xlarge            APS1-Node:ds2.8xlarge            APS2-Redshift:PaidSnapshots      CAN1-Node:ds2.8xlarge            EU-CS:ra3.4xlarge                EUC1-Node:dc2.8xlarge            EUN1-Node:dw2.large              EUW2-Node:ra3.16xlarge           MES1-CSFreeUsage:dc2.8xlarge     SAE1-CSFreeUsage:ra3.xlplus      UGE1-Redshift:PaidSnapshots      USE2-CS:ds2.8xlarge              USW1-CSFreeUsage:ra3.4xlarge     USW2-DataScanned

Attribute Name: vcpu
Values:

12
16
2
32
36
4
48

We hope the above list of attribute names and values helps when using the AWS Price List API for Amazon Redshift.

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

Related Posts:

Sai Sci Tech

, , , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *