Grant access to new tables with `snowflake_grant_privileges_to_share`

[josescuderoh]

Terraform CLI and Provider Versions

0.89.0

Use Cases or Problem Statement

Currently, when granting access to all tables in one schema, there's no way to grant new tables to the share if these are added after the plan was applied. This problem is solved in snowflake_grant_privileges_to_account_role with the always_apply flag, which will produce a plan every single time and will grant access to new tables.

Proposal

Currently we're working around this by tainting and forcing recreation of the resource during CICD, but a better solution would be to add the always_apply flag to the resource snowflake_grant_privileges_to_share

How much impact is this issue causing?

Medium

Additional Information

No response

[sfc-gh-asawicki]

Hey @josescuderoh. Thanks for reaching out to us.

We have it on our radar (it was discussed here: https://github.com/Snowflake-Labs/terraform-provider-snowflake/discussions/2417#discussioncomment-8776775). We don't have a timeline we can share yet.

[josescuderoh]

Awesome, thank you for info @sfc-gh-asawicki - I'll watch out for it.