feat: Tasks v1 readiness part3

[sfc-gh-jcieslak]

• [x] Apply comments from https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113
  • [x] Cron https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789842978
  • [x] Resource logic https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789869045
  • [x] Refactor SDK suspend root logic for tasks (and overall suspend logic in SDK/resource) https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789872814
• [x] Tests
  • [x] External changes - https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789903936
  • [x] Add more complicated DAG structures to show the resource can handle more complex structures
  • [x] Calling (as field) - https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789900590
  • [x] Check in one acceptance test why the finalizer task in show_output is not set (is that Snowflake or mapping error).
• [x] Data source
• [x] Examples, documentation, and migration guide
• [x] Keep manually changed files after regeneration https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1802561725
• [x] Make config without $$ escapes needed
• [x] Support session parameters (I think it's already done, but check https://docs.snowflake.com/en/sql-reference/parameters#label-session-parameters)
• [x] Refactor task resuming in task resource (most likely with the use of defer) because currently, there may be cases that error can cause tasks to be not resumed.
• [ ] Analyze non-deterministic test cases (All tests seem to be deterministic, only object_parameter resource tests are causing the AllParameters test to fail)
• [ ] Check test tasks_gen_integration_test.go:937 (and see why it's non-deterministic).
• [x] Move some of the logic to SDK (if possible)
  • [x] https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3170#discussion_r1838382878
• [x] Apply comments https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3170
• [ ] Re-generate and list all the issues with asserts and models

[github-actions[bot]]

Integration tests failure for 6e6797665fade52bcc7291e984122477fdf28951

[github-actions[bot]]

Integration tests failure for 6e6797665fade52bcc7291e984122477fdf28951

[github-actions[bot]]

Integration tests failure for bbba62e318a8b5d13a86469ac4dfe0b24a0af205

[github-actions[bot]]

Integration tests failure for dcc89cdf3b2fb0d97b34839ccc3f347c9a0a43cc