It would be great if there's an API to schema consistency of managed SQL datasets
This can be done manually by going to a managed SQL dataset > settings > connection > test, or by going to dataset > settings > schema > check now. See screenshot.
Internally from developer tools console, it seems like one of the two following private API's are being called.
/dip/api/datasets/managed-sql/test/ /dip/api/datasets/test-schema-consistency
We're building automation around validations and requiring manual clicks in the flow is likely to be missed when there are so many projects & developers.
Dataiku Support confirmed this API does not exist as of Version: 12.1.0.