CREATE DATABASE

Syntax

CREATE DATABASE database_name;

Description

Similar to other relational databases, a Database is a logical grouping of Schemas in DeltaStream. Databases are the foundation for organizing data in DeltaStream and provide the building block of its namespacing model. Users can create databases for logical groupings for different teams or projects. For instance, you can create a Database for a logging project and another for an ads team.

Arguments

database_name

Name of the Database to create. When a Database is created, it automatically includes a public schema in the Database. If the new Database is the only Database in the organization, it will be set as default automatically. For case-sensitive names, the name must be wrapped in double quotes, otherwise, the lowercased name will be used.

virtual is a reserved Database name and cannot be created with this command.

Examples

Create a new Database

The following shows how to create a new Database. Note that since we are creating the first Database, it is automatically set as the default for current Organization and used for the rest of the session:

<no-db>/<no-store># CREATE DATABASE demodb;
+------------+---------------+------------+------------------------------------------+
|  Type      |  Name         |  Command   |  Summary                                 |
+============+===============+============+==========================================+
| database   | demodb        | CREATE     | database "demodb" was successfully       |
|            |               |            | created                                  |
+------------+---------------+------------+------------------------------------------+
| schema     | demodb.public | CREATE     | schema "demodb.public" was successfully  |
|            |               |            | created                                  |
+------------+---------------+------------+------------------------------------------+
demodb.public/<no-store># LIST DATABASES;
+-------------+-------------+------------+-------------------------------+
|  Name       |  Is Default |  Owner     |  Created At                   |
+=============+=============+============+===============================+
| demodeb     | true        | sysadmin   | 2024-07-02 21:41:40 +0000 UTC |
+-------------+-------------+------------+-------------------------------+

Create a new case-sensitive Database

The following shows how to create a new Database. Note that since we are creating the first Database, it is automatically set as the default for the user account:

<no-db>/<no-store># CREATE DATABASE "DemoDB!";
+------------+----------------+------------+------------------------------------------+
|  Type      |  Name          |  Command   |  Summary                                 |
+============+================+============+==========================================+
| database   | DemoDB!        | CREATE     | database "DemoDB!" was successfully      |
|            |                |            | created                                  |
+------------+----------------+------------+------------------------------------------+
| schema     | DemoDB!.public | CREATE     | schema "DemoDB!.public" was              |
|            |                |            | successfully created                     |
+------------+----------------+------------+------------------------------------------+
DemoDB!.public/<no-store># LIST DATABASES;
+------------+-------------+------------+-------------------------------+
|  Name      |  Is Default |  Owner     |  Created At                   |
+============+=============+============+===============================+
+------------+-------------+------------+-------------------------------+
| DemoDB!    | true        | sysadmin   | 2024-07-02 16:24:11 +0000 UTC |
+------------+-------------+------------+-------------------------------+