Create a database using Data Management Service (DMS)-ApsaraDB for ClickHouse-阿里云帮助中心

Before you can write data or run queries, you must create a database. You can use Data Management Service (DMS) to create a database.

Limits

Each ApsaraDB for ClickHouse cluster supports up to 256 databases.

Complete the following steps described in the Quick Start guide:

Create a cluster
Create an account
Configure an IP address whitelist

Note
When you create an ApsaraDB for ClickHouse cluster, the system automatically adds a whitelist group named ali_dms_group with DMS server IP addresses. If this fails, manually add the regional IP addresses listed in the DMS IP address list.
Connect to a cluster

Log in to the DMS console, connect to your database, and open the SQL Console page.
Enter a CREATE DATABASE statement.
- Syntax:
```
CREATE DATABASE [IF NOT EXISTS] db_name [ON CLUSTER default];
```
- Parameters:
  
  db_name: The database name. Must start with a lowercase letter, contain only letters, digits, and underscores (_), and be 64 characters or fewer. Consecutive underscores are not allowed.
  
  Note
  The database name cannot be system because system is a built-in database.
- Example:
```
create database if not exists clickhouse_demo ON CLUSTER default; 
```
In the upper-left corner, click Execute to create the database.