[Core] The state directory needs to be built with v1.9+ or Versionless for state_modified_compare_more_unrendered_values

[dbeatty10]

Contributions

• I have read the contribution docs, and understand what's expected of me.

Link to the page on docs.getdbt.com requiring updates

One or more as the same files as https://github.com/dbt-labs/docs.getdbt.com/pull/6239/files

What part(s) of the page would you like to see updated?

In order to avoid this specific cause of false positives, two things need to hold when the state directory is built:

1. state_modified_compare_more_unrendered_values: true
2. The v1.9+ or dbt Cloud Versionless

Put another way, the state directory needs to be built with v1.9+ or Versionless along with state_modified_compare_more_unrendered_values: true within dbt_project.yml.

So if the state directory was built with an older version of dbt or if the state_modified_compare_more_unrendered_values behavior change flag was false (or it was not set), it will need to be rebuilt in order to avoid these false positives during state comparison with state:modified.

Additional information

No response