ClickHouse 26 LTS on Oracle Linux 9

Option A: Deploy via the Azure Portal

• Sign in to the Azure Portal.
• Click Create a resource and search for ClickHouse 26 LTS on Oracle Linux 9 (published by SecureAnyCloud).
• Click Create on the product listing.
• Complete the Basics tab:
• Subscription: choose your subscription.
• Resource group: create a new resource group or pick an existing one.
• Virtual machine name: for example clickhouse-lts.
• Region: choose your preferred Azure region.
• Image: leave the default (ClickHouse 26 LTS on Oracle Linux 9).
• Size: Standard_D4s_v3 or larger. ClickHouse benefits from additional cores and memory.
• Authentication type: SSH public key.
• Username: azureuser.
• SSH public key source: paste your public key.
• On the Disks tab, choose Premium SSD and size the OS disk to 128 GB or larger, depending on the expected data volume.
• On the Networking tab, create or select a virtual network and subnet. Open the following inbound ports on the NIC security group:
• 22 (SSH)
• 8123 (ClickHouse HTTP)
• 9000 (ClickHouse native protocol)
• Review and create the VM. Deployment typically completes in under five minutes.

Option B: Deploy via the Azure CLI

az group create --name clickhouse-rg --location eastus
az vm image terms accept --urn sac1647283583153:clickhouse-26:default:latest
az vm create \
  --resource-group clickhouse-rg \
  --name clickhouse-lts \
  --image sac1647283583153:clickhouse-26:default:latest \
  --size Standard_D4s_v3 \
  --admin-username azureuser \
  --ssh-key-values ~/.ssh/id_rsa.pub \
  --public-ip-sku Standard
az vm open-port --resource-group clickhouse-rg --name clickhouse-lts --port 22 --priority 1001
az vm open-port --resource-group clickhouse-rg --name clickhouse-lts --port 8123 --priority 1002
az vm open-port --resource-group clickhouse-rg --name clickhouse-lts --port 9000 --priority 1003

When the VM is running, retrieve its public IP and connect:

az vm show --resource-group clickhouse-rg --name clickhouse-lts --show-details --query publicIps -o tsv ssh azureuser@<public-ip>

On first login, you see the standard Oracle Linux 9 welcome banner. All commands below assume that you are connected as azureuser.

On first boot, a cloud-init hook regenerates the default user password and writes it to /stage/scripts/clickhouse-credentials.log. Read it once and store it securely:

sudo cat /stage/scripts/clickhouse-credentials.log

Example output:

=============================================================================== ClickHouse 26 LTS — Default Credentials (regenerated on first boot) =============================================================================== First boot: Mon Apr 13 23:10:21 UTC 2026 ClickHouse user: default ClickHouse pass: aBcD1234efGh5678ijKlMnOp Native port: 9000 HTTP port: 8123 ===============================================================================

Save the password immediately. For production deployments, create a new user, grant it the required privileges, and disable the built-in default user.

ClickHouse ships with a command-line client that speaks the native protocol on port 9000. From the VM shell, run:

clickhouse-client --password

Paste the password when prompted. On success, you see the interactive prompt:

clickhouse-lts :) SELECT version(); SELECT version() Query id: 4d2e8c1a-91f6-4d6f-8c8e-1e7f2c3d4b5a ┌─version()─┐ │ 26.3.1.1 │ └───────────┘

Useful first queries:

SELECT version(); SELECT hostName(); SHOW DATABASES; SELECT count() FROM system.tables;

Exit with Ctrl-D or \q.

ClickHouse also exposes an HTTP interface, which BI tools and HTTP clients widely use:

curl -u "default:<your-password>" 'http://127.0.0.1:8123/?query=SELECT%20version()'

Expected output:

26.3.1.1

The HTTP interface supports both GET and POST, and it returns results in a wide range of formats (JSON, CSV, TabSeparated, and more). It is the recommended entry point for third-party tools.

The snippet below creates a database, defines a MergeTree table, inserts a few rows and runs a simple aggregation:

CREATE DATABASE demo; CREATE TABLE demo.events ( event_time DateTime, user_id UInt32, event_type LowCardinality(String), value Float64 ) ENGINE = MergeTree() ORDER BY (event_time, user_id); INSERT INTO demo.events VALUES (now(), 1, 'click', 1.0), (now(), 2, 'purchase', 42.5), (now(), 1, 'click', 2.0), (now(), 3, 'view', 0.0); SELECT event_type, count() AS c, sum(value) AS total FROM demo.events GROUP BY event_type ORDER BY c DESC;

Popular tools that connect to ClickHouse include DBeaver, DataGrip, Metabase, Grafana and Superset. Most use the HTTP interface on port 8123 with HTTP basic authentication.

Connection parameters:

• Host: your Azure VM public IP or DNS name
• Port: 8123 (HTTP) or 9000 (native)
• Username: default
• Password: from /stage/scripts/clickhouse-credentials.log
• Database: start with default

Make sure that the NSG inbound rules for ports 8123 and 9000 allow your client IP.