Database specific support for VerticaDatabase specific support for Vertica

The following table show the database specific support for Database specific support for Vertica organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object Type Actions Viewers
Schemas
Create Schema Schemas
Schema
Export Schema1, Analyze Workload For Schema2, Drop Schema, Rename Schema  
Tables
Create Table1, Import Table Data1 References, Tables
Table
Alter Table1, Export Table1, Import Table Data1, Analyze Stats for Table, Analyze Workload For Table2, Change Table Owner, Drop Table, Empty Table, Move Table to Schema, Refresh Projections, Remove Partitioning, Rename Table, Reorganize Table, Script: Script Table Navigator1, References, Columns, Constraints, DDL, Data, Grants, Info, Primary Key, Projection Storage, Row Count
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
ProjectionsTable
  Projections
Projection
Drop Projection, Rename Projection, Script: Script Projection Columns, DDL, Data, Partitions, Storage, Storage Containers
ProjectionsTable
  Projections
Projection
Drop Projection, Rename Projection, Script: Script Projection Columns, DDL, Data, Partitions, Storage, Storage Containers
GlobalTempTables
Create Table1, Import Table Data1 Tables
TempTable
Alter Table1, Export Table1, Import Table Data1, Analyze Stats for Table, Analyze Workload For Table2, Drop Table, Empty Table, Refresh Projection, Rename Table, Script: Script Table Columns, DDL, Data, Row Count
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
FlexTables3
Create Flex Table1 Tables
FlexTable
Alter Flex Table1, Analyze Stats for Table, Analyze Workload For Table2, Build View, Compute and Build View, Copy From, Drop Table, Empty Table, Refresh Projection, Rename Table, Script: Script Table Columns, DDL, Data, Map to String, Row Count
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
Views
  Views
View
Drop View, Rename View, Script: Script Table Navigator1, References, Columns, Constraints, DDL, Data, Row Count
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
ProjectionsSchema
  Projections
Projection
Drop Projection, Rename Projection, Script: Script Projection Columns, DDL, Data, Partitions, Storage, Storage Containers
Sequences
Create Sequence Sequences
Sequence
Drop Sequence, Rename Sequence, Script: Script Sequence Info
Functions
Create Function Functions
Function
Export Function1, Drop Function, Rename Function, Script: Script Function Function Editor1, Info
Libraries
Create Library2 Libraries
Library
Drop Library2, Set Library Filename2 Info
FactoryFunctions
  Factory Functions
FactoryFunction
  Info
UDX
  User Defined Extensions
UDXAggregates
Create Aggregate Function Aggregates
UDXAggregate
Drop Aggregate Function Info
UDXAnalytics
Create Analytic Function Analytics
UDXAnalytic
  Info
UDXFilters
Create Filter Function2 Filters
UDXFilter
Drop Filter Function2 Info
UDXFunctions
Create Function (UDF) Functions
UDXFunction
Drop Function (UDF) Info
UDXParsers
Create Parser Function2 Parsers
UDXParser
Drop Parser Function2 Info
UDXSources
Create Source Function2 Sources
UDXSource
Drop Source Function2 Info
UDXTransforms
Create Transform Function Transforms
UDXTransform
Drop Transform Function Info
UDXOthers
  Other
UDXOther
  Info
Procedures
Create Procedure Procedures
Procedure
Drop Procedure  
SystemSchemas
   
SystemSchema
   
SystemTables
  Tables
SystemTable
  Data
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
LocalTempTables
Create Table4, Import Table Data1 Tables
TempTable
Alter Table1, Export Table1, Import Table Data1, Analyze Stats for Table, Analyze Workload For Table2, Drop Table, Empty Table, Refresh Projection, Rename Table, Script: Script Table Columns, DDL, Data, Row Count
Columns
  Columns
Column
Analyze Stats for Column Column, Statistics
DBA
  DBA
Databases
  Databases
Database
Analyze Stats for Database, Analyze Workload For Database2, Export Statistics2, Refresh Projections Info
Users
Create User2 Users
User
Alter User2, Change Password, Drop User2 Info, Passwords
Roles
Create Role2 Roles
Role
Drop Role2, Rename Role2  
User
Alter User2, Change Password, Drop User2 Info, Passwords
Profiles
Create Profile2 Profiles
Profile
Alter Profile2, Drop Profile2 Info
User
Alter User2, Change Password, Drop User2 Info, Passwords
RecentQueries
  Long Queries, Recent Queries
System
  Session Settings, System, System Settings
Locks
  Locks
Sessions
  Sessions
Session
Close Session2 Info
License
Audit License Size2, Audit License Term2 License Audits, License Compliance, Licenses
Streams
  Load Streams
TupleMover
Run Tuple Mover on Projection2, Run Tuple Mover on Table2 Tuple Mover Operations
TuningRecommendations
  Tuning Recommendations
Nodes
  Nodes
Node
  Disk Resource Rejections, Disk Storage, Host Resources, Info, Node Resource Usage, Node Resources
SchedulerJobs
  Resource Pools
SchedulerJob
  Info, Queues, Rejections, Status
1) DbVisualizer Pro
2) Must be superuser
3) Version 7 and later
4) Single Physical Connection must be enabled