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
Schemas
 Create Schema Schema sizes, Schemas
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
Tables
 Create Table[2], Import Table Data[2] References, Tables
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
Columns
   Columns
Column
 Comment Column Column
Constraints
   Constraints
Constraint
 Enable/Disable Constraint Constraint Columns, Info
Views
   Views
View
 Export View[2], Script: Script View, Drop View, Grant Privileges, Rename View, Revoke Privileges Data, Columns, DDL[2], Dependencies, Grants, Info, Row Count
Columns
   Columns
Column
 Comment Column Column
Functions
 Create Function Functions
Function
 Export Function[2], Script: Script Function, Comment Function, Drop Function, Grant Privileges, Revoke Privileges Function Editor[2], Grants, Info
Scripts
   Scripts
Adapters
 Create Adapter Adapters
Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
Scripting
 Create Script LUA Scripting
Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
UDFs
 Create UDF with EMIT, Create UDF with RETURN UDFs
Script
 Export Script[2], Comment Script, Drop Script, Grant Privileges, Revoke Privileges Script Editor[2], Grants, Script
VirtualSchemas
   Virtual Schemas
VirtualSchema
 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
Tables
 Create Table[2], Import Table Data[2] References, Tables
VirtualTable
 Export Table[2], Script: Script Table Data, Columns, DDL[2], Info, Row Count
Columns
   Columns
Column
 Comment Column Column
SystemSchemas
   System Schemas
SystemSchema
    
SystemTables
   Tables
SystemTable
   Data
Columns
   Columns
Column
 Comment Column Column
DBA
 Flush statistics DBA
Users
 Create User LDAP[3], Create User[3] Users
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
Roles
 Create Role[3] Roles
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
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
ConsumerGroups[5]
 Create Consumer Group[3] Consumer Groups
ConsumerGroup
 Alter Consumer Group[3], Comment Consumer Group[3], Drop Consumer Group[3], Rename Consumer Group[3] Info, Users and Roles
Priorities
 Create Priority Group[1] Priorities
Priority
 Alter Weight[1], Comment Priority Group[1], Drop Priority Group[1], Rename Priority Group[1] Info, Users and Roles
Connections
 Create Connection[6] Connections
Connection
 Alter Connection[7], Comment Connection[6], Drop Connection[8], Grant Connection[9], Rename Connection[7], Revoke Connection[9] Connection, Grantees
RecentQueries[10]
 Flush statistics Audit Sessions last 24h, Audit by COMMAND_CLASS last week, Audit by USER_NAME/CLIENT last week, Recent Queries
DatabaseSize
 Flush statistics Database size daily[2], Database size last day[2], Database size monthly[2]
Usage
 Flush statistics Usage daily[2], Usage hourly[2], Usage last hour[2], Usage monthly[2]
Clusters
   Clusters
Cluster
    
Monitoring
 Flush statistics  
MonitoringLastDay
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringHourly
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringDaily
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
MonitoringMonthly
   CPU / Load[2], HDD / Network / SWAP[2], Temp DB RAM [MiB][2]
Statistics
    
StatisticsHourly
   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]
StatisticsDaily
   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]
StatisticsMonthly
   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]
System
   General, Parameters, Storage Volumes, System Events
Locks
   Transaction conflicts
Sessions
   Sessions
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
Cookie policy

We use cookies to ensure that we give you the best experience on our website. However you can change your cookie settings at any time in your browser settings. Please find our cookie policy here ↗