- Newest
- Most votes
- Most comments
AWS Glue Data Quality Definition Language (DQDL) rule types are indeed case sensitive. Based on the error you encountered when using "CustomSQL" instead of "CustomSql", it appears that the correct format requires the specific casing as "CustomSql" with a lowercase "ql".
This is consistent with how case sensitivity works in other AWS Glue components. For example, in AWS Glue transformations like FormatCase, there are specific case types that must be used exactly as defined: "CAPITAL", "LOWER", "UPPER", and "SENTENCE". Similarly, in AWS Glue DataBrew, case transformation operations like SENTENCE_CASE, LOWER_CASE, and CAPITAL_CASE must be specified with their exact casing.
The inconsistency in the documentation showing both "CustomSql" and "CustomSQL" is likely an error, and the correct format appears to be "CustomSql" based on your experience with the error message.
Sources
FormatCase class - AWS Glue
SENTENCE_CASE - AWS Glue DataBrew
LOWER_CASE - AWS Glue DataBrew
CAPITAL_CASE - AWS Glue DataBrew
Relevant content
asked 3 years ago
asked 3 years ago
asked 2 years ago
- AWS OFFICIALUpdated 2 years ago

Thanks - sounds like the documentation needs to be updated then. Is the documentation opensource?- can I update it on GitHub? If so - whats the link?