Creating a Script

Updated on 2022-02-22 GMT+08:00

View PDF

DLF allows you to edit, debug, and run scripts online. You must add a script before developing it.

If a directory exists, you do not need to create one.

Log in to the DLF console.
In the navigation tree of the Data Development console, choose Data Development > Develop Script.
In the directory list, right-click a directory and choose Create Directory from the shortcut menu.

In the displayed dialog box, configure directory parameters. Table 1 describes the directory parameters.

**Table 1** Script directory parameters
Parameter	Description
Directory Name	Name of the script directory. Must consist of 1 to 32 characters and contain only letters, digits, underscores (_), and hyphens (-).
Select Directory	Parent directory of the script directory. The parent directory is the root directory by default.

Currently, you can create the following types of scripts in DLF:

DLI SQL
Hive SQL
DWS SQL
Spark SQL
Flink SQL
RDS SQL
PRESTO SQL script, which is supported only in the AP-Singapore region. After you use the PRESTO SQL script to run the select query statement, the query result is automatically dumped to the s3a://dlf-log-{project_id}/temp directory of the OBS bucket.
Shell

The quantity of scripts is less than the maximum quota (1,000).

In the navigation tree of the Data Development console, choose Data Development > Develop Script.
Create a script using either of the following methods:

Method 1: In the area on the right, click Create SQL Script/Create Shell Script.

Figure 1 Creating an SQL script (method 1)

Figure 2 Creating a shell script (method 1)

Method 2: In the directory list, right-click a directory and choose Create Script from the shortcut menu.

Figure 3 Creating a script (method 2)
Go to the script development page. For details, see Developing an SQL Script and Developing a Shell Script.

Parent topic: Script Development

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.