[Feature]: terraform resource for creating session policy

[rahulgoyal01]

Company Name

No response

Use Cases or Problem Statement

Hi Team,

I didn't find any resource block for creating session policy. As of now using snowflake_execute to create them. Request you if you can develop the feature and add to upcoming provider release.

Category

category:resource

Object type(s)

No response

Proposal

the resource able to support the parameter supported on snowflake CREATE SESSION POLICY as follows:

CREATE [OR REPLACE] SESSION POLICY [IF NOT EXISTS]
[ SESSION_IDLE_TIMEOUT_MINS = ]
[ SESSION_UI_IDLE_TIMEOUT_MINS = ]
[ ALLOWED_SECONDARY_ROLES = ( [ { 'ALL' | <role_name> [ , <role_name> ... ] } ] ) ]
[ COMMENT = '<string_literal>' ]

How much impact is this issue causing?

Low

Additional Information

No response

Would you like to implement a fix?

• Yeah, I'll take it 😎

[sfc-gh-jmichalak]

Hi @rahulgoyal01 👋

Session policies are on our Remaining Objects list. We will rework them in the future.

As a workaround, please use execute.

Also, this is a duplicate of #2870