Aginity Workbench for Redshift 4.3 Release Notes

These release notes summarize the features and bug fixes that apply to Aginity Workbench for Redshift version 4.3.

Highlights

Upgrading from Prior Versions

  1. Uninstall the previous Beta version of Aginity Workbench for Redshift.
  2. Download and install version 4.3 from the Aginity Workbench for Redshift Downloads page.

System Requirements

  • 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

Features

Reference Version Added Summary
336 4.3 An option for keeping connection open between executions.
6844 4.3 An option for ignoring SQL errors.
3776 4.3 As a Redshift WB user I want quick and easy access to query processing details.
5183 4.3 The Type column in the Output tab grid has a fixed width to prevent the column from automatically resizing during query execution.
5121 4.3 An option in the Database Connections dialog box to allow SSL connections to a Redshift server.

Bug Fixes in Build 4.3.1962

Severity Reference Description Resolution
Moderate 7129 Leading zeros in VARCHAR values are lost after export to Excel. Fixed.
Moderate 8090 When trying to execute an Explain SQL statement for a query from the server-side query history, a user gets an error. Fixed.
Minor 4021 Failure to copy files from the S3 file explorer to a local machine using a drag-and-drop operation. Fixed.
Minor 4022 Cannot drag and drop files from a local machine to the S3 file explorer. Fixed.

Known Issues in Build 4.3.1962

Severity Reference Description Workaround
Moderate 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 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 4090 If you begin a download using an explorer (such as SFTP or HDFS) and abort the download, a small portion of the file remains on your target system. Manually delete the file on your target system.
Minor 7285 During a SELECT statement, dates in the format “01-01-01” cause the error “One of the identified items was in an invalid format.” Use a WHERE clause to eliminate invalid rows or cast the date as VARCHAR.
Minor 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.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk