we are seeing a strange behavior in our

snowflake

stack which is using the

pulumi-snowflake

provider. Our

dev

stack is working fine, but our

prod

stack is giving out an error:

Diagnostics:
  pulumi:pulumi:Stack (snowflake-config-prod):
    time="2022-06-27T17:12:18-07:00" level=error msg="error: 002043 (02000): SQL compilation error:\nObject does not exist, or operation cannot be performed." func="gosnowflake.(*snowflakeConn).queryContextInternal" file="connection.go:356"

since we are almost prod ready but not there, i was debugging this with a colleague @melodic-policeman-1516 .. we actually ran

pulumi down

on the

prod

stack, then we deleted the

prod

stack and re-created it from scratch and we are still seeing the same error… The updates in image below for

WarehouseGrant

are expected, please disregard those. Any feedback would be much appreciated !!