This will support persisting tests results as views. See the attached issue for more information.
Solution
Users can use strategy="view" in the config block in their dbt tests to create the test results as a view. This allows the results to update along with underlying data, e.g. when the underlying data is in a dynamic table.
[x] I have run this code in development and it appears to resolve the stated issue
[x] This PR includes tests, or tests are not required/relevant for this PR
[ ] This PR has no interface changes (e.g. macros, cli, logs, json artifacts, config files, adapter interface, etc) or this PR has already received feedback and approval from Product or DX
resolves dbt-labs/dbt-core#6914 docs dbt-labs/docs.getdbt.com/#
Problem
This will support persisting tests results as views. See the attached issue for more information.
Solution
Users can use
strategy="view"in theconfigblock in their dbt tests to create the test results as a view. This allows the results to update along with underlying data, e.g. when the underlying data is in a dynamic table.Checklist