Support ability to alter schema/database and rename

[mwufigma]

Terraform CLI and Provider Versions

Terraform CLI version: >= 1.5.0
Snowflake provider version: 0.68.0

Use Cases or Problem Statement

When we try to update the name of a schema in Terraform, it attempts to drop and re-create it. We do not want this behavior and would need it to ALTER SCHEMA RENAME ....

Proposal

Implement something similar to the solution to this issue #891 but for schemas and databases

How much impact is this issue causing?

High

Additional Information

No response

[sfc-gh-asawicki]

Hey @mwufigma. Thanks for creating the issue.

We are supporting renames for the schema. We changed the schema implementation lately (check https://github.com/Snowflake-Labs/terraform-provider-snowflake/releases/tag/v0.73.0). The rename happens here:

terraform-provider-snowflake/pkg/resources/schema.go

Line 179 in 8fbc5cf

if d.HasChange("name") {

. I have also confirmed that in this test:

terraform-provider-snowflake/pkg/resources/schema_acceptance_test.go

Line 35 in 8fbc5cf

func TestAcc_SchemaRename(t *testing.T) {

rename is behaving correctly.

You may be changing another parameter that causes a recreation.

Can you upgrade to the newer provider version first? If this does not help, could you provide the configurations you are using that are causing the issue?

[sfc-gh-asawicki]

Hey @mwufigma, I will close this issue; please open a new one if you are experiencing problems with renaming in the more recent versions of the provider.