Amazon Athena vs. Redash

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.

Incentivized

Redash is well suited to situations where metrics are tracked on daily, weekly and monthly basis. Alerts can be set to emails which helps stakeholders to monitor performance on a frequent basis. It is less appropriate for cases where only dashboards are needed. Redash comes into picture where individuals can query and check data at the same time.

• Nested Schemas like JSON data structure
• Ability to adapt the data model to fit your queries better
• Performance Improvement

Incentivized

• Great Query Editor with Autocomplete feature
• Very easy to setup and quickly connect to variety of data sources
• Quick Dashboards with Simple UI which can be easily shareable

Incentivized

• Response caching can be improved.
• Data Partitioning is tricky and understanding of the same could be improved.

Incentivized

• You need to have a good command over SQL to use Redash but if there could be some way where people can just pull data and do slice dice.
• It would be nice to have an excel kind of filters when all data is fetched.
• Some things like easy to customise the column names.

Incentivized

Easy to use. Scalable. Gets the job of data warehousing setup done. Using the datalake on S3 has become super convenient.

Incentivized

Incentivized

I was not a part of the decision-making team who decided to go with Redash.

Incentivized

• 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.

Incentivized

• Cost effective
• One tool for multiple purpose
• Easy access provision