Pulumi refresh throwing TableGrant error: "* 1 to 6 fields allowed in ID"

[mattotodd]

What happened?

Trying to run a preview/update and as part of that process i run a refresh and get the following error:

error: Preview failed: refreshing urn:pulumi:stack::project::snowflake:index/tableGrant:TableGrant::grant_select_on_sourcedata_to_loader: 1 error occurred:
	* 1 to 6 fields allowed in ID

Expected Behavior

There are no changes to the snowflake grants, so i dont expect any changes there, and this type of refresh has been working fine for months.

Steps to reproduce

run pulumi refresh on a stack with snowflake grants

Output of pulumi about

pulumi about
CLI
Version 3.73.0
Go Version go1.20.5
Go Compiler gc

Additional context

assuming it has to do with the convention im using for the grant ID, but i'm not seeing anything that has changed, so not sure why it started throwing now.

state for this grant:

{
                    "urn": "urn:pulumi:stack::project::snowflake:index/tableGrant:TableGrant::grant_select_on_sourcedata_to_loader",
                    "custom": true,
                    "id": "PROD_SOURCE_DATA|||SELECT|false|true|false|PROD_TRANSFORMER_TEST,PROD_LOADER,PROD_TRANSFORMER|",
                    "type": "snowflake:index/viewGrant:ViewGrant",
                    "inputs": {
                        "__defaults": [
                            "withGrantOption"
                        ],
                        "databaseName": "PROD_SOURCE_DATA",
                        "enableMultipleGrants": true,
                        "onFuture": true,
                        "privilege": "SELECT",
                        "roles": [
                            "PROD_LOADER",
                            "PROD_TRANSFORMER_TEST",
                            "PROD_TRANSFORMER"
                        ],
                        "withGrantOption": false
                    }

Contributing

Vote on this issue by adding a 👍 reaction.
To contribute a fix for this issue, leave a comment (and link to your pull request, if you've opened one already).

[aq17]

Hi @mattotodd , thanks for opening this issue. I'm having trouble repro'ing, but in the latest upstream release, it looks like tableGrant, along with numerous other grant resources, are being deprecated in favor of a new resource GrantPrivilegesToRole https://www.pulumi.com/registry/packages/snowflake/api-docs/grantprivilegestorole/. Would it be possible to port over to that and report if it solves the issue?

[mjeffryes]

Closing due to inactivity