Aginity Workbench for Redshift 4.9 Release Notes

These release notes summarize the changes in Aginity Workbench for Redshift version 4.9. The release notes also contain system requirements and list the known issues with the release.

What's New? (Also See Full List of Changes)

Aginity Workbench version 4.9 contains the following new features.

Support of the Amazon Redshift ODBC Driver

You can now make an ODBC connection to your Redshift database using the Amazon Redshift ODBC driver. The use of the Redshift ODBC driver allows you to choose from the following types of authentication for your connection:

  • Amazon Web Services (AWS) profile
  • AWS Identity and Access Management (IAM) credentials
  • Single sign-on credentials (SSO) using one of the supported SAML 2.0 identity providers (if SSO is configured in your organization)
  • Standard authentication (a Redshift database user and password)

For instructions on how to download and install the Amazon Redshift ODBC driver, see the Amazon Redshift documentation. After you install the driver, depending on your version of Windows, select Amazon Redshift (x64) ODBC or Amazon Redshift (x32) ODBC in the driver list, in the lower-left corner of the database connection dialog box. To specify an authentication type for your connection, click Advanced, select the authentication type, and provide values for the required authentication properties.

Uploads to S3 Buckets with AWS KMS Encryption

When uploading data to your Amazon S3 bucket in the built-in S3 file explorer in Workbench, you can specify AWS KMS encryption for the data. Amazon S3 will encrypt each object with a unique key before it is saved to the bucket and decrypt it for you when you download it. For more information about AWS KMS encryption, see the documentation for the AWS Key Management Service.

You can also select AES-256 encryption or the default encryption (the one that is set for the bucket) for your uploads.

S3 Enhancements

The following changes were made to the Amazon S3 connection dialog box to enhance your S3 browsing experience:

  • Region Endpoint - Select the region to use in connecting to Amazon S3 and getting information about the regions of the buckets that you want to work with. We recommend that you select the region of one of the buckets in your AWS account. When connected to Amazon S3, you can open a bucket in the S3 file explorer.
  • Delimiter - You can specify a delimiter to override the default delimiter (/). The specified delimiter will be used in building a logical folder structure from the objects in your bucket and in creating or modifying objects in the S3 file explorer.

Technical Details and Changes

This section contains details of specific functions and changes that are included in Aginity Workbench 4.9.

Upgrading from Prior Versions

You can check for updates in Aginity Workbench manually by clicking Check for Updates on the Help menu and then install an available update by following the instructions in a wizard.

System Requirements

  • Windows XP or later
  • Windows Installer 3.1
  • .NET Framework 4.6.1
  • Memory: 256 MB RAM
  • Disk space: 100 MB, plus any necessary space for .NET Framework and Windows Installer

Full List of Changes Since Aginity Workbench 4.8

Bug Fixes in Build 4.9.3.2783

Severity Reference Description Existed Since Version Resolution
Major WPD-1168 After upgrading to Aginity Workbench version 4.9 (build 4.9.3.2778), users encounter errors when they attempt to make a connection to a Redshift database.   4.9.3 Users can now successfully connect to a Redshift database.
Moderate WPD-1174 The Show tables size feature works incorrectly. The Schema list displays multiple identical schemas. When a user selects a specific schema, no table metadata is shown. 

 4.8

The Show tables size feature works correctly.
Moderate WPD-1175 The autocomplete feature works on table names, but doesn’t work on columns.

4.8

The autocomplete feature now correctly displays a list of the columns from a selected table. 
Moderate WPD-1173 After upgrading to Aginity Workbench version 4.9 (build 4.9.3.2778), when a user runs a query that returns no rows (such as DROP, CREATE, or COMMIT), an empty result set tab is created. 4.9.3 A result set tab is correctly not created for such queries. 

Bug Fixes in Build 4.9.3.2778

Aginity Workbench version 4.9.3 contains the following bug fixes.

