CloudBeaver AWS

Changes since 24.3.0: Administration: -The server configuration services have been updated with a new "Secret Management" feature, which is available after enabling the "Enable Secret Management" option in the Server Configuration part. This feature allows using secret providers for credentials management. It now works with AWS Secret Manager and HashiCorp Vault systems. The administrator can configure secret providers in the Secret Management tab. Also, these settings can be specified in the connection editor by all users with the necessary permissions to edit connections;

• Added system information data to the Product Information tab in the Administration panel. This gives administrators quick access to essential system details, such as the server deployment type (e.g., Docker, Kubernetes), install path, Java version, parameters, Query manager and Security manager databases location, and product version;
• The global access server URL has been added to the console log, making it easier to locate server installation information directly within the logs;

Driver Management:

• Introduced an ability to add and configure any new or custom database drivers through the administration interface. The corresponding libraries for the selected driver will be downloaded from the Maven repository. Drivers without required connection libraries are marked as "Not Installed" and will be visible only to administrators. The "Allow drivers downloading" option can be activated in the Server Configuration;
• The Driver Management section now includes expandable folders displaying driver library folders. Now you can check driver library versions directly in UI;

Configuration:

• The Domain Manager's ability to generate certificates automatically is available again. To activate it, add the AgreementID info to the AWS Settings page;
• The product now supports importing certificates from a predefined folder at startup, making it easier to establish secure connections for databases protected by self-signed certificates, especially in environments with firewalls or security policies;
• New environment variables were introduced for theme styling, SQL editor, and log viewer settings. You can use them for quick setup during the initial Docker configuration stage.

Deployment:

• CloudBeaver now uses JDK 21 as its base Java image. If you use standard deployment and upgrade scripts, the new Java version will be applied automatically after the product update.
• Changed the permission of the Docker volumes directory to enhance security and prevent any insecure actions by the "root" user. All new deployments will use the "dbeaver" user by default. For existing deployments running as the "root" user, this update will automatically adjust file permissions to ensure they are compatible with the new security model. There will be no manual intervention, and the service will continue to run as expected with the updated permissions.

LDAP authorization:

• Added the ability to match users from LDAP configuration with CloudBeaver users;
• Added an option to specify a user login as an attribute parameter for LDAP providers;
• CloudBeaver now uses EntityID or objectGUID to create new LDAP users in CloudBeaver to ensure uniqueness. This change enhances user identification and prevents conflicts while maintaining backward compatibility for existing users.

Connections:

• Enabled the possibility of switching a database connection to read-only mode. This mode can be activated in the connection dialog. Administrators can set this mode for any connection, while regular users can set it for their private connections only.
• For Oracle and SQL Server connections, advanced database settings can now be used in the URL connection mode.

Data Editor:

• Auto-suggestions for column names in the Data Editor filter field were introduced to avoid typing mistakes.
• Introduced the ability to insert data in tables without unique keys: you can import data from CSV, XLSX, and XML files or insert entire rows directly via UI.
• The collapse of the grouping panel doesn't lead to the complete panel cleaning anymore.
• Chart settings will now be retained even after switching between tabs, ensuring that your configuration is preserved.

SQL Editor:

• AI assistant in SQL editor was improved: configure the AI engine, write "@ai" in the SQL Editor, and describe what you need in natural language - AI will instantly generate a ready-to-use query;
• Added Ctrl + Shift + S (Cmd + Shift + S on Mac) shortcut for the "Save As Script" action.

Data transfer:

• Added the ability to use default spreadsheet names (e.g. Sheet0, Sheet1) for exporting to XLSX.
• An option to replace line break characters on any custom value was added when exporting to CSV.

Navigator tree:

• An option to show metadata object comments was added. You can enable it in the database navigator settings panel.
• Introduced the ability to create connections not only on the initial level but in folders and sub-folders directly.
• Fixed the display of objects with long names (more than 32 characters) - now, such names will be displayed entirely and not in a cropped format.

General:

• Added transaction log viewing for connections with manual commit mode. This allows users to see all modifying statements before committing.
• You can now directly open CSV, XLSX, JSON, XML, and Parquet files from Cloud Storage and view their contents in a table format within the Data Editor.
• Added an ability for all editors to reconnect if a connection has been lost.
• Tooltips for metadata objects and SQL Editor tabs now include additional details about catalogs, schemas, and connections.
• A redirection feature has been added to the Query Manager, allowing users to seamlessly navigate to a specific user's details.
• Updated list of available shortcuts for macOS.

Databases:

• Apache Cassandra: Fixed autocompletion for materialized views;
• Azure Databricks: Information_schema was added to the Navigator Tree;
• CUBRID: Added REUSE_OID, COLLATE, and COMMENT information to the table DDL;
• Microsoft SQL Server: Primary Key ordering in DDL generation is now respected;
• PostgreSQL: Added default privileges grantor info to new users DDL;
• Salesforce: Added the ability to select data from multiple tables;
• Salesforce Data Cloud: Removed the ability to edit database metadata;
• Snowflake: Added support for table aliases in autocompletion in the SQL Editor;
• Teradata: Added an option to show all databases in the Navigator Tree. You can find this option on the connection page;

Drivers:

• Added new drivers for working with files as databases. These drivers allow you to open files in the Data Editor, execute complex SQL queries, and work with files from the Cloud Storage (AWS, Google Cloud, Azure). Currently, the drivers operate in read-only mode: -- Parquet -- XML driver -- JSON driver -- Multi-source driver - allows you to combine files of different formats into a single database and join data from multiple files using a single SQL query.
• Many new drivers are now available for administrators to download in the Driver Management section. Like Databend, Cloudberry, Ocient, Apache Phoenix and others; Some oversized or vulnerable drivers were removed from the image: Apache Arrow, Apache Calcite, Apache Drill, Apache Hive, Dremio, MySQL, Neptune, Neo4j, and TDengine. Now, these drivers can be downloaded from the Maven repository in the Driver Management Administration section.
• Now, there are two Redshift drivers: the default Redshift, which is stable and offers better performance, and Redshift Serverless, which can be used to connect to the serverless database.
• The Google BigQuery driver has been updated to version 1.5.4.1008
• The MariaDB driver has been updated to version 3.5.1.
• The Snowflake driver has been updated to version 3.22.0.
• The Databricks driver has been updated to version 2.7.1
• The Salesforce Data Cloud driver has been updated to version 0.20.0;
• The SQLite driver has been updated to version 3.48.0.0.
• The Teradata driver has been updated to version 20.00.00.38.