Skip to content

Are Glue DDQL Rule Types Case Sensitive?

0

Issue

The CustomSql DDQL Rule Type documentation shows examples using both "CustomSql" and "CustomSQL" as the rule types.

However, when I used a capital "QL" this rule syntax, I received this error message in console:

Syntax: CustomSQL <SQL_STATEMENT> <EXPRESSION>

Error:

Error encountered

InvalidInputException (status: 400): DataQuality rules cannot be parsed

See details

{ "message": "DataQuality rules cannot be parsed", "code": "InvalidInputException", "[__type]": "See error.__type for details.", "[Message]": "See error.Message for details.", "time": "2025-12-10T16:28:27.520Z", "requestId": "", "statusCode": 400, "retryable": false }

Request

If DDQL Ruletypes are case sensitive, is there any way we can update the documentation to show only "CustomSql" in examples? - with a loqwecase "ql" only?

asked 9 months ago73 views

1 Answer
0

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

answered 9 months ago

EXPERT

reviewed 9 months 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?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.