Managing Flink Job Templates

The template list displays existing sample templates for Flink SQL jobs. Table 1 describes the parameters in the template list.

The scenarios of sample templates can be different, which are subject to the console.

The template list displays existing sample templates for Flink SQL OpenSource jobs. Table 1 describes the parameters in the template list.

The custom template list displays all Jar job templates. Table 1 describes parameters in the custom template list.

You can create a template using any of the following methods:

• Creating a template on the Template Management page
  1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates.
  2. Click Create Template in the upper right corner of the page. The Create Template dialog box is displayed.
  3. Specify Name and Description.

     Table 4 Template parameters

     Parameter	Description
     Type	Template type Flink SQL job template Flink OpenSource SQL job template
     Name	Template name. The value can contain up to 64 characters. Only letters, digits, hyphens (-), and underscores (_) are allowed. NOTE: The template name must be unique.
     Description	Description of a template. It can contain 0 to 512 characters.

  4. Click OK to enter the editing page.

     The Table 5 describes the parameters on the template editing page.

     Table 5 Template parameters

     Parameter	Description
     Name	You can modify the template name.
     Description	You can modify the template description.
     Saving Mode	Save Here: Save the modification to the current template. Save as New: Save the modification as a new template.
     SQL statement editing area	In the area, you can enter detailed SQL statements to implement business logic. For how to compile SQL statements, see Data Lake Insight SQL Syntax Reference.
     Save	Save the modifications.
     Create Job	Use the current template to create a job.
     Format	Format SQL statements. After SQL statements are formatted, you need to compile SQL statements again.
     Theme Settings	Change the font size, word wrap, and page style (black or white background).

  5. In the SQL statement editing area, enter SQL statements to implement service logic. For how to compile SQL statements, see .
  6. After the SQL statement is edited, click Save in the upper right corner to complete the template creation.
  7. (Optional) If you do not need to modify the template, click Create Job in the upper right corner to create a job based on the current template. For how to create a job, see Creating a Flink Jar Job.
• Creating a template based on an existing job template
  1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
  2. In the row where the desired template is located in the custom template list, click Edit under Operation to enter the Edit page.
  3. After the modification is complete, set Saving Mode to Save as New.
  4. Click Save in the upper right corner to save the template as a new one.

• Creating a template using a created job
  1. In the left navigation pane of the DLI management console, choose Job Management > Flink Jobs. The Flink Jobs page is displayed.
  2. Click Create Job in the upper right corner. The Create Job page is displayed.
  3. Specify parameters as required.
  4. Click OK to enter the editing page.
  5. After the SQL statement is compiled, click Set as Template.
  6. In the Set as Template dialog box that is displayed, specify Name and Description and click OK.
• Creating a template based on the existing job
  1. In the left navigation pane of the DLI management console, choose Job Management > Flink Jobs. The Flink Jobs page is displayed.
  2. In the job list, locate the row where the job that you want to set as a template resides, and click Edit in the Operation column.
  3. After the SQL statement is compiled, click Set as Template.
  4. In the Set as Template dialog box that is displayed, specify Name and Description and click OK.

You can create jobs based on sample templates or custom templates.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates.
2. In the sample template list, click Create Job in the Operation column of the target template. For how to create a job, see Creating a Flink OpenSource SQL Job and Creating a Flink Jar Job.

After creating a custom template, you can modify it as required. The sample template cannot be modified, but you can view the template details.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
2. In the row where the template you want to modify is located in the custom template list, click Edit in the Operation column to enter the Edit page.
3. In the SQL statement editing area, modify the SQL statements as required.
4. Set Saving Mode to Save Here.
5. Click Save in the upper right corner to save the modification.

You can delete a custom template as required. The sample templates cannot be deleted. Deleted templates cannot be restored. Exercise caution when performing this operation.

1. In the left navigation pane of the DLI management console, choose Job Templates > Flink Templates. Click the Custom Templates tab.
2. In the custom template list, select the templates you want to delete and click Delete in the upper left of the custom template list.

   Alternatively, you can delete a template by performing the following operations: In the custom template list, locate the row where the template you want to delete resides, and click More > Delete in the Operation column.

3. In the displayed dialog box, click Yes.