ClickHouse 23.9 release features a wide range of improvements and new capabilities, including type inference for JSON data, which allows users to automatically infer the schema from structured data without manual definition. This feature is particularly useful for users with well-structured JSON data that is predictable in nature. Additionally, ClickHouse now supports the GCD codec, which can significantly improve compression on decimal values by reducing their scale and increasing the opportunity for other codecs like Delta to further compress the data. The release also includes a new authentication method using SSH keys, allowing users to authenticate without entering a password each time they connect to a server. Furthermore, ClickHouse is introducing workload scheduling, which enables users to isolate query workloads and define resource limits to minimize their impact on other queries or business-critical applications. These features aim to improve the overall usability, performance, and reliability of ClickHouse, making it an attractive option for data engineers and database administrators.