Great value for the money
July 25, 2022

Great value for the money

Scott Kennedy | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User

Overall Satisfaction with Amazon Athena

We use Amazon Athena to overlay a bunch of direct-to-consumer click stream data. The most common queries are looking at attribution analysis. Things like first touch attribution versus last touch attribution. The data volume is significant and we needed an easy way to pull insights from our data stores and hand them back to the marketing business side users. At the end of the day, SQL is a very popular language to use for 99% of data problems.
  • The most obvious, is you can use SQL programming language, which a lot of people understand.
  • You can scale up to meeting higher processing times.
  • The data return speed (query speed) is great.
  • Every dialect of SQL has some missing functions. I wish there was automated GROUP BY options here.
  • There are connection problems back to Power BI occasionally.
  • If you don't watch certain queries, it's possible that it takes a long time to run and charges you a lot of money.
  • The query speeds help us make more decisions in a day (speed).
  • If you need more horsepower for specific times in the day this option helps scale.
  • The security of your environment is well protected too.
  • Azure Synapse Analytics (Azure SQL Data Warehouse)
Amazon Athena, a product from Amazon, competes with offerings from Google and Microsoft. Overall, I think your database choice depends on some of the other applications you are running at your company. For example, if you are using Microsoft Power BI for reporting needs, you might want to consider going the Azure route.

Do you think Amazon Athena delivers good value for the price?

Yes

Are you happy with Amazon Athena's feature set?

Yes

Did Amazon Athena live up to sales and marketing promises?

Yes

Did implementation of Amazon Athena go as expected?

Yes

Would you buy Amazon Athena again?

Yes

Azure SQL Database, Azure Synapse Analytics (Azure SQL Data Warehouse), Microsoft Power BI
If you are looking to take a lot of the traditional "database administration" work off someone's plate, going with Amazon Athena certainly has "no code" options to optimize lots of database tasks. I would say this option is less appropriate if you have other Microsoft things at play, such as Power BI.

Amazon Athena Feature Ratings

Automatic software patching
7
Database scalability
7
Automated backups
8
Database security provisions
8
Monitoring and metrics
8
Automatic host deployment
8