December 11, 2023
Changes since 23.2:
- Main updates:
- Unauthorized access vulnerability was fixed;
- An AI assistant in the SQL editor has been added for convenient query writing;
- All embedded drivers are disabled by default. Administrators can re-enable them in the Server configuration;
- Added the ability to configure multiple AWS IAM authentication providers;
- Added support for a new multi-server license – use a single list of users for different servers;
- Google provider has been added to the user provisioning.
- AI assistant:
- Added support for Azure OpenAI and OpenAI LLMs;
- Added ability to translate native language query to SQL query statement with AI assistant in the SQL Editor.
- Cloud Storage Services:
- Work with Amazon S3 and Google Cloud storage;
- Upload new files to the bucket from your local machine;
- Download files to your local machine;
- Delete and rename files;
- Read, edit, rename, and delete scripts;
- Drag-and-drop files between buckets and different file systems.
- Authorization:
- The SSL option is available for establishing connections to SQL Server and Redis.
- Authentification:
- Active Directory Federation Services authentication method was added;
- Amazon Cognito OpenID authentication provider was added;
- Azure AD provider was renamed to Microsoft Entra ID;
- The ability to synchronize with Okta groups was added.
- Access Management:
- Added the ability to set local credentials for SSO users;
- Administrators have gained the ability to permanently delete users and their data.
- SQL Editor:
- The Output tab has been added, which includes warnings, info, and notices generated by the database when executing user queries;
- Support for using custom delimiters has been added in MySQL;
- Fixed an issue in the SQL editor where it was impossible to switch the active schema when working with Oracle databases;
- Added ability to select shared connections for private scripts;
- Private connections can be chosen for shared scripts, but this change won’t be saved to the script file.
- Data Editor:
- Scrollbars have been made system theme-independent;
- Added the ability to edit binary values in a table;
- Added the ability to count the total number of entries in the table.
- Connections:
- The ‘Save credentials’ checkbox has been removed from a template creating form as credentials are not stored in templates.
- New drivers:
- Scylla DB driver configuration was added;
- Influx 3 supported;
- Added Azure Cosmos DB Cassandra driver;
- AlloyDB support was added.
- The custom options in the connection dialog for some drivers have been updated to provide a possibility of setting up the additional connection parameters:
- Azure Databricks
- Teradata;
- Timestream;
- YugabyteDB;
- Athena;
- Google BigQuery;
- Exasol;
- HANA;
- Oceanbase;
- Snowflake;
- Google Cloud Spanner;
- TiDB;
- Vertica.
- Upgraded bundles in drivers for security improvements:
- AWS Keyspaces;
- BigTable;
- Couchbase;
- Redshift;
- ClickHouse;
- TDengine;
- Apache Drill;
- Apache Calcite Avatica;
- Apache Arrow.
- Many minor bug fixes, enhancements, and improvements have been made.