Naming Standards & Validation Rules

DQ Rule

A Data Quality Rule (DQ Rule) defines validation logic applied to data to ensure accuracy, completeness, and consistency.

Validation Rules

Property	Value
Blank Allowed	No
Max Length	255 characters
Allowed Characters	Alphabets (A–Z, a–z), Numbers (0–9), Spaces, Dot (.), Underscore (_), Hyphen (-)
Disallowed Characters	Any character not matching the allowed regex
Start Character Restriction	None explicitly defined
Regex / Notes	^[a-zA-Z0-9 ._-]+$

Valid Examples

• Null_Check_Rule

• Data-Quality Rule 1

• Completeness.Rule

• Data Quality Rule

• Rule_01

• Rule-Check

Invalid Examples

• Rule@123 → Contains special character

• Rule#Name → Contains invalid symbol

• Rule/Check → Contains invalid character

• Rule@Check → Contains invalid character

• Rule,Check → Comma not allowed

System Behavior on Validation Failure

• Prevents saving the DQ Rule.

• Displays a validation error message.

• Requires correction before saving.

Best Practices

• Use descriptive DQ Rule names.

• Follow consistent naming conventions.

• Avoid unnecessary special characters.

DQ Function

A DQ Function defines reusable logic used within Data Quality Rules for validation and transformation.

Validation Rules

Property	Value
Blank Allowed	No
Max Length	255 characters
Allowed Characters	Alphabets (A–Z, a–z), Numbers (0–9), Spaces, Dot (.), Underscore (_), Hyphen (-)
Disallowed Characters	Any character not matching the allowed regex
Start Character Restriction	None explicitly defined
Regex / Notes	^[a-zA-Z0-9 ._-]+$

Valid Examples

• Validate_Null

• Format-Check

• Function.Rule

Invalid Examples

• Function@Rule → Contains invalid character

• Function#1 → Contains invalid symbol

• Function/Check → Contains invalid character

System Behavior on Validation Failure

• Prevents saving the DQ Function.

• Displays a validation error message.

• Requires correction before saving.

Best Practices

• Keep function names reusable and generic.

• Follow consistent naming conventions.

• Avoid unnecessary special characters.

DQ Scheme

A DQ Scheme defines a structured grouping of Data Quality Rules and configurations applied to datasets.

Validation Rules

Property	Value
Blank Allowed	No
Max Length	255 characters
Allowed Characters	Alphabets (A–Z, a–z), Numbers (0–9), Spaces, Dot (.), Underscore (_), Hyphen (-)
Disallowed Characters	Any character not matching the allowed regex
Start Character Restriction	None explicitly defined
Regex / Notes	^[a-zA-Z0-9 ._-]+$

Valid Examples

• DQ Scheme 1

• DataQuality_Scheme

• Scheme-Validation

Invalid Examples

• Scheme@Rule → Contains invalid character

• Scheme#1 → Contains invalid symbol

• Scheme/Validation → Contains invalid character

System Behavior on Validation Failure

• Prevents saving the DQ Scheme.

• Displays a validation error message.

• Requires correction before saving.

Best Practices

• Use meaningful scheme names aligned with the domain or purpose.

• Maintain consistency across DQ configurations.

• Avoid unnecessary special characters.

---

Copyright © 2026, OvalEdge LLC, Peachtree Corners, GA, USA.