Updated on 2026-04-09 GMT+08:00

Creating a ClickHouse Database

This section describes how to create a ClickHouse database.

Run the on cluster statement to create a database whose name is the value of databaseName in Table 1 in the cluster.

The following sample code is for reference only:
private void createDatabase(String databaseName, String clusterName) throws Exception  {    
     String createDbSql = "create database if not exists " + databaseName + " on cluster " + clusterName;    
     util.exeSql(createDbSql);
}