Terraform not able to manage user parameters

[josescuderoh]

Summary

When creating a user parameter like QUERY_TAG, through terraform, the resource is created but it cannot be read, resulting in the below error every time that one tries to read the plan after creation

│ Error: error reading object parameter err = unsupported object type ...

I'm trying to recreate the below SQL statement, which works if executed in the console:

ALTER USER "MYUSER" SET QUERY_TAG = '\'{\"user\": \"MYUSER\", \"env\" : \"dev\", \"service\" : \"snowflake\"}\''

Likely cause

After digging in the logic a bit, it seems that the function ShowObjectParameter does not support the User object, which causes an error when it's called from ReadObjectParameter or CreateObjectParameter

Steps to reproduce

Create a query tag as:

resource "snowflake_object_parameter" "qt" {
  key         = "QUERY_TAG"
  value       = "somevalue"
  object_type = "USER"
  object_identifier {
    name = snowflake_user.myuser.name
  }
}

Run terraform plan and terraform apply. You should see the above error but you should be able to see the query tag in snowflake with show parameters like '%query_tag%' for user myuser;

[josescuderoh]

realized I should be using session parameters instead of object parameters