Creating a Database¶
After creating a data connection, you can create a database on the console or using a SQL script.
(Recommended) Console: You can directly create a database on the DataArts Studio DataArts Factory console with no code.
SQL script: You can also develop and execute a SQL script for creating a database in the SQL editor of DataArts Studio's DataArts Factory module or a data lake product, and then use the script to create a database.
This section describes how to create a database on the DataArts Factory console.
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¶
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¶
In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.
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.
Click OK.
Modifying a Database¶
In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.
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.In the Modify Database dialog box displayed, modify the database information.
Click Yes.
Deleting a Database¶
In the left navigation pane of DataArts Factory, choose Development > Develop Script or Development > Develop Job.
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.In the displayed data connection list, click Delete.
Click Yes.