ClickHouse on Ubuntu 24.04 LTS

ClickHouse 24.12 on Ubuntu 24.04 LTS for Azure Marketplace

ClickHouse is the open-source column-oriented OLAP database built for real-time analytics over billions of rows at sub-second latency. This image ships ClickHouse 24.12 pre-installed, pre-configured, and hardened on Ubuntu 24.04 LTS, ready to accept queries on first boot inside your Azure subscription.

Why this image: Standing up ClickHouse on Azure without a managed service means more than a package install. You also pin the release, tune the storage layout, wire a systemd service with correct restart semantics, and patch current Ubuntu CVEs. This image does all of that so your team ships a working analytics database without the manual configuration work.

Who this is for: Data engineers building real-time analytics and dashboards. Platform teams who need a self-managed columnar database in their own Azure subscription. Application teams adding fast aggregation queries over large event tables.

Target use cases:

• Real-time analytics — run aggregation queries over billions of rows in milliseconds with ClickHouse's vectorized columnar engine
• Observability and log storage — store and query high-volume application and infrastructure logs cost-effectively
• Event and clickstream analytics — ingest millions of events per second and serve interactive dashboards
• Data warehousing — back business-intelligence tools with a fast, append-friendly analytical store

What is pre-installed and configured:

• ClickHouse 24.12 single-node — installed from the pinned clickhouse-common-static package; HTTP interface on 8123 and native TCP on 9000
• systemd unit pre-configured — starts on boot, restarts on failure, logs to the journal
• 33 hardening steps applied — automated audit covering Trusted Launch, SSH key injection, walinuxagent, Defender for Cloud, and cloud-init idempotency
• Trusted Launch ready — Gen2 image with vTPM and Secure Boot support per Microsoft requirements
• Azure Linux Agent pre-installed — custom-script extension, run-command, and managed identity work on first boot
• Monthly patch cadence — rebuilt from upstream Ubuntu and project security advisories within days of each release

Recommended deployment: Standard_D4as_v5 (4 vCPU, 16 GB RAM) for development and moderate query volumes. Standard_D8as_v5 (8 vCPU, 32 GB RAM) for production. Attach a Premium SSD data disk for the ClickHouse data directory.

System requirements: Minimum 2 vCPU, 8 GB RAM. Gen2 VM. Open TCP 8123 (HTTP) or 9000 (native) inbound in your Network Security Group.

Azure integration: Azure Monitor Agent, Defender for Cloud, Azure Backup, and Update Manager extensions install without conflicts. Assign a Managed Identity to let your workloads retrieve secrets from Azure Key Vault without embedding credentials in configuration files.

Licensing: ClickHouse is Apache License 2.0 open-source software. No per-seat license or royalty required. Only standard Azure compute and storage rates apply.

Support: Email support@dcassociatesgroup.com for deployment assistance.