Add and Manage Custom Templates

Recent Pages

Add and Manage Custom Templates

Last updated: 2024-11-01 15:58:21

When the system template cannot meet the needs of actual projects, users can define frequently used SQL detection statements as templates for reuse in projects.
Create Custom Templates
Support users in creating custom monitoring rule templates using SQL expressions.
1. Go to Rule Templates > Custom Template, click the Add button, and the template creation window will pop up.
2. In the template creation interface, configure template dimension, applicable objects, template description, and SQL expression to complete the template creation.
﻿
﻿
﻿
Information
Details
Template Name
Custom Definition Rule Template Name
Template Type
Template Check Objects, Table or Field
Template Dimension
Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Applicable Engine
Supports Hive, Spark, DLC, TCHouse-D, and Doris.
Template Description
Applicable objects for this rule templates: Table, Field
SQL Expression
Fill in a segment of SQL statement, and you can use Predefined Parameter Variables in SQL to meet more usage scenarios.
Note:
The output must be One Row One Column, meaning the result must be a Fixed value (it can be characters or a numerical value);
If the result contains multiple rows, the system will automatically take the first row.
You can use predefined parameter variables in SQL, which can be filled in by the actual users.

1. Current detection rule associated Main Table: ${table_1};
2. Fields in the Main Table associated with the current detection rule: ${table_1.column_1}, ${table_1.column_2}...${table_1.column_n};
3. Support associating with one other table under the same data source and library: ${table_2} or ${table_3}...${table_n}, note that only one table is supported;
4. Associated with fields from other tables: ${table_2.column_1}, ${table_2.column_2}...${table_2.column_n};
5. Set where filter parameters: use ${param_1}...${param_n};
6. Use time parameters, for example: ${yyyy-MM-dd-1d}.
Custom Template List
﻿
﻿
﻿
Information
﻿
Details
Template Name
﻿
Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Template Description
﻿
Description information for this custom template
Template Type
﻿
Applicable objects for this rule templates: Table, Field
Dimension
﻿
Check Dimensions of Custom Definition Rules. Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Applicable Engine
﻿
Applicable engines for this rule template
Reference Count
﻿
Number of times the rule template is referenced by detection tasks
Update Time
﻿
Last update time of the rule template
Created by
﻿
Creator of the rule template
Operation
Editing
Edit rule template, available for editing the same configuration items as creating the template
﻿
Delete
Delete a single or multiple custom rule templates
﻿
Version Record
View the historical version update record of the rule template, comparison feature supported
﻿
﻿
﻿
﻿
﻿
﻿

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support

tencent cloud

Recent Pages

Add and Manage Custom Templates

Create Custom Templates

Custom Template List

Was this page helpful?

Was this page helpful?

Information	Details
Template Name	Custom Definition Rule Template Name
Template Type	Template Check Objects, Table or Field
Template Dimension	Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Applicable Engine	Supports Hive, Spark, DLC, TCHouse-D, and Doris.
Template Description	Applicable objects for this rule templates: Table, Field
SQL Expression	Fill in a segment of SQL statement, and you can use Predefined Parameter Variables in SQL to meet more usage scenarios. Note: The output must be One Row One Column, meaning the result must be a Fixed value (it can be characters or a numerical value); If the result contains multiple rows, the system will automatically take the first row. You can use predefined parameter variables in SQL, which can be filled in by the actual users. 1. Current detection rule associated Main Table: ${table_1}; 2. Fields in the Main Table associated with the current detection rule: ${table_1.column_1}, ${table_1.column_2}...${table_1.column_n}; 3. Support associating with one other table under the same data source and library: ${table_2} or ${table_3}...${table_n}, note that only one table is supported; 4. Associated with fields from other tables: ${table_2.column_1}, ${table_2.column_2}...${table_2.column_n}; 5. Set where filter parameters: use ${param_1}...${param_n}; 6. Use time parameters, for example: ${yyyy-MM-dd-1d}.

Information			Details
Template Name			Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Template Description			Description information for this custom template
Template Type			Applicable objects for this rule templates: Table, Field
Dimension			Check Dimensions of Custom Definition Rules. Six dimensions: Accuracy, Uniqueness, Integrity, Consistency, Timeliness, Validity
Applicable Engine			Applicable engines for this rule template
Reference Count			Number of times the rule template is referenced by detection tasks
Update Time			Last update time of the rule template
Created by			Creator of the rule template
Operation	Editing	Edit rule template, available for editing the same configuration items as creating the template
		Delete	Delete a single or multiple custom rule templates
		Version Record	View the historical version update record of the rule template, comparison feature supported

tencent cloud

Sign Up

Log in

Recent Pages

Add and Manage Custom Templates

Create Custom Templates

Custom Template List

Was this page helpful?

Was this page helpful?