1 of 10 – Amazon Redshift – Instance Manager – Summary
2 of 10 – Amazon Redshift – Instance Manager – Query History
3 of 10 – Amazon Redshift – Security Manager – Tree
4 of 10 – Amazon Redshift – Security Manager – Users
5 of 10 – Amazon Redshift – Security Manager – Groups
6 of 10 – Amazon Redshift – Session Manager – Sessions
7 of 10 – Amazon Redshift – Session Manager – Session Stats
8 of 10 – Amazon Redshift – Session Manager – Locks
9 of 10 – Amazon Redshift – Storage Manager – Databases
10 of 10 – Amazon Redshift – Storage Manager – Objects
Amazon Redshift DBA Tools
Aqua Data Studio offers a suite of Amazon Redshift DBA Tools for the monitoring, maintaining and tuning of the Amazon Redshift server. It includes an Instance Manager, Storage Manager, Security Manager, and Session Manager. These managers allow the monitoring and maintenance of Database Objects, Sessions, Users and Permissions via GUI. A Query History view is also provided.
Aqua Data Studio Amazon Redshift Administration Tools Include:
Amazon Redshift1 Instance Manager
Provides GUI view and search access for:
- Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
- Query History with filtering on query type and date range
Amazon Redshift Session Manager
Provides GUI view and search access for:
- Session Details, Kill Session
- Session Statistics
- Session Locks
- Session Grouping (By Auth ID, Process ID, and more)
Amazon Redshift Storage Manager
Provides GUI view and search access for:
- Database View, Create, Drop
- Table, Storage View
Amazon Redshift Security Manager
Provides GUI view and search access for:
- Tree View for Users, Groups
- Users View, Create, Alter, Drop
- Groups View, Create, Alter, Drop
References
- ^ Amazon Redshift Wikipedia article. Amazon Redshift is a hosted data warehouse product which is part of the larger cloud computing platform Amazon Web Services.
- ^ Amazon Wikipedia article.