The performance greatly differs based on whether the data file is stored in say a simple text format or parquet format.
This gives an advantage to Spectrum, as we may allocate more resources whenever we want our queries to return results quicker, with Athena we don't have that control.Īnother factor that is important for performance is the format in which data is stored in S3.
Whereas Redshift Spectrum is part of RedShift Cluster, so the resources are allocated based on our Cluster size. So essentially we could store a large amount of data in S3 bucket, which is comparitevly cheaper than managed database stores, but we are only charged for the data which is queried.Īthena is a standalone service, so there are no other changes to consider, but since RedShift Spectrum is a subset of Amazon Redshift, its compute & cluster costs would also need to be considered.Īs Athena is a standalone AWS service and works using the resources allocated to it by AWS, we do not have much control over the performance. The current rates are $5 per TB data queried. The two services may be compared on following points :īoth the services costs around the same and is charged based on the amount of data queried from S3. Its a Serverless Service and was launched in 2016.īoth of these services looks similar, but there are quite a few differences which could lead to selecting one over the other based on the use cases and requirements.
All the SQL functionalites can be used when querying the data just like any other SQL table within Redshift Cluster.Īmazon Athena is a standalone SQL engine, that can be used to quey data stored in AWS S3. RedShift Spectrum is a part of Amazon Redshift Service, it was launched in 2017, and it allows the users to query data stored in S3, directly from Redshift query editor as if the data was stored in Redshift clusters itself. Redshift Spectrum and Athena are two very popular services in AWS, and provides the functionality of quering data stored in S3.
0 kommentar(er)
