[Feature]: Support is_memoizable for SQL functions

[lepepe-stack]

Use Cases or Problem Statement

We are using a memoizable function that returns an array of ids which is extensively used in many sqls to validate existence.

It is currently not supported to pass memoizable boolean parameters in the snowflake provider however SDK implementation does exist for it.

Category

category:resource

Object type(s)

resource:function

Proposal

We want to be able to pass a boolean is_memoizable in resource block. Same way how it is currently supported for is_secure flag.

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

Hey @lepepe-stack 👋
As we are focusing right now on preparing essential resources for v1 (including functions). I'll add this issue as one of the things that needs to be done for functions.

[lepepe-stack]

Thanks @sfc-gh-jcieslak for the quick response. I couldn't find much details around execution timelines, but do you know approximately when the team could tackle this?

[sfc-gh-jmichalak]

Hi @lepepe-stack 👋 We only provide a general roadmap linked above. According to it, we'll be working on functions to prepare them for v1. But we don't have any specific date.

[sfc-gh-asawicki]

Hey @lepepe-stack.

In v0.100.0 we have introduced new function resources. They are split into dedicated resource. SQL one is not yet supporting memoizable but we will shortly address it.