Snowflake-Labs / terraform-provider-snowflake

Terraform provider for managing Snowflake accounts
https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest
MIT License
532 stars 413 forks source link

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

Open sfc-gh-amdeshpande opened 2 days ago

sfc-gh-amdeshpande commented 2 days ago

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?

sfc-gh-jmichalak commented 2 days ago

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.