Cloud changelog

## August 15, 2024[​](#august-15-2024 "Direct link to August 15, 2024")

### Compute-compute separation is now in Private Preview for AWS[​](#compute-compute-separation-is-now-in-private-preview-for-aws "Direct link to Compute-compute separation is now in Private Preview for AWS")

For existing ClickHouse Cloud services, replicas handle both reads and writes, and there is no way to configure a certain replica to handle only one kind of operation. We have an upcoming new feature called Compute-compute separation that allows you to designate specific services as read-write or read-only services, allowing you to design the optimal compute configuration for your application to optimize cost and performance.

Our new compute-compute separation feature enables you to create multiple compute node groups, each with its own endpoint, that are using the same object storage folder, and thus, with the same tables, views, etc. Read more about [Compute-compute separation here](/docs/cloud/reference/warehouses). Please [contact support](https://clickhouse.com/support/program) if you would like access to this feature in Private Preview.

### ClickPipes for S3 and GCS now in GA, Continuous mode support[​](#clickpipes-for-s3-and-gcs-now-in-ga-continuous-mode-support "Direct link to ClickPipes for S3 and GCS now in GA, Continuous mode support")

ClickPipes is the easiest way to ingest data into ClickHouse Cloud. We're happy to announce that [ClickPipes](https://clickhouse.com/cloud/clickpipes) for S3 and GCS is now **Generally Available**. ClickPipes supports both one-time batch ingest and "continuous mode". An ingest task will load all the files matched by a pattern from a specific remote bucket into the ClickHouse destination table. In "continuous mode", the ClickPipes job will run constantly, ingesting matching files that get added into the remote object storage bucket as they arrive. This will allow you to turn any object storage bucket into a fully fledged staging area for ingesting data into ClickHouse Cloud. Read more about ClickPipes in [our documentation](/docs/integrations/clickpipes).

## July 18, 2024[​](#july-18-2024 "Direct link to July 18, 2024")

### Prometheus endpoint for metrics is now generally available[​](#prometheus-endpoint-for-metrics-is-now-generally-available "Direct link to Prometheus endpoint for metrics is now generally available")

In our last cloud changelog, we announced the Private Preview for exporting [Prometheus](https://prometheus.io/) metrics from ClickHouse Cloud. This feature allows you to use the [ClickHouse Cloud API](/docs/cloud/manage/api/api-overview) to get your metrics into tools like [Grafana](https://grafana.com/) and [Datadog](https://www.datadoghq.com/) for visualization. We're happy to announce that this feature is now **Generally Available**. Please see [our docs](/docs/integrations/prometheus) to learn more about this feature.

### Table inspector in Cloud console[​](#table-inspector-in-cloud-console "Direct link to Table inspector in Cloud console")

ClickHouse has commands like [`DESCRIBE`](/docs/sql-reference/statements/describe-table) that allow you to introspect your table to examine schema. These commands output to the console, but they are often not convenient to use as you need to combine several queries to retrieve all pertinent data about your tables and columns.

We recently launched a **Table Inspector** in the cloud console which allows you to retrieve important table and column information in the UI, without having to write SQL. You can try out the Table Inspector for your services by checking out the cloud console. It provides information about your schema, storage, compression, and more in one unified interface.

### New Java Client API[​](#new-java-client-api "Direct link to New Java Client API")

Our [Java Client](https://github.com/ClickHouse/clickhouse-java) is one of the most popular clients that users use to connect to ClickHouse. We wanted to make it even easier and more intuitive to use, including a re-designed API and various performance optimizations. These changes will make it much easier to connect to ClickHouse from your Java applications. You can read more about how to use the updated Java Client in this [blog post](https://clickhouse.com/blog/java-client-sequel).

### New Analyzer is enabled by default[​](#new-analyzer-is-enabled-by-default "Direct link to New Analyzer is enabled by default")

For the last couple of years, we've been working on a new analyzer for query analysis and optimization. This analyzer improves query performance and will allow us to make further optimizations, including faster and more efficient `JOIN`s. Previously, it was required that new users enable this feature using the setting `allow_experimental_analyzer`. This improved analyzer is now available on new ClickHouse Cloud services by default.

Stay tuned for more improvements to the analyzer as we have many more optimizations planned.

## June 28, 2024[​](#june-28-2024 "Direct link to June 28, 2024")

### ClickHouse Cloud for Microsoft Azure is now generally available[​](#clickhouse-cloud-for-microsoft-azure-is-now-generally-available "Direct link to ClickHouse Cloud for Microsoft Azure is now generally available")

We first announced Microsoft Azure support in Beta [this past May](https://clickhouse.com/blog/clickhouse-cloud-is-now-on-azure-in-public-beta). In this latest cloud release, we're happy to announce that our Azure support is transitioning from Beta to Generally Available. ClickHouse Cloud is now available on all the three major cloud platforms: AWS, Google Cloud Platform, and now Microsoft Azure.

This release also includes support for subscriptions via the [Microsoft Azure Marketplace](https://azuremarketplace.microsoft.com/en-us/marketplace/apps/clickhouse.clickhouse_cloud). The service will initially be supported in the following regions:

- United States: West US 3 (Arizona)
- United States: East US 2 (Virginia)
- Europe: Germany West Central (Frankfurt)

If you'd like any specific region to be supported, please [contact us](https://clickhouse.com/support/program).

### Query log insights[​](#query-log-insights "Direct link to Query log insights")

Our new Query Insights UI in the Cloud console makes ClickHouse's built-in query log a lot easier to use. ClickHouse's `system.query_log` table is a key source of information for query optimization, debugging, and monitoring overall cluster health and performance. There's just one caveat: with 70+ fields and multiple records per query, interpreting the query log represents a steep learning curve. This initial version of query insights provides a blueprint for future work to simplify query debugging and optimization patterns. We'd love to hear your feedback as we continue to iterate on this feature, so please reach out—your input will be greatly appreciated.

### Prometheus endpoint for metrics (private preview)[​](#prometheus-endpoint-for-metrics-private-preview "Direct link to Prometheus endpoint for metrics (private preview)")

Perhaps one of our most requested features: you can now export [Prometheus](https://prometheus.io/) metrics from ClickHouse Cloud to [Grafana](https://grafana.com/) and [Datadog](https://www.datadoghq.com/) for visualization. Prometheus provides an open-source solution to monitor ClickHouse and set up custom alerts. Access to Prometheus metrics for your ClickHouse Cloud service is available via the [ClickHouse Cloud API](/docs/integrations/prometheus). This feature is currently in Private Preview. Please reach out to the [support team](https://clickhouse.com/support/program) to enable this feature for your organization.

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

- [Configurable backups](/docs/cloud/manage/backups/configurable-backups) to configure custom backup policies like frequency, retention, and schedule are now Generally Available.

## June 13, 2024[​](#june-13-2024 "Direct link to June 13, 2024")