(Optional) Creating a Database Schema

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

Prerequisites

Creating a Database Schema

  1. Log in to the DataArts Studio console. Locate an instance and click Access. On the displayed page, locate a workspace and click DataArts Factory.

    **Figure 1** DataArts Factory

    Figure 1 DataArts Factory

  2. In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.

  3. In the menu on the left, click image1. Click a DWS data connection name, select the database to be configured, and expand the directory level to schemas. Then right-click schemas, and choose Create Schema from the shortcut menu.

  4. 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.

  5. Click OK.

Modifying a Database Schema

  1. In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.

  2. Choose image2 from the menu on the left, click the data connection name, select a database, and expand the directory level to the database schema you want to modify. Right-click the database schema name and choose Modify from the shortcut menu.

  3. In the displayed dialog box, modify the description of the database schema.

  4. Click OK.

Deleting a Database Schema

Note

  • The default database schema cannot be deleted.

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

  1. In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.

  2. Choose image3 from the menu on the left, click the data connection name, select a database, and expand the directory level to the database schema you want to delete. Right-click the database schema name and choose Delete from the shortcut menu.

  3. In the displayed dialog box, click OK.