[Feature]: add support for USE_PRIVATELINK_ENDPOINT in terraform provider while reating storage integration

[rahulnbhandari]

Company Name

pepsico

Use Cases or Problem Statement

We are tring to create storage integration ona zure using private link . Althought its supported by the object its not an option to be set via terraform module https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/storage_integration

Example usecase

CREATE OR REPLACE STORAGE INTEGRATION outbound_private_link_int TYPE = EXTERNAL_STAGE STORAGE_PROVIDER = AZURE AZURE_TENANT_ID = 'cc2909f2-ed22-4c89-8e5d-bdc40e5eac26' STORAGE_ALLOWED_LOCATIONS = ('azure://mystorageaccount.blob.core.windows.net/mycontainer/snowflake_privatelink_external_stage_test/') USE_PRIVATELINK_ENDPOINT = TRUE ENABLED = TRUE;

https://docs.snowflake.com/en/user-guide/data-load-azure-private

Category

category:resource

Object type(s)

resource:storage_integration

Proposal

Add a bollean option for USE_PRIVATELINK_ENDPOINT on storage integration

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

Hey @rahulnbhandari. Thanks for creating the issue.

We will address it when reworking storage integration resources. At the moment, we don't have a timeline to share. We won't address it before the GA (https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#feature-gap-closing---the-current-approach).

[JohnMav]

+1 looking to be able to do this on storage integrations as well

[aniruddahchowdhuryJET]

+1, we need this in order to unload data using storage integrations to external stages via privatelink,

[sfc-gh-asawicki]

Hey, I can't share any specific timeline for this addition. We are open for contributions following the guidelines. You can also utilize snowflake_execute in the meantime.

[sfc-gh-jmichalak]

Hi @rahulnbhandari, @enact-murat 👋

We have released v2.8.0 (release, migration guide) with this new field. Enjoy!

[enact-murat]

Awesome thanks for helping me with that PR @sfc-gh-jmichalak and also rest of the team!

[sfc-gh-jmichalak]

Thanks for the feedback :) Closing.