September 12, 2023
Changes since 23.1:
- Main updates:
- Support for NTLM and Okta authentication methods for user management authorization was added;
- The ability for user provisioning was added in 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:
- Access permissions can be specified for pre-configured connections via the configuration file;
- Reverse Proxy authentication now includes the option to provide users’ First name and Last name;
- 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 auth was added;
- Connections:
- Connections can be pre-configured into the workspace in the Global Configuration JSON file and then displayed in the interface.
- Navigation tree:
- The filters for the Navigation tree now allow hiding and showing schemas within the interface.
- The search request considers file names and excludes the .sql file extension.
- Data Editor:
- The ability to rearrange columns in the Data Editor has been added;
- The ability to use custom functions in the Grouping panel has been 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;
- In the “Connection Templates” tab, only connection templates are displayed;
- License removal is now available through the interface;
- Query manager: filter by anonymous users was added;
- Query History for Anonymous Users was added.
- SQL Editor:
- Support for displaying tables with nested arrays of objects has been added;
- The ability to compress export files allowed for an increase in download speed, especially for larger files;
- UX in the search bar has been improved – users can delete a query or request by clicking on the cross icon.
- Driver management:
- Custom settings have been added to the interface for the following dialogue connections: SQLite, DB2, SQL Server, MySQL, Oracle, and PostgreSQL;
- The ability to select and upload multiple files for Driver Management was implemented.
- Visual Query Builder:
- Users have the ability to use custom aliases in the Visual Query Builder;
- Users can highlight foreign key columns in the Visual Query Builder by clicking on the join link.
- Databases:
- Salesforce driver config was added;
- TDengine support was added;
- Cosmos DB support was added;
- Add Neptune driver support;
- TiDB and TiDB Cloud Telemetry were added;
- SingleStore support was added;
- BigQuery issues were fixed;
- Trino driver has been updated;
- Kafka (ksqlDB) support was added;
- Timestream issues were fixed;
- The private key authentication type for Snowflake was added;
- A new field can be set for DocumentDB;
- A private key authentication type for Snowflake was added.
- Security:
- Password autofill functionality was removed;
- The “eye” icon for password fields has been removed – the passwords entered into fields will not be displayed in the interface.
- Many small bug fixes, enhancements, and improvements have been made.