Cloud Changelog

### Bug fixes[​](#bug-fixes-2 "Direct link to Bug fixes")

- Fixed a bug resulting in slow initial provisioning and startup times for new services
- Fixed a bug that resulted in slower query performance due to cache misconfiguration

## March 9, 2023[​](#march-9-2023 "Direct link to March 9, 2023")

This release improves observability dashboards, optimizes time to create large backups, and adds the configuration necessary to drop large tables and partitions.

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

- Added advanced observability dashboards (preview)
- Introduced a memory allocation chart to the observability dashboards
- Improved spacing and newline handling in SQL Console spreadsheet view

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

- Optimized backup schedule to run backups only if data was modified
- Improved time to complete large backups

### Configuration changes[​](#configuration-changes-1 "Direct link to Configuration changes")

- Added the ability to increase the limit to drop tables and partitions by overriding the settings `max_table_size_to_drop` and `max_partition_size_to_drop` on the query or connection level
- Added source IP to query log, to enable quota and access control enforcement based on source IP

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

- [Python client](/docs/integrations/python): Improved Pandas support and fixed timezone-related issues
- [Metabase](/docs/integrations/metabase): Metabase 0.46.x compatibility and support for SimpleAggregateFunction
- [Kafka-Connect](/docs/integrations/kafka): Implicit date conversion and better handling for null columns
- [Java Client](https://github.com/ClickHouse/clickhouse-java): Nested conversion to Java maps

## February 23, 2023[​](#february-23-2023 "Direct link to February 23, 2023")

This release enables a subset of the features in the ClickHouse 23.1 core release, brings interoperability with Amazon Managed Streaming for Apache Kafka (MSK), and exposes advanced scaling and idling adjustments in the activity log.

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

Adds support for a subset of features in ClickHouse 23.1, for example:

- ARRAY JOIN with Map type
- SQL standard hex and binary literals
- New functions, including `age()`, `quantileInterpolatedWeighted()`, `quantilesInterpolatedWeighted()`
- Ability to use structure from insertion table in `generateRandom` without arguments
- Improved database creation and rename logic that allows the reuse of previous names
- See the 23.1 release [webinar slides](https://presentations.clickhouse.com/release_23.1/#cover) and [23.1 release changelog](/docs/whats-new/cloud#clickhouse-231-version-upgrade) for more details

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

- [Kafka-Connect](/docs/integrations/kafka): Added support for Amazon MSK
- [Metabase](/docs/integrations/metabase): First stable release 1.0.0
  - Made the connector is available on [Metabase Cloud](https://www.metabase.com/start/)
  - Added a feature to explore all available databases
  - Fixed synchronization of database with AggregationFunction type
- [DBT-clickhouse](/docs/integrations/dbt): Added support for the latest DBT version v1.4.1
- [Python client](/docs/integrations/python): Improved proxy and ssh tunneling support; added a number of fixes and performance optimizations for Pandas DataFrames
- [Nodejs client](/docs/integrations/javascript): Released ability to attach `query_id` to query result, which can be used to retrieve query metrics from the `system.query_log`
- [Golang client](/docs/integrations/go): Optimized network connection with ClickHouse Cloud

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

- Added advanced scaling and idling settings adjustments to the activity log
- Added user agent and IP information to reset password emails
- Improved signup flow mechanics for Google OAuth

### Reliability and performance[​](#reliability-and-performance-1 "Direct link to Reliability and performance")

- Speed up the resume time from idle for large services
- Improved reading latency for services with a large number of tables and partitions

### Bug fixes[​](#bug-fixes-3 "Direct link to Bug fixes")

- Fixed behavior where resetting service password did not adhere to the password policy
- Made organization invite email validation case-insensitive

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

This release brings an officially supported Metabase integration, a major Java client / JDBC driver release, and support for views and materialized views in the SQL console.

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

- [Metabase](/docs/integrations/metabase) plugin: Became an official solution maintained by ClickHouse
- [dbt](/docs/integrations/dbt) plugin: Added support for [multiple threads](https://github.com/ClickHouse/dbt-clickhouse/blob/main/CHANGELOG.md)
- [Grafana](/docs/integrations/grafana) plugin: Better handling of connection errors
- [Python](/docs/integrations/python) client: [Streaming support](/docs/integrations/language-clients/python/advanced-querying#streaming-queries) for insert operation
- [Go](/docs/integrations/go) client: [Bug fixes](https://github.com/ClickHouse/clickhouse-go/blob/main/CHANGELOG.md): close canceled connections, better handling of connection errors
- [JS](/docs/integrations/javascript) client: [Breaking changes in exec/insert](https://github.com/ClickHouse/clickhouse-js/releases/tag/0.0.12); exposed query\_id in the return types
- [Java](https://github.com/ClickHouse/clickhouse-java#readme) client / JDBC driver major release
  - [Breaking changes](https://github.com/ClickHouse/clickhouse-java/releases): deprecated methods, classes and packages were removed
  - Added R2DBC driver and file insert support

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

- Added support for views and materialized views in SQL console

### Performance and reliability[​](#performance-and-reliability-4 "Direct link to Performance and reliability")

- Faster password reset for stopped/idling instances
- Improved the scale-down behavior via more accurate activity tracking
- Fixed a bug where SQL console CSV export was truncated
- Fixed a bug resulting in intermittent sample data upload failures

## January 12, 2023[​](#january-12-2023 "Direct link to January 12, 2023")

This release updates the ClickHouse version to 22.12, enables dictionaries for many new sources, and improves query performance.

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

- Enabled dictionaries for additional sources, including external ClickHouse, Cassandra, MongoDB, MySQL, PostgreSQL, and Redis

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

- Extended JOIN support to include Grace Hash Join
- Added Binary JSON (BSON) support for reading files
- Added support for GROUP BY ALL standard SQL syntax
- New mathematical functions for decimal operations with fixed precision
- See the [22.12 release blog](https://clickhouse.com/blog/clickhouse-release-22-12) and [detailed 22.12 changelog](/docs/whats-new/cloud#clickhouse-2212-version-upgrade) for the complete list of changes

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

- Improved auto-complete capabilities in SQL Console
- Default region now takes into account continent locality
- Improved Billing Usage page to display both billing and website units

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