[Feature]: account-level resource monitor

[thinkerhuang]

Company Name

No response

Use Cases or Problem Statement

In the preview version, there was a function called set_for_account to control the resource monitor level.
However, in the major version, it appears to have been deprecated. It would be helpful if this function could be used again.

Category

category:resource

Object type(s)

No response

Proposal

No response

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hey @thinkerhuang 👋
The current resource_monitor resource is designed to only manage itself, not the connection it has. The assignment was moved to the objects that can set resource monitor on themselves (i.e. ALTER USER SET RESOURCE_MONITOR should be only called in user resources; same for account). The current account resource is more designed to create and manage accounts from the organization level. There will be a new resource that is dedicated for altering the current account. For now, you can use either https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/account_parameter or https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/execute resource to set it on account.