Random password generated did not work in Snowflake

[natashamathur]

Terraform CLI and Provider Versions

• provider registry.terraform.io/hashicorp/random v3.3.2
• provider registry.terraform.io/snowflake-labs/snowflake v0.76.0

Terraform Configuration

output "password_url_ABCD" {
  value     = snowflake_managed_account.ABCD_account.admin_password
  sensitive = true
}

output "password_ABCD_account" {
  value     = snowflake_managed_account.ABCD_account.admin_password
  sensitive = true
}

Expected Behavior

After I created a new snowflake share, I expected that the password output through the above code to give me the correct Admin account password. Both outputs were the same.

Actual Behavior

The passwords did not work and I could not log into the share. I ultimately reached out to Snowflake and they re-set the share.

Steps to Reproduce

terraform output --json

How much impact is this issue causing?

Medium

Logs

No response

Additional Information

We have other shares that were created in the same way. For those the admin_password output worked.

[sfc-gh-jcieslak]

Hey @natashamathur 👋
Not sure what is causing the issue here. Could you elaborate a bit and provide the configurations that you think are invalid?

[natashamathur]

The issue here ended up being that the passwords generated contained escape characters and therefore causing issues when passed through Snowflake. I limited the list of characters that could be used to randomly generated passwords