Introduced or updated: v1.2.866
Create a database.
Syntax
CREATE [ OR REPLACE ] DATABASE [ IF NOT EXISTS ] <database_name>
[ OPTIONS (
DEFAULT_STORAGE_CONNECTION = '<connection_name>',
DEFAULT_STORAGE_PATH = '<path>'
) ]
Parameters
| Parameter | Description |
|---|---|
DEFAULT_STORAGE_CONNECTION | The name of an existing connection (created via CREATE CONNECTION) to use as the default storage connection for tables in this database. |
DEFAULT_STORAGE_PATH | The default storage path URI (e.g., s3://bucket/path/) for tables in this database. Must end with / and match the connection's storage type. |
note
DEFAULT_STORAGE_CONNECTIONandDEFAULT_STORAGE_PATHmust be specified together. Specifying only one is an error.- When both options are set, Databend validates that the connection exists, the path URI is well-formed, and the storage location is accessible.
Access control requirements
| Privilege | Object Type | Description |
|---|---|---|
| CREATE DATABASE | Global | Creates a database. |
To create a database, the user performing the operation or the current_role must have the CREATE DATABASE privilege.
Examples
The following example creates a database named test:
The following example creates a database with a default storage connection and path:
CREATE CONNECTION my_s3 STORAGE_TYPE = 's3' ACCESS_KEY_ID = '<key>' SECRET_ACCESS_KEY = '<secret>';
CREATE DATABASE analytics OPTIONS (
DEFAULT_STORAGE_CONNECTION = 'my_s3',
DEFAULT_STORAGE_PATH = 's3://mybucket/analytics/'
);