Curious to know the use cases fitment of Terraform vs SchemaChange

[ankitsr92]

** What are you trying to accomplish? **
Decide between SchemaChange and Terraform Snowflake Provider for Snowflake Object Management

** What options have you tried so far ? **
Want to understand from Snowflake POV what is the use case where SchemaChange is usefull or Terraform is. Since both are managed by SnowflakeLabs and based on my understanding both can do the same job of managing Snowflake Objects so which one to choose and when.

Terraform Support alot of resources ( Snowflake Objects ) ex -: Integrations, Warehouses, Privilege Grants etc which SchemaChange can also deploy if we create files containing the SQL statement to create and update them. Isn't it?

Now the plus side of Terraform seems to provide is better State management i.e. upon changes or removal Terraform handles it automatically rather for schemachange I don't see any option to Rollback or Revoke changes. Example Privileges changes would invoke Terraform to revoke existing and apply new. Rather Schemachange would involve adding both Revoke and Grant Commands.

But I want to know if there are a good comparison between these two helping customers choose one or the other.