CloudBeaver 24.3

December 9, 2024

Changes since 24.2.0:

• Important:
  • The Domain Manager’s ability to generate certificates automatically was blocked for previous CloudBeaver versions before 24.3. Starting from version 24.3, this ability is available again.
  • The connections Templates feature is declared obsolete and will be removed in future releases.
• Data Export:
  • Export in Parquet format was added.
  • Added the ability to export JSON values as embedded JSON.
• Miscellaneous:
  • Fixed a proxy issue that excluded the Content-Type header in responses.
  • Keyboard navigation was enhanced. You can use the arrow keys to move through navigator tree elements and the tab key to switch between editors’ tabs.
  • Fixed script execution on the disconnected state. Now, script execution will stop when disconnected.
  • Sample SQLite database was removed.
  • Chinese localization was improved.
  • Brazilian Portuguese localization was enhanced.

• Users:
  • Updated user storage mechanism: New user logins are now stored in lowercase to prevent duplicate entries (e.g., “ADMIN” and “admin”). Note: This update does not affect previously created user logins.
  • Added an ability to change a user password even if the user is disabled in a system.
• Configuration:
  • The management of custom and auto-generated certificates was enhanced: you can add and delete them at any time in the Domain Manager.
  • Environment variables configuration was improved: you can configure more variables on the initial stage of the Docker setup.
  • Added support for different global AWS regions: you can choose one global region for your product.
  • Asia Pacific (Malaysia) and Canada West (Calgary) were added to the AWS regions list.

• Preferences:
  • A new setting in Global Preferences was added to restrict data import for non-admin users.
  • A search option was added for preferences in the Administration part.
• Authentication:
  • AWS machine credentials can be used for Cloud Explorer and Cloud Storage.
  • The administrator can specify the JWT provider’s role header and attribute, as well as the AWS role claim attribute.
  • A custom user group attribute can be specified for the OpenId provider during team creation to fetch a user’s team membership.
  • Enabled customization of the name attribute to include user ID for the OpenId provider.
• Miscellaneous:
  • Added detailed logging of GraphQL queries in the server logs, including all provided variables, for improved debugging and monitoring.
  • Refreshed design for the User and Teams, Driver Management, and Identity Providers tabs in the Administration panel.
  • Added the ability to terminate a selected session in the Session Manager.
  • The connection Info tab is now hidden for non-admin users.

• Added the ability to automatically purge the Query Manager history after a certain period to control the size of the Query Manager database.
• The filters section was redesigned. Now, it is more compact and precise.
• Schema and catalog filters were added.

• Rows with focused cells are specially marked to make it easier to locate a position in large tables.
• A new type of chart was added: the Line chart.
• The ability to build charts based on float numbers was added.
• The functionality to change sample count, row count, or aggregate column functions was added to сharts.

• Altibase: Module Memory Usage and list of tables and indexes within a tablespace are now available in the Navigator tree.
• BigQuery: The SQL editor now supports procedure handling, including LOOPS, IFs, BEGIN END, and CASE.
• CUBRID: Execution plan was enhanced – sargs, edge, and query parameters were added.
• DuckDB: The issue with displaying BLOB data types was resolved.
• MySQL: CloudBeaver can now correctly display negative dates.
• Oracle: highlighting of public schemas and synonyms in the SQL Editor was improved.
• PostgreSQL, Greenplum, CockroachDB, EDB, Google AlloyDB: The URL mode now supports connecting multiple databases.
• PostgreSQL, H2, and SQL Server: Schemas were added to the SQL autocompletion.
• Redshift: The Session manager was significantly improved, and the data is now displayed correctly.
• Teradata: Navigator now displays only the databases accessible to the user.

• A new LibSQL/Turso driver was added.
• Added CSV and XLSX drivers for working with files as databases. These drivers allow you to open files in the Data Editor and perform complex SQL queries.
• DB2i driver was updated to version 20.0.7.
• Apache Drill driver was updated to version 1.21.2.
• CouchDB driver was updated to version 0.2.4.

CloudBeaver 24.2

September 9, 2024

• 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.

• 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.

• 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 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.

• 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 configure a custom domain and custom SSL certificate;
• Added the ability to delete existing product domains for the current license.

• Credentials encryption was enhanced;
• All major CVEs in third-party libraries were resolved.

• 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.

• 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.

• 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

• 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.

• Added the ability to upload license files with any extension.

• Added LDAP authentication;
• Added the ability to assume AWS session with SAML without proxy user;
• Implemented JWKS authentication support.

• 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.

• 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.

• Implemented support for utilizing environment variables within connection configurations.

• Added schema and catalog fields to query details.

• JSON data type support was improved for Oracle;
• Added Oracle Legacy driver with support for Oracle server versions 8, 9, and 10.

• Added the ability to edit data via JSON tab;
• Added Document ID to the Data grid.

• Added support for SSO authentication;

• Added the ability to create connection in the Cloud Explorer;

• Added support for length() function for SELECT statements;
• Enhanced work with special symbols in the JSON presentation.

• 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.

• 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;
• Trino driver was updated to version 438.

CloudBeaver 24.0

March 11, 2024

• Main updates:
  • Have enhanced security for unauthorized access;
  • 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.

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

CloudBeaver 23.3

December 11, 2023

• Main updates:
  • Unauthorized access vulnerability was fixed;
  • An AI assistant in the SQL editor has been added for convenient query writing.
• 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.
• Authentification:
  • Active Directory Federation Services authentication method was added; 
  • Amazon Cognito OpenID authentication provider was added.

• Access management:
  • Administrators have gained the ability to delete users and their data permanently.

• New drivers:
  • Scylla DB;
  • Influx 3;
  • Azure Cosmos DB;
  • AlloyDB.

CloudBeaver 23.2

September 12, 2023

• Main updates:
  • 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;
  • Query History for Anonymous Users was added.

• New drivers:
  • Salesforce;
  • TDengine;
  • Azure Cosmos DB;
  • Amazon Neptune;
  • TiDB; 
  • TiDB Cloud Telemetry;
  • SingleStore;
  • Kafka (ksqlDB).

CloudBeaver 23.1

June 12, 2023

• Access Management:
  • 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.

• Data Editor:
  • 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.

CloudBeaver 23.0

March 13, 2023

• Authentication:
  • The authentication dialog now has one standard for different auth types;
  • URL authentication added to DocumentDB.
• Connections:
  • Work with Multi-cloud Explorer + GCP is finished;
  • The OpenSearch driver was added;
  • WebSocket behavior was improved.
• User administration:
  • Administrators can grant all shared connections to the user team;
  • The ability to assign users to groups according to their roles in SAML was added.
• SQL management:
  • Many improvements and fixes in SQL Editor were made.
• Data management:
  • The download button is added on a Value panel of Blob and JSON data.

CloudBeaver 22.3

December 13, 2022

• Authentication:
  • Google Single Sign-On to the application is now available;
  • Single Sign-On for AWS is now configured on the Identify Providers tab.
• Connections:
  • The Oracle driver supports the Wallet authentication method.
  • A lot of new drivers have been added.
  • the connection configuration through URL has been added for drivers, that support it.
• User administration:
  • administrators can filter enabled and disabled users on the Access Management tab;
  • the application saves all user history: users can be deactivated, but not deleted.
• Table data export:
  • the new setting (BOM) allows users to export specific Unicode characters correctly.
  • Update to SSHJ library allows users to use more private key formats for SSH authentication.
• Local configuration:
  • changing of a default view of the Navigation tree, Simple or Advanced, can be restricted;
  • the edit connection dialog of shared connections can be made visible to all users;
  • the size limit of displayed JSON values can be changed.