Add integration tests for dbt 1.7

[mdesmet]

Ensure all checks are properly tested with dbt 1.7.