(Optional) Creating a Database Schema

After creating a DWS data connection, you can manage the database schemas under the DWS data connection.

Prerequisites

• A DWS data connection has been created. For details, see Creating a Data Connection.

• A DWS database has been created. For details, see Creating a Database.

Creating a Database Schema

1. Log in to the DataArts Studio console by following the instructions in Accessing the DataArts Studio Instance Console.

2. On the DataArts Studio console, locate a workspace and click DataArts Factory.

3. In the left navigation pane of DataArts Factory, choose Data Development > Develop Script.

4. In the script development menu, click . Expand a DWS data connection, select the database to be configured, and expand the directory level to schemas. Then right-click schemas and select Create Schema from the shortcut menu.

5. In the displayed dialog box, set the schema parameters based on Table 1.

   Table 1 Creating a database schema

   Parameter	Mandatory	Description
   Mode Name	Yes	Name of a database schema.
   Description	No	Descriptive information about the database schema.

6. Click OK.

Related Operations

• Modify a database schema: In the script development menu, click . Expand a data connection to the target database schema, right-click the database schema name, select Edit, and modify the database schema information.

• Delete a database schema: In the script development menu, click . Expand a data connection to the target database schema, right-click the database schema name, select Delete, and click OK in the displayed dialog box.

  Note

  • The default database schema cannot be deleted.

  • Deleted database schemas cannot be recovered. Exercise caution when performing this operation.

last updated: 2025-07-09 16:05 UTC - commit: 61336f3c2e25ce26cb038bce82678d028fe5d438