[Feature]: Add support for optional/default arguments for snowflake_function resources

[deanmorin]

Use Cases or Problem Statement

I want to create a function that has an optional/default argument, as specified in the Snowflake Documentation.

Category

category:resource

Object type(s)

resource:function

Proposal

Add a default argument to the arguments block in the snowflake_function resource. This is identical to the same proposal for procedures.

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-jmichalak]

Hi @deanmorin 👋
Functions and procedures are currently being reworked, and this will be supported in one of the next releases. cc @sfc-gh-asawicki

[sfc-gh-asawicki]

Hey @deanmorin.

In v0.100.0, we have introduced new function resources. Default values for arguments are now supported (with some Snowflake limitations). Please check it out and let us know if this solves your need.

[deanmorin]

@sfc-gh-asawicki I don't have anymore functions with default args, but I tried it out for procedures in v1.0.0 and so far so good!

BTW I did run into an issue when switching to the new resource type #3297

[sfc-gh-asawicki]

Hey @deanmorin.

I will close this issue then as it was added to functions.

About the #3297 - let's continue there.