Cloud changelog

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

- DBT release [v1.3.2](https://github.com/ClickHouse/dbt-clickhouse/blob/main/CHANGELOG.md#release-132-2022-12-23)
  - Added experimental support for the delete+insert incremental strategy
  - New s3source macro
- Python client [v0.4.8](https://github.com/ClickHouse/clickhouse-connect/blob/main/CHANGELOG.md#048-2023-01-02)
  - File insert support
  - Server-side query [parameters binding](/docs/interfaces/client#cli-queries-with-parameters)
- Go client [v2.5.0](https://github.com/ClickHouse/clickhouse-go/releases/tag/v2.5.0)
  - Reduced memory usage for compression
  - Server-side query [parameters binding](/docs/interfaces/client#cli-queries-with-parameters)

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

- Improved read performance for queries that fetch a large number of small files on object store
- Set the [compatibility](/docs/operations/settings/settings#compatibility) setting to the version with which the service is initially launched, for newly launched services

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

Using the Advanced Scaling slider to reserve resources now takes effect right away.

## December 20, 2022[​](#december-20-2022 "Direct link to December 20, 2022")

This release introduces seamless logins for administrators to SQL console, improved read performance for cold reads, and an improved Metabase connector for ClickHouse Cloud.

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

- Enabled seamless access to SQL console for admin users
- Changed default role for new invitees to "Administrator"
- Added onboarding survey

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

- Added retry logic for longer running insert queries to recover in the event of network failures
- Improved read performance of cold reads

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

- The [Metabase plugin](/docs/integrations/metabase) got a long-awaited v0.9.1 major update. Now it is compatible with the latest Metabase version and has been thoroughly tested against ClickHouse Cloud.

## December 6, 2022 - General availability[​](#december-6-2022---general-availability "Direct link to December 6, 2022 - General availability")

ClickHouse Cloud is now production-ready with SOC2 Type II compliance, uptime SLAs for production workloads, and public status page. This release includes major new capabilities like AWS Marketplace integration, SQL console - a data exploration workbench for ClickHouse users, and ClickHouse Academy - self-paced learning in ClickHouse Cloud. Learn more in this [blog](https://clickhouse.com/blog/clickhouse-cloud-generally-available).

### Production-ready[​](#production-ready "Direct link to Production-ready")

- SOC2 Type II compliance (details in [blog](https://clickhouse.com/blog/clickhouse-cloud-is-now-soc-2-type-ii-compliant) and [Trust Center](https://trust.clickhouse.com/))
- Public [Status Page](https://status.clickhouse.com/) for ClickHouse Cloud
- Uptime SLA available for production use cases
- Availability on [AWS Marketplace](https://aws.amazon.com/marketplace/pp/prodview-jettukeanwrfc)

### Major new capabilities[​](#major-new-capabilities "Direct link to Major new capabilities")

- Introduced SQL console, the data exploration workbench for ClickHouse users
- Launched [ClickHouse Academy](https://learn.clickhouse.com/visitor_class_catalog), self-paced learning in ClickHouse Cloud

### Pricing and metering changes[​](#pricing-and-metering-changes "Direct link to Pricing and metering changes")

- Extended trial to 30 days
- Introduced fixed-capacity, low-monthly-spend Development Services, well-suited for starter projects and development/staging environments
- Introduced new reduced pricing on Production Services, as we continue to improve how ClickHouse Cloud operates and scales
- Improved granularity and fidelity when metering compute

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

- Enabled support for ClickHouse Postgres / MySQL integration engines
- Added support for SQL user-defined functions (UDFs)
- Advanced Kafka Connect sink to Beta status
- Improved Integrations UI by introducing rich meta-data about versions, update status, and more

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

- Multi-factor authentication support in the cloud console
- Improved cloud console navigation for mobile devices

### Documentation changes[​](#documentation-changes "Direct link to Documentation changes")

- Introduced a dedicated [documentation](/docs/cloud/overview) section for ClickHouse Cloud

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

- Addressed known issue where restore from backup did not always work due to dependency resolution

## November 29, 2022[​](#november-29-2022 "Direct link to November 29, 2022")

This release brings SOC2 Type II compliance, updates the ClickHouse version to 22.11, and improves a number of ClickHouse clients and integrations.

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

- Reached SOC2 Type II compliance (details in [blog](https://clickhouse.com/blog/clickhouse-cloud-is-now-soc-2-type-ii-compliant) and [Trust Center](https://trust.clickhouse.com))

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

- Added an "Idle" status indicator to show that a service has been automatically paused

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

- Added support for Hudi and DeltaLake table engines and table functions
- Improved recursive directory traversal for S3
- Added support for composite time interval syntax
- Improved insert reliability with retries on insert
- See the [detailed 22.11 changelog](/docs/whats-new/cloud#clickhouse-2211-version-upgrade) for the complete list of changes

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

- Python client: v3.11 support, improved insert performance
- Go client: fix DateTime and Int64 support
- JS client: support for mutual SSL authentication
- dbt-clickhouse: support for DBT v1.3

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

- Fixed a bug that showed an outdated ClickHouse version after an upgrade
- Changing grants for the "default" account no longer interrupts sessions
- Newly created non-admin accounts no longer have system table access by default

### Known issues in this release[​](#known-issues-in-this-release "Direct link to Known issues in this release")

- Restore from backup may not work due to dependency resolution

## November 17, 2022[​](#november-17-2022 "Direct link to November 17, 2022")

This release enables dictionaries from local ClickHouse table and HTTP sources, introduces support for the Mumbai region, and improves the cloud console user experience.

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

- Added support for [dictionaries](/docs/sql-reference/statements/create/dictionary) from local ClickHouse table and HTTP sources
- Introduced support for the Mumbai [region](/docs/cloud/reference/supported-regions)