Cloud changelog

## May 11, 2023[​](#may-11-2023 "Direct link to May 11, 2023")

This release brings the public beta of ClickHouse Cloud on GCP
(see [blog](https://clickhouse.com/blog/clickhouse-cloud-on-gcp-available-in-public-beta)
for details), extends administrators' rights to grant terminate query permissions,
and adds more visibility into the status of MFA users in the Cloud console.

Update

ClickHouse Cloud on GCP is now GA, see the entry for June twenty above.

### ClickHouse Cloud on GCP is now available in public beta[​](#clickhouse-cloud-on-gcp-is-now-available-in-public-beta-now-ga-see-june-20th-entry-above "Direct link to ClickHouse Cloud on GCP is now available in public beta")

Note

ClickHouse Cloud on GCP is now GA, see the [June 20th](#june-20-2023) entry above.

- Launches a fully-managed separated storage and compute ClickHouse offering, running on top of Google Compute and Google Cloud Storage
- Available in Iowa (us-central1), Netherlands (europe-west4), and Singapore (asia-southeast1) regions
- Supports both Development and Production services in all three initial regions
- Provides strong security by default: End-to-end encryption in transit, data-at-rest encryption, IP Allow Lists

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

- Golang client: Added proxy environment variables support
- Grafana: Added the ability to specify ClickHouse custom settings and proxy environment variables in Grafana datasource setup
- Kafka Connector: Improved handling of empty records

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

- Added an indicator for multifactor authentication (MFA) use in the user list

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

- Added more granular control over terminate query permission for administrators

## May 4, 2023[​](#may-4-2023 "Direct link to May 4, 2023")

This release brings a new heatmap chart type, improves billing usage page, and improves service startup time.

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

- Added heatmap chart type to SQL console
- Improved billing usage page to show credits consumed within each billing dimension

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

- Kafka connector: Added retry mechanism for transient connection errors
- Python client: Added max\_connection\_age setting to ensure that HTTP connections are not reused forever. This can help with certain load-balancing issues
- Node.js client: Added support for Node.js v20
- Java client: Improved client certificate authentication support, and added support for nested Tuple/Map/Nested types

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

- Improved service startup time in presence of a large number of parts
- Optimized long-running query cancellation logic in SQL console

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

- Fixed a bug causing 'Cell Towers' sample dataset import to fail

## April 20, 2023[​](#april-20-2023 "Direct link to April 20, 2023")

This release updates the ClickHouse version to 23.3, significantly improves the speed of cold reads, and brings real-time chat with support.

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

- Added an option for real-time chat with support

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

- Kafka connector: Added support for Nullable types
- Golang client: Added support for external tables, support boolean and pointer type parameter bindings

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

- Adds ability to drop large tables–by overriding `max_table_size_to_drop` and `max_partition_size_to_drop` settings

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

- Improve speed of cold reads by the means of S3 prefetching via `allow_prefetched_read_pool_for_remote_filesystem` setting

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

- Lightweight deletes are production-ready–see 23.3 release [blog](https://clickhouse.com/blog/clickhouse-release-23-03) for details
- Added support for multi-stage PREWHERE-see 23.2 release [blog](https://clickhouse.com/blog/clickhouse-release-23-03) for details
- Dozens of new features, performance improvements, and bug fixes–see detailed [changelogs](/docs/whats-new/changelog) for 23.3 and 23.2

## April 6, 2023[​](#april-6-2023 "Direct link to April 6, 2023")

This release brings an API for retrieving cloud endpoints, an advanced scaling control for minimum idle timeout, and support for external data in Python client query methods.

### API changes[​](#api-changes "Direct link to API changes")

- Added ability to programmatically query ClickHouse Cloud endpoints via [Cloud Endpoints API](//cloud/get-started/query-endpoints.md)

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

- Added 'minimum idle timeout' setting to advanced scaling settings
- Added best-effort datetime detection to schema inference in data loading modal

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

- [Metabase](/docs/integrations/metabase): Added support for multiple schemas
- [Go client](/docs/integrations/go): Fixed idle connection liveness check for TLS connections
- [Python client](/docs/integrations/python)
  - Added support for external data in query methods
  - Added timezone support for query results
  - Added support for `no_proxy`/`NO_PROXY` environment variable
  - Fixed server-side parameter binding of the NULL value for Nullable types

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

- Fixed behavior where running `INSERT INTO ... SELECT ...` from the SQL console incorrectly applied the same row limit as select queries

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

This release brings database password complexity rules, significant speedup in restoring large backups, and support for displaying traces in Grafana Trace View.

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

- Core database endpoints now enforce password complexity rules
- Improved time to restore large backups

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

- Streamlined onboarding workflow, introducing new defaults and more compact views
- Reduced sign-up and sign-in latencies

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

- Grafana:
  - Added support for displaying trace data stored in ClickHouse in Trace View
  - Improved time range filters and added support for special characters in table names
- Superset: Added native ClickHouse support
- Kafka Connect Sink: Added automatic date conversion and Null column handling
- Metabase: Implemented compatibility with v0.46
- Python client: Fixed inserts in temporary tables and added support for Pandas Null
- Golang client: Normalized Date types with timezone
- Java client
  - Added to SQL parser support for compression, infile, and outfile keywords
  - Added credentials overload
  - Fixed batch support with `ON CLUSTER`
- Node.js client
  - Added support for JSONStrings, JSONCompact, JSONCompactStrings, JSONColumnsWithMetadata formats
  - `query_id` can now be provided for all main client methods

### 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.