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.
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.