Create an Inceptor SQL task

Procedure

1. At the top menu bar of the Dataphin home page, select Development > Data Development.

2. On the top menu bar of the Development page, select a project. In Dev-Prod mode, also select an environment.

3. In the left navigation pane, choose Data Processing > Script Task. In the Script Task list, click the icon and choose Inceptor SQL.

4. In the Create Inceptor SQL Task dialog box, configure the parameters.

   Parameter	Description
   Task Name	Enter the task name. Maximum 256 characters. Cannot contain | / \ : ? <> * ".
   Schedule Type	Select a Schedule Type: Recurring Task: Automatically included in the system's periodic scheduling. One-Time Task: Runs only when manually triggered.
   Select Directory	Select the folder to store the task. If no folder exists, create one using the following steps: In the upper-left corner of the task list, click the icon to open the Create Folder dialog box. In the New Folder dialog box, enter a Name and specify the Select Directory. Click Confirm.
   Use Template	Toggle the Use Template switch to decide whether to apply a code template. If enabled, select the Template and Version. Code templates are read-only. Configure the template parameters to develop code. the referenced document.
   Description	Enter a task description. Maximum 1,000 characters.

5. Click Confirm.

6. Write the Inceptor SQL code in the code editor, then click Precompile above the code editor to check the syntax.

7. After precompilation succeeds, click Run to execute the code.

8. In the right sidebar, click Property. In the Property panel, configure Basic Information, Runtime Parameter, Schedule Property (recurring tasks), Schedule Dependency (recurring tasks), Runtime Configuration, and Resource Configuration.

   • Basic Information

     Define the task name, responsible individual, description, and other basic details. the referenced document.

   • Runtime Parameter

     Assign values to parameter variables in node properties. During scheduling, variables are replaced with the assigned values. Configure Runtime Parameters for Offline Tasks.

   • Scheduling Properties (Recurring Task)

     For a Recurring Task, configure scheduling attributes in addition to Basic Information. the referenced document.

   • Schedule Dependency (Recurring Task)

     For a Recurring Task, configure scheduling dependencies in addition to Basic Information. the referenced document.

   • Runtime Configuration

     Configure task-level timeout and rerun policies. If not configured, tenant-level defaults apply. the referenced document.

   • Resource Configuration

     Configure a scheduling resource group for the task. During scheduling, the task consumes the resource quota of this group. Configure the resources for a compute task.

9. On the Inceptor SQL task tab, save and submit the task.

   1. Click the icon to save the code.

   2. Click the icon to submit the code.

10. On the Submitting Log page, verify the Submission Content and Pre-check results, then add comments if needed. the referenced document.

11. After review, click Confirm And Submit.