[Feature]: Automating the authentication for azure_consent_url for Snowflake Storage Integration (Blob) with terraform

[sfc-gh-amdeshpande]

Use Cases or Problem Statement

Currently, when creating storage integration on Snowflake for Azure blob storage, there is a manual intervention required to "Accept" the connection with azure_consent_url. The ask is to add a feature in terraform to automate this step, so as to avoid manual intervention of any kind.
https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/storage_integration#azure_consent_url

Category

category:resource

Object type(s)

resource:storage_integration

Proposal

Possibly add another parameter (boolean) which can be default value as 'accept' which terraform can use for accepting the grants with azure_consent_url.

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 @sfc-gh-amdeshpande 👋

Storage integration is a resource that will be redesigned (see the roadmap). We'll examine this during the rework. We welcome testing and implementation on the provider side by following our contribution guide.