Call procedures from terraform

[jorwoods]

Terraform CLI and Provider Versions

Terraform v1.2.7
snowflake-labs/snowflake v0.76.0

Use Cases or Problem Statement

The team I am on uses stored procedures to produce tables that get consumed by other processes. When a stored procedure is created by Terraform, I looking for a way to have the procedure optionally called upon creation.

Proposal

The procedure should be called again if the body of the procedure changes or if initialization arguments to the procedure change.

How much impact is this issue causing?

Medium

Additional Information

Currently looking at using snowsql with a null resource to accomplish the goal if I can figure out how to pass credentials to it.

[sfc-gh-asawicki]

Hey @jorwoods.

Currently, I would recommend using the https://registry.terraform.io/providers/Snowflake-Labs/snowflake/0.100.0/docs/resources/execute (if you are on v0.100.0 or newer) or https://registry.terraform.io/providers/Snowflake-Labs/snowflake/0.99.0/docs/resources/unsafe_execute (for lower provider versions).

In our internal backlog, we have a task to add a dedicated resource for generic function invocation. It was not yet published on our public roadmap but was hinted in #1630 and #2630.

I will create an issue to track it soon. I will keep this issue opened till I do it.