The object menu allows you to access all of the functions associated with the objects described in the Object browser.  Select the object and then click on the desired command from the Object menu.



Server, Database and Table's functions of the Object menu can also be accessed by right clicking any object in the object browser and selecting any function from the drop-down menu. This process and functions are described on the Main window page. Please note, that commands are only shown in the menu if they are relevant to the object. Below is the description for all the functions.

Functions specific to Server type:

• Show Disk Usage - shows disk usage information grid (SPU ID, Total MB, Used MB, Disk Usage, etc.)
• Server monitor - allows server monitoring (GP States, Process, Disk Free Space, etc.)
• Open SSH terminal - opens a new window to connect to SSH terminal.
• Refresh - refreshes status of all servers in the object browser.

Functions specific to Database type:

• Refresh DB list - refreshes the list of all databases in object browser.
• Comment on Database - adds a comment for the selected database.
• Script Database - this option allows you to publish a sql command file with all of the necessary commands to completely rebuild your database structure.You can also customize which objects need should be included in the script.
• Show User Sessions - brings up a Session List window with a grid showing all users connected to the server.
• Show Query History - shows all executed queries history. This option also allows different setup parameters to be added to the displayed result.
• Show Tables Size* - brings up a new window with detailed description (i.e. Data and Processing Skew) of currently selected database tables (see more detailed description below.)
• View - changes databases view mode.
• Analyze DB Schema - performs various data checks including: uniqueness of data, referential integrity and bad table distribution (more detailed information on how to use the DB Schema tool is described on Tool Menu page.) 
• Analyze DB Data - performs analysis of the data table content in order to suggest improvements to the: nullability of fields that allow nulls, minimizing the row size by using minimum precision for columns and minimizing the size character columns.
• Groom Database - choose this option if you want to permanently delete the previously deleted records from the server.

*Database Space (Show Tables Size)
Aginity workbench provides users with useful information on database’s free and used space by different tables. The information is presented in a grid and a chart with multiple parameters to analyze, i.e.: data skew, blocks/bytes used, blocks/bytes allocated, etc. To view the grid and chart for the selected database, open Object menu >> Database >> and select Show Tables Size from drop-down menu. This opens Table Space window. You can also open the Table Space window by right-clicking the database and selecting Show Tables Size. You will find all of the columns’ names, charts’ descriptions and data representation in the tables to be user-friendly and easy to work with. For example, summary tab provides detailed information for all the tables in the selected database, but if you want to view the details for a single specified table – navigate to Detail by Table tab. Charts will depict the same information with the help of different graphical representations: rings, rectangles and bubble-shaped diagrams to choose from. 
Functions specific to Table:

• Refresh Table List - refreshes the list of tables for currently selected database.
• Script - generates basic select, insert, update and DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records, or duplicate records.
• Advanced - shows advanced options for selected table (Reclaim, Groom, Change Distribution, etc.).
• Charts - shows frequency distribution chart.
• Edit Comment - makes notes of changes and modifications. Comments are also available for table columns. They are editable via the Workbench and SQL queries.
• Refresh Columns - refreshes columns in the selected table.
• Show Distribution - visualizes how your data is distributed over the SPUs in your system.Data in blue is live data, red is data that has been deleted but is yet to be reclaimed.
• Show Storage - shows information on table's storage details by Table and Data Slice. 
• Import/Export Data - imports and exports table from/to external text files. It allows you to customize the operation around the way your data is formatted, including date, null, and binary formatting.

Functions specific to View:

• Refresh View List - refreshes view list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records.
• Charts - shows frequency distribution chart. The program will ask you to select a table column for frequency distribution plot.
• Create View - inserts 'Create or Replace View...' SQL command preset to new SQL editor window for fast and easy view creation.
• Edit View - inserts 'Create or Replace View...' SQL command to new SQL editor window with all the data from currently selected view.
• Edit Comment - allows to add/edit description of the selected view.
• Refresh columns - refreshes columns of the selected view.
• Export Data - opens 'Export Data' window, prompting the user to specify different parameters to export the view.

Functions specific to Sequence:

• Refresh Sequence List - refreshes sequence list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Edit Comment - allows to add/edit description of the selected sequence.

Functions specific to Stored Procedures:

• Refresh Stored Procedures List - refreshes external table list in the selected database.
• Script - generates select, insert statement or DDL commands to either be pasted to the query window or to your clipboard.
• Create Procedure - the Stored Procedure Properties window pops up. You can specify the new procedure’s name, language and arguments here.
• Edit Procedure  - allows you to edit any stored procedure.
• Edit Comment - allows to add/edit description of the selected procedure.

Functions specific to External Table:

• Refresh External Table List - refreshes external table list in the selected database.
• Script - generates select, insert statement or DDL commands to either be pasted to the query window or to your clipboard.
• Refresh Column  - refreshes columns of the selected external table.

Functions specific to Materialized View:

• Refresh Materialized View List - refreshes view list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• Data Review - executes a select script requesting the top 100 records, also can find duplicate records.

Functions specific to User Defined Functions:

• Refresh UDF list - refreshes user defined function list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDF - allows you to edit a the selected user-defined function.
• Edit Comment - allows to add/edit description of the selected user defined function.

Functions specific to User Defined Aggregates:

• Refresh UDA list - refreshes user defined aggregates list in the selected database.
• Script - generates select statement or DDL commands to either be pasted to the query window or to your clipboard.
• New - allows you to create a user-defined function. Fill in the 'Function Properties' form, click OK. 
• Edit UDA - allows you to edit the selected user-defined aggregates.
• Edit Comment - allows to add/edit description of the selected user defined aggregates.

Functions specific to Synonyms :

• Refresh synonym list - refreshes user defined aggregates list in the selected database
• Edit Comment - allows to edit comments for the selected synonym.
  

Data Upload
It's now possible to upload data into the database with the help of the Workbench. 

The workbench supports Data Upload (source file import) of the following formats: 

• Excel (both 2003 and 2007)
• CSV 
• Fixed-width columns text file 
• All above in an archive (zip, gzip, bzip2) 

Here are a few tips you might find useful to know to successfully import data from different formats. For instance: 

• Source selection is required if a file is open from an archive and the archive has more than one file in it.
• If there were more than one non-empty worksheet in the Excel file, choose the worksheet to operate on.
• A file from the archive has been selected, but its content type could not be guessed from the file extension. Ask user.

After the source file has been selected, the Data Import Wizard window will pop up. The wizard has 5 simple steps to follow. Below is the screen of the first step of the wizard and description of all five steps and their behavior. 



Step 1. Specify file encoding and field delimiter (applicable to CSV only) or column widths and file encoding (applicable to fixed-width columns file only). Click Next. 

Step 2. Select limit rows or columns: specify data range. Click Next.

Step 3. Select first row behavior and specify columns to include to output and their order. Click Next.

Step 4. Specify physical data types. Data types are auto-populated, but can be customized by checking the ‘Treat all columns as varchar’ check-box. Click Next.

Step 5. The final step will ask you to specify the target database and table name. Please note that Importing into an existing table is not supported at the moment. Click Finish. 

After all the steps have been completed – the newly created table with the data in it will appear in the object browser. If you can’t see the table make sure to refresh the object browser. 

 

Go up  |  Go To WorkBench Help page