Dynamic Table does not update query on change

[MyJBMe]

Terraform CLI and Provider Versions

Terraform: 1.3.9
Snowflake provider: 0.76.0

Terraform Configuration

snowflake = {
  source  = "Snowflake-Labs/snowflake"
  version = "~> 0.76.0"
}

resource "snowflake_dynamic_table" "dynamic" {
  name     = var.TABLE_NAME
  database = var.DATABASE_NAME
  schema   = var.SCHEMA_NAME

  warehouse = "WAREHOUSE"

  target_lag {
    maximum_duration = "9 minutes"
  }

  query     = templatefile("${path.module}/dynamic_table.sql.tmpl", {
    DATABASE_NAME = var.DATABASE_NAME,
    SCHEMA_NAME   = var.SCHEMA_NAME,
    TABLE_NAME    = var.TABLE_NAME
  })
}

Expected Behavior

When updating the SQL template file I expect the dynamic table to change as well after applying.

Actual Behavior

When planning changes, terraform detects a change in the SQL templatefile and provides those changes visually before approving. Nonetheless it does not update inside snowflake. The only way it is "updated" is to rename the resource so that TF deletes the old version and creates a new one with the right script...

Steps to Reproduce

1. Create template file with legit SQL
2. terraform apply
3. Change template file
4. 'terraform apply' again

How much impact is this issue causing?

High

Logs

No response

Additional Information

No response

[sfc-gh-asawicki]

Hey @MyJBMe. Thanks for reporting the issue.

The update is omitting the case with the query update. I will work on it in the upcoming days.