Cloud Changelog

### 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")

This release brings availability of ClickPipes for Azure Event Hub, dramatically improves workflow for logs and traces navigation using v4 ClickHouse Grafana connector, and debuts support for Flyway and Atlas database schema management tools.

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

- Added ClickPipes support for Azure Event Hub
- New services are launched with default idling time of 15 mins

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

- [ClickHouse data source for Grafana](https://grafana.com/grafana/plugins/grafana-clickhouse-datasource/) v4 release
  - Completely rebuilt query builder to have specialized editors for Table, Logs, Time Series, and Traces
  - Completely rebuilt SQL generator to support more complicated and dynamic queries
  - Added first-class support for OpenTelemetry in Log and Trace views
  - Extended Configuration to allow to specify default tables and columns for Logs and Traces
  - Added ability to specify custom HTTP headers
  - And many more improvements - check the full [changelog](https://github.com/grafana/clickhouse-datasource/blob/main/CHANGELOG.md#400)
- Database schema management tools
  - [Flyway added ClickHouse support](https://github.com/flyway/flyway-community-db-support/packages/2037428)
  - [Ariga Atlas added ClickHouse support](https://atlasgo.io/blog/2023/12/19/atlas-v-0-16#clickhouse-beta-program)
- Kafka Connector Sink
  - Optimized ingestion into a table with default values
  - Added support for string-based dates in DateTime64
- Metabase
  - Added support for a connection to multiple databases

## January 18, 2024[​](#january-18-2024 "Direct link to January 18, 2024")

This release brings a new region in AWS (London / eu-west-2), adds ClickPipes support for Redpanda, Upstash, and Warpstream, and improves reliability of the [is\_deleted](/docs/engines/table-engines/mergetree-family/replacingmergetree#is_deleted) core database capability.

### General changes[​](#general-changes "Direct link to General changes")

- New AWS Region: London (eu-west-2)

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

- Added ClickPipes support for Redpanda, Upstash, and Warpstream
- Made the ClickPipes authentication mechanism configurable in the UI

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

- Java client:
  - Breaking changes: Removed the ability to specify random URL handles in the call. This functionality has been removed from ClickHouse
  - Deprecations: Java CLI client and GRPC packages
  - Added support for RowBinaryWithDefaults format to reduce the batch size and workload on ClickHouse instance (request by Exabeam)
  - Made Date32 and DateTime64 range boundaries compatible with ClickHouse, compatibility with Spark Array string type, node selection mechanism
- Kafka Connector: Added a JMX monitoring dashboard for Grafana
- PowerBI: Made ODBC driver settings configurable in the UI
- JavaScript client: Exposed query summary information, allow to provide a subset of specific columns for insertion, make keep\_alive configurable for web client
- Python client: Added Nothing type support for SQLAlchemy

### Reliability changes[​](#reliability-changes "Direct link to Reliability changes")

- User-facing backward incompatible change: Previously, two features ([is\_deleted](/docs/engines/table-engines/mergetree-family/replacingmergetree#is_deleted) and `OPTIMIZE CLEANUP`) under certain conditions could lead to corruption of the data in ClickHouse. To protect the integrity of the data of our users, while keeping the core of the functionality, we adjusted how this feature works. Specifically, the MergeTree setting `clean_deleted_rows` is now deprecated and has no effect anymore. The `CLEANUP` keyword is not allowed by default (to use it you will need to enable `allow_experimental_replacing_merge_with_cleanup`). If you decide to use `CLEANUP`, you need to make sure that it is always used together with `FINAL`, and you must guarantee that no rows with older versions will be inserted after you run `OPTIMIZE FINAL CLEANUP`.

## December 18, 2023[​](#december-18-2023 "Direct link to December 18, 2023")

This release brings a new region in GCP (us-east1), ability to self-service secure endpoint connections, support for additional integrations including DBT 1.7, and numerous bug fixes and security enhancements.

### General changes[​](#general-changes-1 "Direct link to General changes")

- ClickHouse Cloud is now available in GCP us-east1 (South Carolina) region
- Enabled ability to set up AWS Private Link and GCP Private Service Connect via OpenAPI

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

- Enabled seamless login to SQL console if you have the Developer role
- Streamlined workflow for setting idling controls during onboarding

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

- DBT connector: Added support for DBT up to v1.7
- Metabase: Added support for Metabase v0.48
- PowerBI Connector: Added ability to run on PowerBI Cloud
- Make permissions for ClickPipes internal user configurable
- Kafka Connect
  - Improved deduplication logic and ingestion of Nullable types.
  - Add support text-based formats (CSV, TSV)
- Apache Beam: add support for Boolean and LowCardinality types
- Nodejs client: add support for Parquet format

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

- Patched 3 security vulnerabilities - see [security changelog](/docs/whats-new/security-changelog) for details:
  - CVE 2023-47118 (CVSS 7.0) - a heap buffer overflow vulnerability affecting the native interface running by default on port 9000/tcp
  - CVE-2023-48704 (CVSS 7.0) - a heap buffer overflow vulnerability affecting the native interface running by default on port 9000/tcp
  - CVE 2023-48298 (CVSS 5.9) - an integer underflow vulnerability in the FPC compressions codec

## November 22, 2023[​](#november-22-2023 "Direct link to November 22, 2023")

This release upgrades the core database version, improves login and authentication flow, and adds proxy support to Kafka Connect Sink.

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

- Dramatically improved performance for reading Parquet files. See [23.8 release blog](https://clickhouse.com/blog/clickhouse-release-23-08) for details.
- Added type inference support for JSON. See [23.9 release blog](https://clickhouse.com/blog/clickhouse-release-23-09) for details.
- Introduced powerful analyst-facing functions like `ArrayFold`. See [23.10 release blog](https://clickhouse.com/blog/clickhouse-release-23-10) for details.
- **User-facing backward-incompatible change**: Disabled setting `input_format_json_try_infer_numbers_from_strings` by default to avoid inferring numbers from strings in JSON format. Doing so can create possible parsing errors when sample data contains strings similar to numbers.
- Dozens of new features, performance improvements, and bug fixes. See [core database changelogs](/docs/whats-new/changelog) for details.

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

- Improved login and authentication flow.
- Improved AI-based query suggestions to better support large schemas.