I use Amazon Athena in my day-to-day work for our project. What I like most about Athena is that it can query large datasets directly from Amazon S3 without having to manage any infrastructure. In my workplace, I use Athena regularly to validate processed data after Spark ETL jobs complete, and I compare source and target datasets with the help of Athena. After the ETL pipelines finish writing Parquet or CSV files into S3, I use Athena tables connected through the AWS Glue Data Catalog, then run SQL queries to verify record counts, null values, duplicates, partitioned data, and transformation outputs. Review collected by and hosted on G2.com.
I don’t have any major dislikes. It’s a good final product, and it helps me a lot. Review collected by and hosted on G2.com.