Overview of AWS Redshift Pricing
Amazon(AWS) Redshift Pricing/Cost varies depending on type of Redshift Cluster. AWS Redshift offers different node types depending on workloads. Following are the multiple types of Redshift Clusters
RA3 –
RA3 nodes with managed storage . Ideal for large workloads with large storage growth requirements. Compute and Storage is decoupled . You can Pause and Start the Compute and pay only during Cluster up time. Following is Pricing for 4 node Redshift cluster with ra3.4xlarge node type and 1 TB of Storage. Leader node is not charged
On Demand Pricing
Compute
| Node Type | Number | Instance Type | Per Hour($) | Per Month($) |
| Leader | 1 | ra3.4xlarge | $3.26 | 0 |
| Compute | 3 | ra3.4xlarge | $3.26 | $7139 |
Storage
| Storage (TB) | Per GB($) | Per Month($) |
| 10 | $0.02 | $240.00 |
Reserved Pricing (3 yr commitment with full upfront)
Compute
| Node Type | Number | Instance Type | Per Hour($) | Per Month($) |
| Leader | 1 | ra3.4xlarge | $0.41 | 0 |
| Compute | 3 | ra3.4xlarge | $0.41 | $891 |
Storage
| Storage (TB) | Per GB($) | Per Month($) |
| 10 | $0.02 | $240.00 |
Redshift Spectrum Pricing
With Redshift Spectrum, you can query on already existing S3 data files utilizing Spectrum nodes. You are charged for number of bytes scanned, rounded to the next MB with 10 MB minimum per query. Charges are $5 per TB of data Scanned.
For a S3 file with 10 TB of storage, running a query against this data file table will cost around , $5×10=$50. To reduce the costs, Implement compression which can cut down costs by around 60 to 70% depending on compression type.
Redshift Spectrum requires Redshift cluster to query the data and will get charged for the usage of Redshift cluster. Redshift Spectrum queries data directly in Amazon S3. You are charged standard S3 rates for storing objects in your S3 buckets, and for requests made against your S3 buckets.
With Amazon Redshift Serverless, there is no longer separate charge for Redshift Spectrum. It will be part of Amazon Redshift serverless cost measured in RPUs
Redshift Machine Learning (ML) Pricing
Redshift Machine Learning (ML) Pricing/Cost is based on the following components
- Training Cost – When you run CREATE MODEL statements, Amazon Redshift uses Amazon SageMaker for training. Therefore, there is an associated cost for training your model. This is a separate line item for Amazon SageMaker in your AWS bill. Its charged based on number of cells consumption
| Number of cells | Price |
| First 10M cells | $20 per million cells |
| Next 90M cells | $15 per million cells |
| Over 100M cells | $7 per million cells |
- Storage Cost – You also pay for the storage used in Amazon S3 for storing your training data.
- Inference Cost – Redshift ML provides model prediction capabilities as part of the query. Prediction functions that runs on Redshift cluster doesn’t incur additional charges.
Conclusion
Apart from above charges depending on your workload type, there can be additional charges for backup storage and data transfer.
You can also utilize AWS Redshift Pricing Calculator – https://aws.amazon.com/redshift/pricing/