Does GX support date format check?

[adeola]

@lauraz

format of “yyyy-MM-dd”, is there a way to achieve that?
regex like ‘^\d{4}-\d{2}-\d{2}$’ doesn’t seem a good idea since it won’t fail date like ‘0000-21-89’ or ‘2023-02-29’

I think following this guidance in our documentation would be your best option. It details how to instantiate UnexpectedRowsExpectation to define a custom Expectation. In your case you could create a subclass of UnexpectedRowsExpectation and implement the SQL logic that validates whether the rows in a column conform to your expected date format.