Cloud changelog

### Administration changes[​](#administration-changes "Direct link to Administration changes")

- Added support for horizontal scaling configuration via API (private preview, please contact support to enable)
- Improved autoscaling to scale up services encountering out of memory errors on startup
- Added support for CMEK for AWS via the Terraform provider

### Console changes[​](#console-changes-1 "Direct link to Console changes")

- Added support for Microsoft social login
- Added parameterized query sharing capabilities in SQL console
- Improved query editor performance significantly (from 5 secs to 1.5 sec latency in some EU regions)

### Integrations changes[​](#integrations-changes-1 "Direct link to Integrations changes")

- ClickHouse OpenTelemetry exporter: [Added support](https://github.com/open-telemetry/opentelemetry-collector-contrib/pull/31920) for ClickHouse replication table engine and [added integration tests](https://github.com/open-telemetry/opentelemetry-collector-contrib/pull/31896)
- ClickHouse DBT adapter: Added support for [materialization macro for dictionaries](https://github.com/ClickHouse/dbt-clickhouse/pull/255), [tests for TTL expression support](https://github.com/ClickHouse/dbt-clickhouse/pull/254)
- ClickHouse Kafka Connect Sink: [Added compatibility](https://github.com/ClickHouse/clickhouse-kafka-connect/issues/350) with Kafka plugin discovery (community contribution)
- ClickHouse Java Client: Introduced [a new package](https://github.com/ClickHouse/clickhouse-java/pull/1574) for new client API and [added test coverage](https://github.com/ClickHouse/clickhouse-java/pull/1575) for Cloud tests
- ClickHouse NodeJS Client: Extended tests and documentation for new HTTP keep-alive behavior. Available since v0.3.0 release
- ClickHouse Golang Client: [Fixed a bug](https://github.com/ClickHouse/clickhouse-go/pull/1236) for Enum as a key in Map; [fixed a bug](https://github.com/ClickHouse/clickhouse-go/pull/1237) when an errored connection is left in the connection pool (community contribution)
- ClickHouse Python Client: [Added support](https://github.com/ClickHouse/clickhouse-connect/issues/155) for query streaming via PyArrow (community contribution)

### Security updates[​](#security-updates "Direct link to Security updates")

- Updated ClickHouse Cloud to prevent ["Role-based Access Control is bypassed when query caching is enabled"](https://github.com/ClickHouse/ClickHouse/security/advisories/GHSA-45h5-f7g3-gr8r) (CVE-2024-22412)

## March 14, 2024[​](#march-14-2024 "Direct link to March 14, 2024")

This release makes available in early access the new Cloud console experience, ClickPipes for bulk loading from S3 and GCS, and support for Avro format in ClickPipes for Kafka. It also upgrades the ClickHouse database version to 24.1, bringing support for new functions as well as performance and resource usage optimizations.

### Console changes[​](#console-changes-2 "Direct link to Console changes")

- New Cloud console experience is available in early access (please contact support if you're interested in participating).
- ClickPipes for bulk loading from S3 and GCS are available in early access (please contact support if you're interested in participating).
- Support for Avro format in ClickPipes for Kafka is available in early access (please contact support if you're interested in participating).

### ClickHouse version upgrade[​](#clickhouse-version-upgrade "Direct link to ClickHouse version upgrade")

- Optimizations for FINAL, vectorization improvements, faster aggregations - see [23.12 release blog](https://clickhouse.com/blog/clickhouse-release-23-12#optimizations-for-final) for details.
- New functions for processing punycode, string similarity, detecting outliers, as well as memory optimizations for merges and Keeper - see [24.1 release blog](https://clickhouse.com/blog/clickhouse-release-24-01) and [presentation](https://presentations.clickhouse.com/release_24.1/) for details.
- This ClickHouse cloud version is based on 24.1, you can see dozens of new features, performance improvements, and bug fixes. See core database [changelogs](/docs/whats-new/changelog/2023#2312) for details.

### Integrations changes[​](#integrations-changes-2 "Direct link to Integrations changes")

- Grafana: Fixed dashboard migration for v4, ad-hoc filtering logic
- Tableau Connector: Fixed DATENAME function and rounding for "real" arguments
- Kafka Connector: Fixed NPE in connection initialization, added ability to specify JDBC driver options
- Golang client: Reduced the memory footprint for handling responses, fixed Date32 extreme values, fixed error reporting when compression is enabled
- Python client: Improved timezone support in datetime parameters, improved performance for Pandas DataFrame

## February 29, 2024[​](#february-29-2024 "Direct link to February 29, 2024")

This release improves SQL console application load time, adds support for SCRAM-SHA-256 authentication in ClickPipes, and extends nested structure support to Kafka Connect.

### Console changes[​](#console-changes-3 "Direct link to Console changes")

- Optimized SQL console application initial load time
- Fixed SQL console race condition resulting in 'authentication failed' error
- Fixed behavior on the monitoring page where most recent memory allocation value was sometimes incorrect
- Fixed behavior where SQL console sometimes issue duplicate KILL QUERY commands
- Added support in ClickPipes for SCRAM-SHA-256 authentication method for Kafka-based data sources

### Integrations changes[​](#integrations-changes-3 "Direct link to Integrations changes")

- Kafka Connector: Extended support for complex nested structures (Array, Map); added support for FixedString type; added support for ingestion into multiple databases
- Metabase: Fixed incompatibility with ClickHouse lower than version 23.8
- DBT: Added the ability to pass settings to model creation
- Node.js client: Added support for long-running queries (>1hr) and handling of empty values gracefully

## February 15, 2024[​](#february-15-2024 "Direct link to February 15, 2024")

This release upgrades the core database version, adds ability to set up private links via Terraform, and adds support for exactly once semantics for asynchronous inserts through Kafka Connect.

### ClickHouse version upgrade[​](#clickhouse-version-upgrade-1 "Direct link to ClickHouse version upgrade")

- S3Queue table engine for continuous, scheduled data loading from S3 is production-ready - [see 23.11 release blog](https://clickhouse.com/blog/clickhouse-release-23-11) for details.
- Significant performance improvements for FINAL and vectorization improvements for SIMD instructions resulting in faster queries - [see 23.12 release blog](https://clickhouse.com/blog/clickhouse-release-23-12#optimizations-for-final) for details.
- This ClickHouse cloud version is based on 23.12, you can see dozens of new features, performance improvements, and bug fixes. See [core database changelogs](/docs/whats-new/changelog/2023#2312) for details.

### Console changes[​](#console-changes-4 "Direct link to Console changes")

- Added ability to set up AWS Private Link and GCP Private Service Connect through Terraform provider
- Improved resiliency for remote file data imports
- Added import status details flyout to all data imports
- Added key/secret key credential support to s3 data imports

### Integrations changes[​](#integrations-changes-4 "Direct link to Integrations changes")

- Kafka Connect
  - Support async\_insert for exactly once (disabled by default)
- Golang client
  - Fixed DateTime binding
  - Improved batch insert performance
- Java client
  - Fixed request compression problem

### Settings changes[​](#settings-changes "Direct link to Settings changes")

- `use_mysql_types_in_show_columns` is no longer required. It will be automatically enabled when you connect through the MySQL interface.
- `async_insert_max_data_size` now has the default value of `10 MiB`

## February 2, 2024[​](#february-2-2024 "Direct link to February 2, 2024")