[Bug]: snowflake_task (Resource)

[olevenkov]

Terraform CLI Version

1.8.5

Terraform Provider Version

0.92.0

Terraform Configuration

I am facing issues with "enabled  = true" even it set to true when deploying it turn into false in state...

resource "snowflake_task" "test_task" {
  comment = "task with allow_overlapping_execution"

  database = "database"
  schema   = "schema"

  name          = "test_task"
  sql_statement = "select 1 as c;"

  allow_overlapping_execution = true
  enabled                     = true
}

Category

category:resource

Object type(s)

resource:task

Expected Behavior

enabled = true should be true

Actual Behavior

enabled = true should be true

Steps to Reproduce

deploy task with enabled = true

How much impact is this issue causing?

High

Logs

No response

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @olevenkov. Thanks for reaching out to us.

We are currently reworking tasks, I will add this to the list of known issues here: https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/v1-preparations/ESSENTIAL_GA_OBJECTS.MD.

From what I see, your definition does not contain any of SCHEDULE, AFTER, FINALIZE, or WHEN. Such tasks cannot be resumed in Snowflake; enabled just calls resume. You should see an error when running with environment variable TF_LOG=DEBUG (something like Task <name> should have a SCHEDULE, AFTER, FINALIZE or WHEN to be resumed.).

[sfc-gh-jcieslak]

Hey @olevenkov 👋
Yesterday, we released a new provider version (v0.99.0) that contains a refactored snowflake_task resource. Please, try using it and let me know if the issue persists. Mind the breaking changes that happened in that change by reading the migration guide to adjust your configuration.

[sfc-gh-jcieslak]

Hey @olevenkov
Are you able to confirm that the issue in not happening in the latest version of the provider?

[sfc-gh-jcieslak]

Closing due to long inactivity. As mentioned, the fix was provided in v0.99.0.