Severity Reference Description Existed Since Version Resolution
Moderate WPD-854 The S3 file explorer does not show the subfolders accessible to a user according to a bucket policy attached to the user in AWS Identity and Access Management (IAM). 4.7 To have the Aginity Workbench S3 file explorer show the accessible folders in the bucket to a user according to the user's S3 bucket policy, you need to perform the following actions in both IAM and the S3 file explorer.

IAM

Make sure that:

  • The S3 bucket policy for the user contains the s3:ListBucket permission to allow listing the appropriate objects with a delimiter (for example a slash). You may also need to add the StringEquals condition with the ForAllValues prefix to the Condition block, as shown in this example:

    {
    "Sid": "AllowListingBucketFolder",
    "Effect": "Allow",
    "Action": "s3:ListBucket",
    "Resource": "arn:aws:s3:::MyBucket",
    "Condition": {
    "ForAllValues:StringEquals": {
    "s3:prefix": [
    ""
    ],
    "s3:delimiter": "/"
    }
    }
    }
  • The bucket policy explicitly denies listing without a delimiter. This is needed because of an S3 limitation.

Aginity Workbench S3 file explorer

  • When connecting to the bucket, clear the new Recursive directory access check box in the S3 dialog box. This will show all the top-level folders in the root of the bucket to the user, including the ones that are accessible to him or her according to the bucket policy.
  • In Aginity Workbench, selecting Recursive directory access specifies reading bucket objects without a delimiter.
  • If Recursive directory access is selected, a user that has access to only specific folders in the bucket according to his or her bucket policy will be denied access to the contents of the bucket in the S3 file explorer.
Minor WPD-855 A query from a table that contains a decimal column with a precision greater than 28 digits (the maximum allowed by the Aginity Workbench UI) fails with an error. 4.7 The issue is resolved with the use of the Amazon Redshift ODBC driver. The driver provides a string representation of such long decimal values, and the string values are shown in the Query Analyzer window. Long decimals of more than 28 digits are still not supported in the rest of the UI because of the underlying .NET platform limitations.
Minor WPD-824 When running a query from the pg_class system table in Redshift, a user gets an error "Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible'. Couldn't store <System.Byte[]> in relexternid Column." The cause of the issue is that by default Redshift does not support displaying results of a query on a column of aclitem[]. acl data type. 4.8 The issue is resolved with the use of the Amazon Redshift ODBC driver. Queries from the pg_class system table are now run successfully.
Trivial WPD-853 Although a user specifies in the result set options a number of rows to return by a query that is greater than 100,000, Workbench returns a maximum of 100,000 rows. 4.7 The maximum limit that a user can set on the number of rows to return by a query is 100,000. On-screen text was added next to the relevant result set option explicitly stating this limit.

Bug Fixes in Build 4.9.1.2686

Aginity Workbench version 4.9.1 contains the following bug fixes.

Severity Reference Description Existed Since Version Resolution
Moderate APD-15391 The User ID field is not visible on the connection dialog box after a user changes the 100% display setting to a larger setting. 4.7 The User ID field is visible on all display settings.
Minor APD-16045 The Discussion Forums menu item exists for the deprecated Aginity Forums. 4.7 The menu item was modified to go to the Aginity Community web forums.
Minor APD-16442 The Data Import Wizard opens without displaying some of the file information fields (such as the name of the file being imported and the file compression type) and on-screen instructional text. 4.8 The Data Import Wizard now properly displays the file information fields and instructional text.

Known Issues in Build 4.9.3.2783

Severity Reference Description Workaround
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 data types for the columns manually.
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.
Moderate WPD-680 Workbench generates invalid DDL when a user selects the Change Sort Keys command in the Object Browser. N/A
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.
Minor WPD-1182 The autocomplete feature does not display a list of columns from a table that has an alias in the FROM clause if the preceding query does end with a semicolon (;). Add a semicolon at the end of the preceding query.
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.
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