Exasol
Exasol Tested for version 6.0+
Overview JDBC Drivers Features Supported Objects Download

Exasol

Exasol object type support.

The following table shows the database specific support in DbVisualizer for Exasol 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 TypeActionsViewers
Image Image Schemas
 Create Schema Schema sizes, Schemas
Image Image Schema
 Export Schema[2], Alter quota of Schema[1], Change owner of Schema, Comment Schema, Drop Schema, Grant Privileges, Rename Schema, Revoke Privileges Grants, Info, Schema size, Table Sizes
Image Image Tables
 Create Table[2], Import Table Data[2] References, Tables
Image Image Table
 Alter Table[2], Export Table[2], Import Table Data[2], Script: Script Table, Comment Table, Drop Table, Empty Table, Grant Privileges, Rename Table, Reorganize Table, Revoke Privileges Navigator[2], References, Data, Columns, Constraints, DDL[2], Distribution, Distribution Keys, Grants, Indices, Info, Primary Key, Row Count, Size
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Constraints
   Constraints
Image Image Constraint
 Enable/Disable Constraint Constraint Columns, Info
Image Image Views
   Views
Image Image View
 Export View[2], Script: Script View, Drop View, Grant Privileges, Rename View, Revoke Privileges Data, Columns, DDL[2], Dependencies, Grants, Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image Functions
 Create Function Functions
Image Image Function
 Export Function[2], Script: Script Function, Comment Function, Drop Function, Grant Privileges, Revoke Privileges Function Editor[2], Grants, Info
Image Image Scripts
   Scripts
Image Image Adapters
 Create Adapter Adapters
Image Image Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
Image Image LUA Scripting
 Create Script LUA Scripting
Image Image Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
Image Image UDFs
 Create UDF with EMIT, Create UDF with RETURN UDFs
Image Image Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
Image Image Virtual Schemas
   Virtual Schemas
Image Image Virtual Schema
 Change owner of Virtual Schema, Comment Virtual Schema, Drop Virtual Schema, Grant Privileges, Refresh Virtual Schema, Rename Virtual Schema, Revoke Privileges DDL, Grants, Info, Properties
Image Image Tables
 Create Table[2], Import Table Data[2] References, Tables
Image Image Virtual Table
 Export Table[2], Script: Script Table Data, Columns, DDL[2], Info, Row Count
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image System Schemas
   System Schemas
Image Image System Schema
    
Image Image System Tables
   Tables
Image Image System Table
   Data
Image Image Columns
   Columns
Image Image Column
 Comment Column Column
Image Image DBA
 Flush statistics DBA
Image Image Users
 Create User LDAP[3], Create User[3] Users
Image Image User
 Change LDAP Distinguished Name [3], Change Password, Comment User[3], Drop User[3], Grant Consumer Group to User, Grant Priority Group to User[4], Grant Role to User[3], Grant System Privilege to User[3], Rename User[3], Revoke Role from User[3], Revoke System Privilege From User[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Image Image Roles
 Create Role[3] Roles
Image Image Role
 Comment Role[3], Drop Role[3], Grant Consumer Group to Role, Grant Priority Group to Role[4], Grant Role to Role[3], Grant System Privilege to Role[3], Rename Role[3], Revoke Role from Role[3], Revoke System Privilege From Role[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Image Image User
 Change LDAP Distinguished Name [3], Change Password, Comment User[3], Drop User[3], Grant Consumer Group to User, Grant Priority Group to User[4], Grant Role to User[3], Grant System Privilege to User[3], Rename User[3], Revoke Role from User[3], Revoke System Privilege From User[3] Granted Connections, Granted Object Privileges, Granted Roles, Granted System Privileges, Info, Owned Schemas
Image Image Consumer Groups[5]
 Create Consumer Group[3] Consumer Groups
Image Image Consumer Group
 Alter Consumer Group[3], Comment Consumer Group[3], Drop Consumer Group[3], Rename Consumer Group[3] Info, Users and Roles
Image Image Priority Groups
 Create Priority Group[1] Priorities
Image Image Priority
 Alter Weight[1], Comment Priority Group[1], Drop Priority Group[1], Rename Priority Group[1] Info, Users and Roles
Image Image Connections
 Create Connection[6] Connections
Image Image Connection
 Alter Connection[7], Comment Connection[6], Drop Connection[8], Grant Connection[9], Rename Connection[7], Revoke Connection[9] Connection, Grantees
Image Image Auditing[10]
 Flush statistics Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week, Recent Queries
Image Image DB Size
 Flush statistics Database size daily[2], Database size last day[2], Database size monthly[2]
Image Image Usage
 Flush statistics Usage daily[2], Usage hourly[2], Usage last hour[2], Usage monthly[2]
Image Image Clusters
   Clusters
Image Image Cluster
    
Image Image Monitoring
 Flush statistics  
Image Image Monitoring Last Hour
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Image Image Monitoring Hourly
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Image Image Monitoring Daily
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Image Image Monitoring Monthly
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Image Image SQL Statistics
    
Image Image Statistics Hourly
   CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
Image Image Statistics Daily
   CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
Image Image Statistics Monthly
   CPU AVG[2], CPU MAX[2], Count[2], Duration AVG[2], Duration MAX[2], HDD Read AVG[2], HDD Read MAX[2], HDD Write AVG[2], HDD Write MAX[2], Network AVG[2], Network MAX[2], Temp DB RAM Peak AVG[2], Temp DB RAM Peak MAX[2]
Image Image System
   General, Parameters, Storage Volumes, System Events
Image Image Locks
   Transaction conflicts
Image Image Sessions
   Sessions
Image Image Session
 Kill Session[3], Kill Statement in Session[3] Audit Queries of Session[10], Info
[1] Version 6.1 and later and superuser
[2] DbVisualizer Pro
[3] Must be superuser
[4] Version 6 and earlier
[5] Version 7 and later
[6] Requires 'Create Connection' privilege
[7] Requires 'Modify Connection' privilege
[8] Requires 'Drop Connection' privilege
[9] Requires 'Grant Connection' privilege
[10] Requires 'Select Any Dictionary' privilege