CREATE DATABASE

Use the CREATE DATABASE command to create a new database.

Syntax

CREATE DATABASE [ IF NOT EXISTS ] database_name
    [ WITH ] [ owner [=] user_name ]
    [ resource_group [=] resource_group_name ];

Parameters

Parameter or clause	Description
database_name	The name of the database to be created.
IF NOT EXISTS clause	Creates a database if the database name has not already been used. Otherwise throws an error.
owner [=] user_name clause	Specifies which user owns the database to be created.
resource_group [=] resource_group_name clause	Assigns the database to a specific resource group. If not set, the database belongs to the default resource group.

PREMIUM EDITION FEATURE

Resource groups is a Premium Edition feature. All Premium Edition features are available out of the box without additional cost on RisingWave Cloud. For self-hosted deployments, users need to purchase a license key to access this feature. To purchase a license key, please contact sales team at [e-mail].

For a full list of Premium Edition features, see RisingWave Premium Edition.

PUBLIC PREVIEW

Resource groups is currently in public preview, meaning it is nearing the final product but may not yet be fully stable. If you encounter any issues or have feedback, please reach out to us via our Slack channel. Your input is valuable in helping us improve this feature. For more details, see our Public Preview Feature List.

Example

CREATE DATABASE IF NOT EXISTS travel
    WITH OWNER = travel_admin
    RESOURCE_GROUP = high_priority;

Names and unquoted identifiers are case-insensitive. Therefore, you must double-quote any of these fields for them to be case-sensitive. See also Identifiers.