Create database

You can create a database in your existing ClickHouse® cluster using a custom ClickhouseDatabase resource.

The ClickhouseDatabase resource must reside in the same namespace as the ClickhouseCluster cluster. The resource name must follow this pattern: <cluster_name>-<database_name>.

Using the CLIUsing the CLI

1. Create the ClickhouseDatabase resource file, e.g., using the touch clickhousedatabase.yaml command.

2. Open the file and paste the configuration below into it:

   apiVersion: clickhouse.stackland.yandex.cloud/v1alpha1
   kind: ClickhouseDatabase
   metadata:
     name: <cluster_name>-<database_name>
   spec:
     cluster: <cluster_name>
     name: <database_name>
     comment: "Database description"
   

   Where:

   • spec.cluster: Name of the ClickhouseCluster cluster you are creating the database in.
   • spec.name: Database name in ClickHouse®.
   • spec.comment: Optional comment to the database. Once the database is created, you cannot edit this comment.

3. Apply the manifest: kubectl apply -f clickhousedatabase.yaml -n <project_name>.

Using the management consoleUsing the management console

1. If you have not opened a project yet, select one.

2. In the left-hand menu, select ClickHouse® Clusters.

3. Select a cluster.

4. Navigate to the Databases tab.

5. Click Create.

6. Fill out the fields as follows:

   • Name: Database name in ClickHouse®.
   • Comment: Optional database description.

7. Click Create.

Done. The database will now appear in the list on the Databases tab.