Aginity Workbench for Redshift provides new functionality and improvements in stability and quality of the software over previous versions. These release notes summarize the new features and changes that apply to version 4.5.
What's New? (Also See Full List of Changes)
This section provides information about the main new features in version 4.5.
- You can now bring code snippets from one Workbench into another by exporting them to a file and then importing them into a destination Workbench.
- During import of large files, in addition to the first 1,000 rows in the file being analyzed by default, you have the option of analyzing more or all of the rows to have Workbench adjust their data types and column lengths.
- During import, you have additional options for specifying what to do if the destination table exists.
This section contains details of specific functions and changes that are included in Aginity Workbench 4.5.
Upgrading from Prior Versions
Workbench automatically checks for new updates and displays a dialog box if an update is available. In the dialog box, select Install this update now to download and install the update.
You can also choose to postpone installation of the update until the next time you run Workbench or suppress the update alert.
You can also check for updates manually by clicking Check for Updates on the Help menu and then install an available update by following the instructions in a wizard.
- Windows XP or later
- Windows Installer 3.1
- .NET Framework 3.5 SP1
- Memory: 256 MB RAM
- Disk space: 100 MB, plus any necessary space for .NET Framework and Windows Installer
|WPD-445||You can export and import code snippets.|
|WPD-429||During import of a large file, as well as having the first 1,000 rows in the file analyzed by default, you can choose to analyze more rows.|
|WPD-127||During import, you have additional options to specify what to do with an existing destination table.|
Bug Fixes in Build 220.127.116.119
|Severity||Reference||Description||Existed Since Version||Resolution|
|Major||WPD-327||Scripting the DDL for a table with a column of TIMESTAMP datatype produces invalid syntax.||4.4||Fixed.|
|Major||WPD-564||Database object search fails with an error "ERROR: 42846: UNION/INTERSECT/EXCEPT could not convert type character varying to 'char'" on Redshift when a user searches entity names, entity bodies, or entity descriptions.||N/A|
|Major||WPD-542||After a user generates DDL for a table with interleaved sort keys, Workbench incorrectly shows the number of sort keys in the Sort Keys node in the Object Browser or generates an error when the user attempts to expand the node.||Manually update the generated DDL with the correct keys.|
|Moderate||APD-4093||Import of a file from the S3 file explorer fails because invalid data types are set for the columns in the file.||Set all column data types as VARCHAR and re-import the file.|
|Moderate||APD-3788||The Abort feature in Redshift Workbench does not terminate a query that is currently running.||Use the SQL at http://docs.aws.amazon.com/redshift/latest/dg/r_CANCEL.html to find the process ID of the running query and cancel it.|
|Minor||APD-4090||If you begin a download using a file system explorer (such as Amazon S3) and abort the download, a small portion of the file remains on your target system.||Manually delete the file on your target system.|
|Trivial||APD-3711||When the field type is Date, the year 0 (for example, 0000-01-01) causes an error “Year, Month, and Day parameters describe an un-representable DateTime.”||Either cast the date as a VARCHAR or do not use the year 0.|