Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
The Aqua Data Studio's version 18.5 release adds database enhancements for Apache Cassandra, Vertica, BigQuery and Netezza. For Visual Analytics we have improved the table calculation dialog, the open workbook processing and added support for a Label deck for bar charts.
In the Table Data Editor we have fixed the "Find and Replace" window and added an icon to identify non editable columns. We have enhanced the Export tool and enabled the SQL History Archive. New key bindings have been added to make your work more efficient. We have included some minor enhancements in the Visual Editing, Query Analyzer and Version Control tools.
Cassandra
Schema Tree column node and Detail column properties for Cassandra now have easily identifiable partition, clustering key icons. Learn more.
Cassandra has been enhanced to handle these new types- smallint, date, time, tinyint. Learn more.
Vertica
Database Schema and Data Exporter Aquascript now supports extraction of Vertica projections. Learn more.
Added support for Geospatial datatypes for Vertica 8.0.x and above in Visual Editor and ER Modeler. Learn more.
Added "Check" as a constraint option for Vertica 7.2 and above when creating a table using the Aqua Data Studio Visual Editor. Learn more.
BigQuery
BigQuery Standard SQL can now use the Table Data Editor feature in Aqua Data Studio. Learn more.
Netezza
Added the "Execute" option for Netezza Procedures when selecting the scripting menu from the Schema Tree. Learn more.
Calculation dialog
Improved the table calculation dialog by adding the ability to view the table calculation formula using the calculated field dialog. Learn more.
Open Workbook
Enhanced open workbook processing. Now opening workbooks with long query latency allows other Aqua Data Studio processing to proceed. Learn more.
Label Deck
Added support for a Label deck for bar charts. This allows dragging of dimension fields on to Label deck. Learn more.
Find and Replace window
Fixed the "Find and Replace" window in Table Data Editor window. It is now wide enough to display all of the buttons correctly. Learn more.
New icon for non editable columns
Added an icon identifying that a column is not editable makes editing with Table Data Editor easier. Learn more.
Aqua Data Studio Export
Enhanced the Aqua Data Studio Export tool to generate a separate tab in the output workbook with the query used to export the data. Learn more.
SQL History Archive
We now enable the SQL History Archive so that your SQL history is no longer deleted. Learn more.
New Key Mapping
Added Ctrl+Shift+MULTIPLY key mapping in the editors to turn on column block selection mode. Learn more.
New Key Mapping for Windows and Linux
Add Shift+Delete as an alternative key mapping for Windows/Linux as our default key binding for CUT. Learn more.
User Interface of Table Visual Editor
Enhanced the Table Visual Editor so that the constraints user interface is horizontally resizable making it easier to add a lot of constraints. Learn more.
Aggregate Bar
Added Median to the Query Analyzer Grid Results Aggregate Bar. Learn more.
We're excited to announce that we have completely opened up our development process. All defects and enhancements, documentation, discussions and knowledge bases are publicly accessible by anyone. Take a look at all enhancements and bug fixes in this release on our dashboard.