Hi,
There is a requirement from the project team to design a Synapse based solution which has reusable load assurance and quality assurance controls added to it.
The idea is that for any source entity to be ETLed to target, it could use these built QA code blocks/modules in the pipeline.
A catch here is that for different source entities a handful of these QA rules can be embedded or for others none or all.
Appreciate guidance here.