▶ Upcoming Webinar Aqua Data Studio Enterprise Ultimate Register Now →
Free Trial
Request Demo
Screenshot of Aqua Data Studio version 15.0.0 showing a SQL script editor connected to an Oracle 12c database (ORCL). The editor contains a SQL script to create a table SYS.ACCESS$ with several columns and storage configurations. The left panel displays the database schema, listing tables, columns, constraints, dependencies, and other objects. A right-click context menu is open for the table SYS.ACCESS$, with options for creating, altering, dropping, and editing the table, as well as generating scripts (Script Object to Window As). The interface provides tools for database management and scripting.

Greenplum Database Management Tool

Aqua Data Studio provides a management tool for the Greenplum relational database with administration capabilities and a database query tool.

Start For Free

Aqua Data Studio form Greenplum

The visual administration features provide users the ability to browse and modify database structures, including schema objects and database storage, as well as maintain database security. An integrated query tool allows you to quickly create, edit and execute SQL queries and scripts. Aqua Data Studio further provides import and export tools to move data easily both in and from different data formats, as well as in and out of the Greenplum database.

Greenplum Database Toolkit

Visual Analytics
Fluid Shell
Query & Analysis Tool
Grid and Pivot Charts
Integrated Secure Shell (SSH)
Import & Export Tools
Entity Relationship Modeler
Visual Query Builder

Version Control Clients

Subversion (SVN), Git CVS Perforce

Table Data Editor
Open API Scription Environment
SQL History

Aqua Data Studio Greenplum Administration Tools Include:

Greenplum1 Instance Manager

Provides GUI view and search access for:

  • Instance Summary (Server Component, Value, Group, Description, Extra Info, Context, Type, Source)
  • Segments Summary

Greenplum Session Manager

Provides GUI view and search access for:

  • Session Details with current statement, Kill Session
  • Session Statistics
  • Session Locks
  • Session Grouping (By Process ID, Auth ID, and more)

Greenplum Storage Manager

Provides GUI view and search access for:

  • Tree View for Tablespaces, Databases, Device Usage, Location
  • Tablespace Properties and Details
  • Properties of Databases, Device Usage, Default Tablespace
  • Table, Index Storage View

Greenplum 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

  1. ^ Pivotal Greenplum Database Wikipedia article. Greenplum is built on PostgreSQL and operates as a data warehouse and uses a shared-nothing, massively parallel processing (MPP) architecture, available under the terms of the GNU General Public License, owned by Pivotal.
    Greenplum Wikipedia article.
Ads Logo in White
Purchasing
Customer
Company

Join our mailing list

Copyright © 2001 – 2026 Aqua Data Studio, Inc. All rights reserved.