[Bug]: "snowflake_tag_association" failing if table was recreated without a tag outside of Terraform

[dbieliaiev]

Terraform CLI Version

1.9.2

Terraform Provider Version

0.93.0

Terraform Configuration

resource "snowflake_tag" "privacy_tag" {   
  database = "DB" 
  name = "PRIVACY_TAG" 
  schema = "TAG_LIBRARY" 
  allowed_values = ["NO_CLASSIFICATION","OBJECT_ID","PERSONAL_DATA","PII"] 
  comment = "high level column level tagging to categorise sensitive data for Snowflake data classification"
}

resource "snowflake_tag_association" "tag_pii_columns_prod_db" {
  object_identifier {
    name     = "EXAMPLE_TABLE.COLUMN"
    database = "DB"
    schema   = "EXAMPLE_SCHEMA"
  }
  object_type = "COLUMN"
  tag_id      = snowflake_tag.privacy_tag.id
  tag_value   = "PERSONAL_DATA"
}

Category

category:resource

Object type(s)

resource:tag_association

Expected Behavior

Provider identifies that tag was removed from column, plans to add it.

Actual Behavior

Error: sql: Scan error on column index 0, name "TAG": converting NULL to string is unsupported

Steps to Reproduce

1. Create a snowflake_tag_association resource to tag a column
2. Run terraform apply
3. Drop the table
4. Create the same table
5. Run terraform plan or terraform apply

How much impact is this issue causing?

High

Logs

No response

Additional Information

Issue could potentially be around this line ->

terraform-provider-snowflake/pkg/sdk/system_functions.go

Line 28 in da98bc3

Tag string `db:"TAG"`

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @dbieliaiev 👋

Tags will be redesigned as part of https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#preparing-essential-ga-objects-for-the-provider-v1. I will link this issue to https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/v1-preparations/ESSENTIAL_GA_OBJECTS.MD.

[sfc-gh-jmichalak]

Hi @dbieliaiev 👋

We've just released v0.100.0 (release, migration guide) in which we reworked tag associations. Unassigned tags should now be detected and corrected in terraform apply.
Please upgrade to this version and let us know if you have any issues.

[sfc-gh-jmichalak]

Closing due to inactivity.