How can we validate data integrity (e.g. after sql schema change)?

FAQs
1

If you want automated tests for your data integrity, the best way is to run tests against the REST API of a running cube container.