Create an ArgoDB SQL task

Procedure

1. On the Dataphin home page, navigate to the top menu bar and select Development > Data Development.

2. On the Development page, select Project from the top menu bar (Dev-Prod mode requires environment selection).

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

4. In the New ArgoDB SQL Task dialog box, configure the following parameters.

   Parameter	Description
   Task Name	Enter the offline computing task name. The length must be 256 characters or fewer and cannot include vertical lines (|), forward slashes (/), backslashes (\), colons (:), question marks (?), angle brackets (<>), asterisks (*), or quotation marks (").
   Schedule Type	Choose the task's Schedule Type, which includes: Recurring Task Node: The task automatically joins the system's recurring schedule. Manual Node: Tasks must be triggered manually.
   Select Directory	Select the folder to store the task. If no folder exists, you can Create Folder by following these steps: Single click the icon above the task list on the left to open the Create Folder dialog box. In the Create Folder dialog box, enter the folder Name and choose the Directory location as needed. Click Confirm.
   Use Template	Toggle the Use Template switch to decide whether to use a code template. If enabled, also select the Select Template and Template Version. Code templates provide read-only task code. You only need to configure the template parameters to complete development. For more information, see the new offline computing template.
   Description	Provide a brief description of the task, within 1000 characters.

5. Click Confirm.

6. In the code editor on the ArgoDB SQL task tab, write the code for the ArgoDB SQL offline computing task and then click Run above the code editor.

7. In the right-side sidebar, click Property. In the Property panel, configure the task's Basic Information, Runtime Parameter, Schedule Property (for recurring tasks), Schedule Dependency (for recurring tasks), Runtime Configuration, and Resource Configuration.

   • Basic Information

     Define the task name, owner, description, and other basic details. For more information, see configure basic task information.

   • Runtime Parameter

     Set values for parameter variables used in your task. During scheduling, these variables are automatically replaced with the specified values. For more information, see offline task runtime parameter configuration.

   • Schedule Property (recurring task)

     For a Recurring Task, configure the schedule properties in addition to the Basic Information. For more information, see configure offline task schedule properties.

   • Schedule Dependency (recurring task)

     For a Recurring Task, configure the schedule dependencies in addition to the Basic Information. For more information, see configure offline task schedule dependencies.

   • Runtime Configuration

     Set the task-level runtime timeout and rerun policy. If not specified, the tenant-level defaults apply. For more information, see compute task runtime configuration.

   • Resource Configuration

     Configure a scheduling resource group for the task. When the task is scheduled, it consumes the resource quota of this resource group. For more information, see Configure resources for a computing task.

8. In the ArgoDB SQL task tab, save and submit the task.

   1. Click the icon above the code editing area to save the code.

   2. Click the icon above the code editing area to submit the code.

9. In the Submitting Log page, you need to confirm the Submission Content and the results of the Pre-check, and fill in the remarks. For more information, see offline computing task submission instructions.

10. Once confirmed, click Confirm And Submit.