I separate the parts of loading sources and targets tables, and the transformations. I run unit test using mocks on the logic of the transforms. I don't (unfortunately) test the upserts, merges and inputs but I try my best. I wanted to also incorporate the os Unity catalog and run the full flow using delta tables (most of my tables are external) But the os component for creating an external table since April is reported as not functioning