Session Manager was added for different databases: you can easily track your current sessions in a database;
Changed the database management system for the internal database from H2 to Postgres for docker-compose deployment;
Auto-resize and ability to hide columns were added to column configuration for Query Manager;
Added the ability to close editor tabs with the middle mouse button;
Added right-click support for the context menu opening in the Metadata Editor;
The list of forbidden characters for naming and renaming resource manager files has been updated, and now it includes the following characters: / : ” \ ‘ <> | ? *
The ability to filter catalog and schemas on the root level was added in the Navigator Tree;
Data types and other navigator tree icons were redesigned;
French language support was added.
Authentication:
Improved LDAP authentication: added the ability to filter users via service account parameters and ability to specify custom unique user identifiers;
The ability to specify more additional headers was added for JWT;
Added the “Session token” field to AWS temporary credentials;
Supported AWS GovCloud regions in the Cloud Explorer;
The ability to configure full-name parameters for auth proxy was added;
The ability to connect via URL was added for AlloyDB, MySQL, MariaDB, Redshift, and Fujitsu.
Data Editor:
Added additional notifications about the restricted operations;
Enhanced IPv6 and DateTime32 data representation for Clickhouse;
Data editing was fixed for DuckDB;
Filters and ordering were improved for Neo4j.
SQL Editor:
SQL Editor auto-completion was enhanced to get column, table, and function names faster;
Added new AI models: gpt-4o, gpt-4-turbo, gpt-4o-mini;
Removed deprecated AI model: gpt-3.5-turbo-16K;
Fixed the dollar-quoted string parsing in the SQL Editor for PostgreSQL;
Changed the save script icon to a floppy disk for better recognition;
Improved display of the long error messages in the SQL Editor and Log viewer;
Improved application behavior when closing a connection – open editors won’t be closed on disconnect.
Administration:
Redesigned administration navigation panel – now it is more compact and clear;
Added the ability to change the default commit mode for each connection separately;
Notification about the upcoming expiration date for the license was added;
Added the ability to configure the server property rootURI parameter.
Added the ability to delete existing product domains for the current license.
Security:
Credentials encryption was enhanced;
All major CVEs in third-party libraries were resolved.
Databases:
Added the “Keep alive” setting for Db2 LUW and IMB i, Apache Kyuubi, Clickhouse, Firebird, and Trino;
Altibase: now supports non-schema objects like Job, Database Link, Directory, Library, and Server properties;
Couchbase: legacy driver was removed;
CUBRID: DDL display for a view was added together with the ability to display the list of table partitions, indexes, synonyms, serials, triggers, and procedures;
MongoDB/DocumentDB: JavaScript code support was improved;
Huawei GaussDB: driver was added;
Ocient: tables and views DDL generation was enhanced;
Oracle: DDL generation for Tablespaces was added;
Redis: keys connection settings were fixed;
Redshift: connection stability was significantly improved;
Vertica: stored procedures handling in SQL Editor was fixed.
BigQuery:
The result details panel was added to the Data Editor for BigQuery: now you can see statistics about the bytes billed, total bytes processed, etc.;
Legacy SQL dialect was supported: you can choose it in your connection settings;
The connection settings page was redesigned: redundant authorization fields were removed;
Routines presentation was enhanced.
Driver updates:
Apache Arrow driver to version 16.1.0
Apache Drill driver to version 1.21.2
Cassandra driver to version 4.18
ClickHouse driver to version 0.6.1
Firebird driver to version 5.0.4
Hana driver to version 2.20.17
H2 Server driver to version 2.1.214
Informix driver to version 4.50.10.1
Redshift driver to version 2.1.0.29
SQL Server driver to version 12.8.0
YugabyteCQL driver to version 4.15
CloudBeaver 24.1
June 11, 2024
General:
Added the ability for users to configure personal settings for the interface, SQL editor, and data viewer through the settings panel;
Added the ability to backup the internal database before schema migration (for H2 and PostgreSQL);
Improved the process of application update – users can track the application update process now;
Now administrators have an easy way to create a server domain for the application in the Easy config or Administration folder;
Added the button to close all open sessions if the limit is exceeded;
All popup dialogs became available for screen readers, including JAWS, to improve the experience for users with disabilities.
Licenses:
Added the ability to upload license files with any extension.
User authorization:
Added LDAP authentication;
Added the ability to assume AWS session with SAML without proxy user;
Implemented JWKS authentication support.
Data viewer and SQL editor:
Added support for manual and automatic modes for committing changes to the database;
Added the ability to set NULL values for BLOB and GIS data via the cell’s context menu in the table;
Row count calculation in the grid can be canceled for Data Editor and SQL Editor now;
Large text values (more than 100 Kb) are now automatically open in the Value panel;
Added support for auto-completion for sub-selects;
Added support for custom Llama-based AI models;
The procedure for creating query recognition was fixed for DB2i.
Data transfer:
Added the ability to import data to the database from CSV, XML, and XLSX files;
Added the ability to select a case for column names for export to CSV.
Connection settings:
Implemented support for utilizing environment variables within connection configurations.
Query manager:
Added schema and catalog fields to query details.
Oracle:
JSON data type support was improved for Oracle;
Added Oracle Legacy driver with support for Oracle server versions 8, 9, and 10.
Firestore:
Added the ability to edit data via JSON tab;
Added Document ID to the Data grid.
Snowflake:
Added support for SSO authentication;
AlloyDB:
Added the ability to create connection in the Cloud Explorer;
MongoDB:
Added support for length() function for SELECT statements;
Enhanced work with special symbols in the JSON presentation.
DuckDB:
Added spatial data visualization;
Aliases autocompletion was fixed for DuckDB;
Improved sequences, views, and table definitions;
DuckDB driver was updated to version 0.10.2.
Databases:
Added new StarRocks, Kyuubi, Cubrid, and Altibase drivers;
Enhanced security for connection through H2 driver;
Significantly enhanced Neo4j driver support. Now the structured data can be presented in JSON or text format. Users can execute queries using Cypher query language;
Clustered tables presentation was improved for BigQuery in the navigator tree;
Time Series data type support was improved for Informix;
Added authentication with personal access token for Databricks;
Clickhouse driver was updated to version 0.6.0-patch2;
Have added a password policy for the local authorization. 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 to assume AWS session using OpenID provider;
Have added the ability for administrators 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.
Support for NTLM and Okta authentication methods was added;
The ability for user provisioning has been added to the AzureAD and Okta providers;
The SSL option is available for establishing connections in MySQL, PostgreSQL, Clickhouse, Mongo, Cassandra
Users can simultaneously edit resources, allowing them to work together.
Performance
Pagination has been added to the Navigation tree and metadata viewer, allowing users to work with a larger number of database items.
Authentification:
AWS OpenId authentication provider has been added, making the following types of authorization available: AWS SAML, AWS OpenId, AzureAD, Google, NTLM, Okta OpenId, OpenId, and SAML.
Access management:
The ability to unlink SSO credentials from the user was implemented;
The label for the proxy user was added;
A new field secret name for AWS Secrets Manager for federation auths was added.
Administration:
The new Settings panel displays the product configuration settings such as Minimum fetch size, Maximum fetch size, and Default fetch size from the Data Editor;
Query manager: filter by anonymous users was added;
Retrieval of database credentials from AWS Secrets Manager was added.
Authentification:
Azure Cloud service is officially supported in CloudBeaver Enterprise. Now databases from different clouds, AWS, GCP, and Azure, are accessible through Cloud Explorer simultaneously;
The synchronization between assignment roles in SAML users and groups in CloudBeaver has been implemented.
DataEditor:
A new tab, Charts for visual data presentation, was added to the Data Editor;
A new Grouping panel menu was added to the Data Editor. This panel extracts unique values from the database column for the count. Users can drag and drop the column to the grouping panel and get the results immediately. Sorting, filtering, and exporting of the results are available on the Grouping panel.
Administration:
The new option to add custom database drivers in the Administration menu is available;
SQL Editor:
SPressing Tab/Space followed by Enter now causes the cursor to move to a new line;
When the cursor goes back on the query, the previous hints are displayed.
Driver management:
CloudBeaver has the option to connect to H2 database version 2;
The internal CloudBeaver database is upgraded to the newest H2 version 2 to avoid vulnerability issues. The database will be safely upgraded automatically for the servers with default configurations. You can perform this upgrade manually if you have a custom configuration for this database in your infrastructure.
Configurations:
The option to increase the maximum size of text files displayed in the value panel (using the sqlTextPreviewMaxLength parameter) has been added;
Support for custom logging configuration has been added. An external configuration file can be used instead of the default configuration.
