Creating a Database

Prerequisites

• You have already enabled the corresponding cloud services.
• A data connection has been created. For details, see Creating a Data Connection.
• MRS API connections cannot be used to manage databases in a visualized mode. You are advised to create a database using SQL scripts.
• Before deleting a database, ensure that the database is not in use and is not associated with any data tables.

Creating a Database on the DataArts Factory Console

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
   
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 . Right-click the data connection for which you want to create a database, and choose Create Database from the shortcut menu. Set the parameters based on Table 1.

   Table 1 Creating a database

   Parameter	Mandatory	Description
   Database Name	Yes	Name of a database. The naming rules are as follows: DLI: The value must contain only numbers, letters, and underscores (_). It cannot start with an underscore (_) or contain only numbers. DWS: The value must contain only numbers, letters, and underscores (_). It cannot start with an underscore (_) or contain only numbers. MRS Hive: The value must contain 1 to 128 characters, including only letters, numbers, and underscores (_). It must start with a number or letter and cannot contain only numbers.
   Description	No	Descriptive information about the database. The requirements are as follows: DLI: The value contains a maximum of 256 characters. DWS: The value contains a maximum of 1,024 characters. MRS Hive: The value contains a maximum of 1,024 characters.

4. Click OK.

Modifying a Database

1. In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.
2. In the menu on the left, click . Expand the data connection where the database is created, right-click the database name, and choose Modify from the shortcut menu.
3. In the Modify Database dialog box displayed, modify the database information.
4. Click Yes.

Deleting a Database

1. In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.
2. In the menu on the left, click . Expand the data connection where the database is created, right-click the database name, and choose Delete from the shortcut menu.
3. In the displayed data connection list, click Delete.
4. Click Yes.