feat: Task datasource and fixes

[sfc-gh-jcieslak]

Changes

• Fixed the need to enclose config with $$
• Added full datasource support with tests
  • Documentation and examples (v1 candidates; added for resource and datasource)
  • Migration guide (now only for datasource)
  • Extracted schema for regular in filtering
  • Describe wasn't added on purpose, because it seems to mirror values from what we get from the SHOW command (can also add it, but for now it doesn't provide any benefits)

List from previous prs

• [ ] Apply comments https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3170
• [ ] 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
  • [ ] Resource logic https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789869045
  • [ ] 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
• [ ] Move some of the logic to SDK (if possible)
  • [ ] https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3170#discussion_r1838382878
• [ ] 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.
• [ ] Tests
  • [ ] External changes - https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789903936
  • [ ] Add more complicated DAG structures to show the resource can handle more complex structures
  • [ ] Calling (as field) - https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1789900590
  • [ ] For showing how the DAG of tasks could be owned by a role other than the one created with Terraform (also with less privileges, only to run the task).
  • [x] Check in one acceptance test why finalizer task in show_output is not set (is that Snowflake or mapping error).
• [x] Data source
• [ ] Examples, documentation, and migration guide
• [ ] Keep manually changed files after regeneration https://github.com/Snowflake-Labs/terraform-provider-snowflake/pull/3113#discussion_r1802561725
• [x] Make config without $$ escapes needed
• [ ] Support session paramters
• [ ] Analyze non-deterministic test cases
• [ ] Check test tasks_gen_integration_test.go:937 (and see why it's non deterministic).
• [ ] Re-generate and list all the issues with asserts and models

[github-actions[bot]]

Integration tests failure for ed1251592b98654e893e6603f4492bdfdad5b3c3

[github-actions[bot]]

Integration tests failure for 4ba347973ed7175e8ca566d67653229a1e6619d2

[github-actions[bot]]

Integration tests failure for 584a3ca350378be7ea5893e2bd2aca4ccb89ad88