Revoke permissions from share?

[michaelkahan]

Hello,

I am attempting to revoke permissions from a share, but thus far have not been able to via Terraform.

Specifically, I am able to grant permissions using snowflake_view_grant, but when I destroy the grant it is not reflected in Snowflake. Snowflake still shows the original grant assigned to the share despite Terraform indicating a success.

Is this a known limitation or is there another step required? Thank you!

---

Example TF Code:

# Grant Permission to Share
resource "snowflake_view_grant" "test_share" {
  database_name = snowflake_database.db.name
  privilege     = "select"
  schema_name   = "MY_SCHEMA"
  view_name     = "TEST_VIEW"
  shares = [
    "MY_SHARE"
  ]
}

Result of terraform destroy, however the permission is not actually revoked from the share in Snowflake:

  # snowflake_view_grant.test_share will be destroyed
  - resource "snowflake_view_grant" "test_share" {
      - database_name     = "MY_DATABASE" -> null
      - id                = "MY_DATABASE|MY_SCHEMA|TEST_VIEW|select|false" -> null
      - on_future         = false -> null
      - privilege         = "select" -> null
      - roles             = [] -> null
      - schema_name       = "MY_SCHEMA" -> null
      - shares            = [] -> null
      - view_name         = "TEST_VIEW" -> null
      - with_grant_option = false -> null

Note: - shares = [] -> null is not displaying the name of the original share

[michaelkahan]

Hey all - Following up on this note. Any insight on how to address this issue?