[Docs]: Examples for creating SQL-based snowflake_procedure resource

[paulfry-payroc]

Company Name

No response

Object type(s)

resource:procedure

Documentation Link

https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/examples/resources/snowflake_procedure/resource.tf

Description

There is only an example of a Javascript-based procedure.

Whereas I'm working on a SQL-based stored proc & running into issues, but without an example, can't see the typical parameters required.

References

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jcieslak]

Hey @paulfry-payroc 👋
We are going to refactor the procedure resource as part of preparing GA objects for V1. The documentation will also be improved, and we'll include more examples. Do you still have any issues with using the procedure resource, or is it only referring to documentation improvements?

[paulfry-payroc]

ah fantastic! Having a sql-specific resource (and supporting doc) will resolve my issue 👍

[sfc-gh-asawicki]

Hey @paulfry-payroc.

This is the new resource with updated documentation: https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/procedure_sql. Basic example is included. Please check it out and let us know.