[Feature]: Allow creating serverless alerts by omitting the `warehouse` parameter

[pfnsec]

Use Cases or Problem Statement

We'd like to create serverless alerts. Snowflake docs specify that you can do so by omitting the warehouse parameter: https://docs.snowflake.com/en/user-guide/alerts#creating-an-alert

The provider currently specs this as a required parameter.

Category

category:resource

Object type(s)

No response

Proposal

No response

How much impact is this issue causing?

Medium

Additional Information

No response

Would you like to implement a fix?

• [ ] Yeah, I'll take it 😎

[sfc-gh-asawicki]

Hey @pfnsec. Thanks for reaching out to us.

The alert redesign is scheduled for later this year (check here), and we will consider it then.

For now, you can use https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute.