improve standard tests

[rudolfix]

Write a test helper asserting a happy path for each pipeline

1. pipeline is run against all destinations with a full_refresh
2. pipeline loads correctly
3. for each table in the schema there's data in the destination that conforms to the schema