General

Main updates:

• Administrators can configure different database access for every team in one connection;
• Administrators and developers can grant database access to all users;
• Server configuration dialog was added to the desktop client.

Identity providers:

• AWS authentication now supports external role configuration.

Administration:

• Git configuration test button was added;
• AWS Secrets Manager integration was added for database credentials storage.

AI assistant:

• Added support for Google Gemini LLM;
• Updated the list of available OpenAI models.

New drivers

• Firestore;
• RisingWave.

Driver management: Added many improvements for BigQuery, ClickHouse, Dameng, DB2, DynamoDB, EDB, Firebird, Google Bigtable, Google Cloud SQL, Greenplum, Microsoft Access, MariaDB, MySQL, MongoDB, Oracle, PostgreSQL, Redis, Redshift, Salesforce, ScyllaDB, Snowflake, SQLite, SQL Server, Sybase, TDengine, and Teradata.
Access Management:

• Added the ability to automatically map Active Directory roles to specific Team Edition roles during user import;
• Administrators can include themselves in any teams.

 

Team Edition Web

Main updates:

• Have enhanced security for unauthorised access;
• Password policy for the local authorization was added. Password parameters can be set in the configuration file;
• Have added validation for mandatory fields in all forms to create and edit entities;
• Have added an ability to edit the default preferences of the following parts: interface, tools, and data viewer in the settings panel in the administrative part

Identity providers:

• Have added the ability to use the JWT Token from an external authentication system as a header in the reverse proxy for authentication;
• Have added the ability for administrator to configure reverse proxy settings, such as Username header, team delimiter symbol, logout redirect URL, team header, and others.

Query Manager:

• Have added a user IP field to the Query Manager.

Preferences:

• Have added the ability in the admin panel to disable copying in the Tables and Values panel for all users except the administrator;
• Have added the ability to disable alias autocomplete for all users.

Driver management:

• Have added the filter disabled / enabled drivers;
• ClickHouse Legacy driver has been removed to prevent potential vulnerability issues;
• Apache Derby driver has been removed because of the vulnerability issues;
• Azure Databricks (Legacy) has been permanently replaced with Azure Databricks;
• Have enhanced security of Snowflake, Duck DB, Neo4j, OpenSearch, HSQL Server connections
• New Dameng, Firestore and RisingWave drivers have been added;
• Have updated MariaDB driver to version 3.3.2;
• Oracle driver version has been updated to 23.2.0.0;
• Snowflake driver has been updated to version 3.14.4;
• SQLite driver has been updated to version 3.44.1.0.

Access Management:

• Have added the Auth Methods tab to the user form with information about all linked authentication methods;
• A default user group has been added to the product. This group includes all users which could not be deleted.

Connections:

• The ‘Keep alive’ option has been added to the connection settings to keep the connection active even in case of inactivity;

Data Editor:

• Have added the ability to view decoded binary-type data in the Value panel;
• The pie chart type has been added to visualise fractions or percentages;
• Have added the ability to display full text for a string data type in the Value panel;
• Text wrap is activated by default for texts and BLOBs in the Values panel for better visibility. The user can switch to the one-line mode using a button on the toolbar;
• Have added the ability to display the OpenStreetMap layer with the coordinate system ESPG 4326.

Resource management:

• Read-only scripts now have a padlock icon;
• Files exported from a dataset are saved with the dataset name.

 
Different bug fixes and enhancements have been made.  

Team Edition Desktop

New Google Firestore driver allows you to display collections and subcollections in the data grid, and edit database entities using metadata editor. You can connect to Firestore using Cloud Explorer.
SQL Editor:

• New SQL query highlighting and script validation were enabled by default
• Outline viewer of the SQL query structure was added.

AI enhancements:

• Google Gemini support was added.
• GPT-4 model was added, and legacy OpenAI models were removed.
• Chat mode was improved: AI comments representations and the ability to disable all comments were added, Chat mode interface and behavior were enhanced.

Data Editor: 

• Advanced paste was improved: ability to ignore quotes was added and the paste of multiple records was enhanced.
• Scrolling multiple tabs results was improved. You can scroll all result sets using Ctrl. 
• Filter and value selector panel were improved.

ER Diagrams: Orthogonal paths routing was significantly improved. Connection rendering was enhanced, bridges can be highlighted according to the selected column, and a separate presentation of vertical routes was added.
Metadata Editor:

• Primary/unique key can be created automatically along with new columns
• Object creation dialog was redesigned.

Data transfer:

• Multithreading support for multiple table export was added.
• Users can select any character as a delimiter when exporting in TXT format
• Configuration of exported columns has been improved. You can quickly select a single column for export.
• Many bug fixes and enhancements have been made.

Task management: 

• Users can change the file format in the saved task, for data export and data import.
• Variables support was added for the Composite tasks.

Accessibility: Notifications can be read with a screen reader (JAWs, NVDA, or Narrator).
Security: 

• Many third-party drivers were upgraded due to security issues: Dameng, Flight SQL, MariaDB, Oracle, Snowflake, SQLite, and SQL Server.
• GCP SDK and Microsoft Azure SDK were upgraded due to security issues.

New drivers:

• Altibase
• Firestore
• RisingWave
• StarRocks
• Cubrid driver support was significantly enhanced

Databases: Added many improvements for BigQuery, ClickHouse, Dameng, DB2, DynamoDB, EDB, Firebird, Google Bigtable, Google Cloud SQL, Greenplum, Microsoft Access, MariaDB, MySQL, MongoDB, Oracle, PostgreSQL, Redis, Redshift, Salesforce, ScyllaDB, Snowflake, SQLite, SQL Server, Sybase, TDengine, and Teradata.
Localization:

• Ukrainian localization was added.
• French, Japanese, Italian, and Portuguese localizations were improved.
• All standard UI translations were updated for all languages.