[CT-793] [Feature] Testable _tmp tables in incremental models

[NiallRees]

Is this your first time opening an issue?

• [X] I have read the expectations for open source contributors

Describe the Feature

Currently, it's only possible to apply dbt tests to the final table of an incremental model. There are circumstances where it would be useful to apply tests (both singular and generic) to the incremental _tmp table created by dbt in an incremental model. In large tables, it would drastically increase the speed and performance of tests by only tested new/updated data.

Describe alternatives you've considered

No response

Who will this benefit?

No response

Are you interested in contributing this feature?

No response

Anything else?

No response