Analytic Agility with Aginity
Rating: 9 out of 10
IncentivizedUse Cases and Deployment Scope
Our business intelligence department all use Aginity to access our RedShift data. Our analyst team uses the tool to generate reports and run analysis on our data warehouse which lives in Amazon RedShift. Our business intelligence engineering team uses Aginity to perform some of the RedShift operational tasks and to validate data within the data warehouse.
Pros
- Query auto-completion
- Database exploration including schemas, tables, columns, distribution keys, sort keys, etc.
- Common scenario query samples, and easy access to table DDL
- Table size operational report
- Free community edition
Cons
- It would be helpful if the table size report could make it more obvious which tables need to be vacuumed. You can figure it out with the report, but can't just glance down a list.
- Error message windows often auto close before you can read them leaving me hovering my finger over the print screen trying to capture them.
- The auto-complete feature is a bit finicky. Many common scenarios which happen while writing a query by hand such as an unclosed parenthesis can cause the auto-complete not to trigger.
Likelihood to Recommend
Aginity is well suited for writing ad-hoc queries and data analysis, having all of the features that data analysts come to expect in a database querying tool. Aginity is also great for basic operation and management allowing an engineer or DBA to store multiple databases and credentials, see how tables are distributed or sorted, and see table sizes and row counts. However, for more advanced database management another tool or the RedShift console is still required.
JS
Jordan Squire
Business Intelligence Engineer in Engineering at Experticity (Marketing and Advertising, 201-500 employees)
Vetted Review
2 years of experience