Updated on 2024-08-30 GMT+08:00

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. for example, the MRS service.
  • 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 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 . 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.
    • MRS Spark: 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.
    • MRS Spark: The value contains a maximum of 1,024 characters.
  5. Click OK.

Related Operations

  • Modify a database: In the script development menu, click . Expand a data connection, right-click a database name, select Edit, and modify the database information.
  • Delete a database: In the script development menu, click . Expand a data connection, right-click a database name, select Delete, and click OK in the displayed dialog box.

    Deleted databases cannot be recovered. Exercise caution when performing this operation.