snowflake_oauth_integration does not expose network policy

[josh-gree]

Terraform CLI and Provider Versions

0.86.0

Use Cases or Problem Statement

OAUTH SECURITY INTEGRATION allow for the setting of network policy this isn't exposed in the resource

Proposal

Add network policy

How much impact is this issue causing?

High

Additional Information

No response

[sfc-gh-asawicki]

Hey @josh-gree. Thanks for creating the issue.

We will redesign the existing resources on our road to V1 (https://github.com/Snowflake-Labs/terraform-provider-snowflake/blob/main/ROADMAP.md#our-roadmap). We will address it then.

[josh-gree]

@sfc-gh-asawicki Do you have any suggestions for workarounds in the meantime? Is there a way to run generic Alter statements perhaps?

[sfc-gh-asawicki]

There is a https://registry.terraform.io/providers/Snowflake-Labs/snowflake/latest/docs/resources/unsafe_execute resource. You can basically run any statement there. This is a dangerous resource, though. Please make sure you read its documentation before using it.

[josh-gree]

Thanks - implications understood!

[sfc-gh-jmichalak]

Hey @josh-gree 👋 The new version v0.93.0 provides a new resource for oauth: oauth_integration_for_custom_clients. This resource contains network_policy, so please migrate fromoauth_integration to this new resource. Please follow the migration guide.