Please avoid destroying Snowflake schema if not empty

[hongbo-miao]

Terraform CLI and Provider Versions

• Terraform: v1.7.4
• Provider: v0.88.0

Use Cases or Problem Statement

Currently use Terraform to manage Snowflake schema has high risk.

Proposal

It would be great to support avoiding destroy Snowflake schema if has any tables inside. Thanks!

For instance, AWS Terraform modules will prevent the destruction of a resource if there are any elements nested within it. For example, if there are IAM users within an IAM group, the destruction process will fail with an error:

│ Error: deleting IAM Group (MyIAMGroup): DeleteConflict: Cannot delete entity, must remove users from group first.
│ 	status code: 409, request id: 3f99ee73-64d3-4b26-8d82-affddbb7a0d5

Likewise, attempting to destroy a S3 bucket containing files will also result in failure.

How much impact is this issue causing?

High

Additional Information

• Related feature request: Please avoid destroying Snowflake database if not empty #2713
• I am currently using two workaround ways to prevent it got dropped
  • Terraform's prevent_destroy = true
  • Transfer database ownership

[sfc-gh-asawicki]

Hey @hongbo-miao. Thanks for the suggestion.

The answer is the same as in #2713.