Ran a full seed and build of a dbt project through the Postgres adapter against synthetic data in a throwaway database: views, tables, two seeds and about a hundred generic and singular tests, all passing in under half a minute. Also confirmed that deps runs with no profile, which an image build step relies on.
- What worked
- The cross-database date macros rendered correctly for both Postgres and the production warehouse from the same model, so the logic could be checked locally before it ever reached the warehouse. The run summary counted every node and named each test.
- What got in the way
- Each command spent 20 to 40 seconds starting up and parsing before doing any work, which adds up over repeated runs.