▶ Upcoming Webinar Aqua Data Studio Enterprise Ultimate Register Now →
Free Trial
Request Demo
Screenshot of Aqua Data Studio version 15.0.0 connected to a Vertica database. The SQL editor displays an ALTER TABLE statement for modifying the Categories table in the public schema, including operations like altering column defaults and data types. The left panel shows the database hierarchy, listing various schemas and their corresponding tables and columns. A context menu for the public.Categories table is open, showing options like Script Object to Window As, with sub-options for CREATE, ALTER, and DROP. This illustrates Aqua Data Studio’s capabilities for table modification and script generation in a Vertica database.

Vertica Database

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

Start For Free

Aqua Data Studio for Vertica Database Tool

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 Vertica database.

Vertica 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 Vertica Administration Tools Include:

Vertica1 Instance Manager

Provides GUI view and search access for:

  • Instance Summary (Database State, Value)
  • Configuration Parameters
  • Session Parameters
  • Nodes Details
  • Query History (DDL, Query, UTILITY SQL executed on Server within Last 1/3/6/12/24 hours,3 days,1/2 weeks,Custom)

Vertica Session Manager

Provides GUI view and search access for:

  • Session Details, Kill Session
  • Session Statistics
  • Session Locks
  • Session Grouping (By Session ID, Client PID, and more)

Vertica Storage Manager

Provides GUI view and search access for:

  • License Audit (Database Name, License Size (MB) etc.)
  • Server Nodes (Node Name, IP Address etc.)
  • Storage View of Table, Column and Projection
  • File System Information (Node Name, IP Address etc.)

Vertica Security Manager

Provides GUI view and search access for:

  • Tree View for Users, Roles, Profiles
  • Users View, Create, Alter, Drop
  • Roles View, Create, Alter, Drop
  • Profiles View, Create, Alter, Drop

References

  1. ^ Vertica Database Wikipedia article. Vertica is a grid-based, column oriented data warehousing product.
    Hewlett-Packard Wikipedia article.
Ads Logo in White
Purchasing
Customer
Company

Join our mailing list

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