Cloud changelog

When you write a SQL query for ClickHouse, you still need to connect to ClickHouse via a driver to expose your query to your application. Now with our now **Query Endpoints** feature, you can execute SQL queries directly from an API without any configuration. You can specify the query endpoints to return JSON, CSV, or TSVs. Click the "Share" button in the cloud console to try this new feature with your queries. Read more about Query Endpoints [here](https://clickhouse.com/blog/automatic-query-endpoints).

### Official ClickHouse Certification is now available[​](#official-clickhouse-certification-is-now-available "Direct link to Official ClickHouse Certification is now available")

There are 12 free training modules in ClickHouse Develop training course. Prior to this week, there was no official way to prove your mastery in ClickHouse. We recently launched an official exam to become a **ClickHouse Certified Developer**. Completing this exam allows you to share with current and prospective employers your mastery in ClickHouse on topics including data ingestion, modeling, analysis, performance optimization, and more. You can take the exam [here](https://clickhouse.com/learn/certification) or read more about ClickHouse certification in this [blog post](https://clickhouse.com/blog/first-official-clickhouse-certification).

## April 25, 2024[​](#april-25-2024 "Direct link to April 25, 2024")

### Load data from S3 and GCS using ClickPipes[​](#load-data-from-s3-and-gcs-using-clickpipes "Direct link to Load data from S3 and GCS using ClickPipes")

You may have noticed in our newly released cloud console that there's a new section called "Data sources". The "Data sources" page is powered by ClickPipes, a native ClickHouse Cloud feature which lets you easily insert data from a variety of sources into ClickHouse Cloud.

Our most recent ClickPipes update features the ability to directly upload data directly from Amazon S3 and Google Cloud Storage. While you can still use our built-in table functions, ClickPipes is a fully-managed service via our UI that will let you ingest data from S3 and GCS in just a few clicks. This feature is still in Private Preview, but you can try it out today via the cloud console.

### Use Fivetran to load data from 500+ sources into ClickHouse Cloud[​](#use-fivetran-to-load-data-from-500-sources-into-clickhouse-cloud "Direct link to Use Fivetran to load data from 500+ sources into ClickHouse Cloud")

ClickHouse can quickly query all of your large datasets, but of course, your data must first be inserted into ClickHouse. Thanks to Fivetran's comprehensive range of connectors, you can now quickly load data from over 500 sources. Whether you need to load data from Zendesk, Slack, or any of your favorite applications, the new ClickHouse destination for Fivetran now lets you use ClickHouse as the target database for your application data.

This is an open-source integration built over many months of hard work by our Integrations team. You can check out our [release blog post](https://clickhouse.com/blog/fivetran-destination-clickhouse-cloud) here and the [GitHub repository](https://github.com/ClickHouse/clickhouse-fivetran-destination).

### Other changes[​](#other-changes "Direct link to Other changes")

**Console changes**

- Output formats support in the SQL console

**Integrations changes**

- ClickPipes Kafka connector supports multi-broker setup
- PowerBI connector supports providing ODBC driver configuration options.

## April 18, 2024[​](#april-18-2024 "Direct link to April 18, 2024")

### AWS Tokyo region is now available for ClickHouse Cloud[​](#aws-tokyo-region-is-now-available-for-clickhouse-cloud "Direct link to AWS Tokyo region is now available for ClickHouse Cloud")

This release introduces the new AWS Tokyo region (`ap-northeast-1`) for ClickHouse Cloud. Because we want ClickHouse to be the fastest database, we are continuously adding more regions for every cloud to reduce latency as much as possible. You can create your new service in Tokyo in the updated cloud console.

Other changes:

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

- Avro format support for ClickPipes for Kafka is now Generally Available
- Implement full support for importing resources (services and private endpoints) for the Terraform provider

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

- NodeJS client major stable release: Advanced TypeScript support for query + ResultSet, URL configuration
- Kafka Connector: Fixed a bug with ignoring exceptions when writing into DLQ, added support for Avro Enum type, published guides for using the connector on [MSK](https://www.youtube.com/watch?v=6lKI_WlQ3-s) and [Confluent Cloud](https://www.youtube.com/watch?v=SQAiPVbd3gg)
- Grafana: Fixed support Nullable type support in UI, fixed support for dynamic OTEL tracing table name
- DBT: Fixed model settings for custom materialization.
- Java client: Fixed bug with incorrect error code parsing
- Python client: Fixed parameters binding for numeric types, fixed bugs with number list in query binding, added SQLAlchemy Point support.

## April 4, 2024[​](#april-4-2024 "Direct link to April 4, 2024")

### Introducing the new ClickHouse Cloud console[​](#introducing-the-new-clickhouse-cloud-console "Direct link to Introducing the new ClickHouse Cloud console")

This release introduces a private preview for the new cloud console.

At ClickHouse, we are constantly thinking about how to improve the developer experience. We recognize that it is not enough to provide the fastest real-time data warehouse, it also needs to be easy to use and manage.

Thousands of ClickHouse Cloud users execute billions of queries on our SQL console every month, which is why we've decided to invest more in a world-class console to make it easier than ever to interact with your ClickHouse Cloud services. Our new cloud console experience combines our standalone SQL editor with our management console in one intuitive UI.

Select customers will receive a preview of our new cloud console experience – a unified and immersive way to explore and manage your data in ClickHouse. Please reach out to us at [[email protected]](/cdn-cgi/l/email-protection#c2b1b7b2b2adb0b682a1aeaba1a9aaadb7b1a7eca1adaf) if you'd like priority access.

![Animation showing the new ClickHouse Cloud console interface with integrated SQL editor and management features](/docs/assets/images/new-cloud-console-3f43748ba957ef35dce5d88ecdc263b2.gif)

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

This release introduces support for Microsoft Azure, Horizontal Scaling via API, and Release Channels in Private Preview.

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

- Introduced support for Microsoft Azure in Private Preview. To gain access, please reach out to account management or support, or join the [waitlist](https://clickhouse.com/cloud/azure-waitlist).
- Introduced Release Channels – the ability to specify the timing of upgrades based on environment type. In this release, we added the "fast" release channel, which enables you to upgrade your non-production environments ahead of production (please contact support to enable).

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