https://pulumi.com logo
#python
Title
# python
g

gentle-account-13294

06/28/2022, 12:16 AM
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:
Copy code
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 !!
We are not sure why this is happening only in
prod
. Also it is quite surprising that even after re-creating the stack from scratch we still saw the issue.
output of preview with -d for debug
Oh boy!! Going through the debug output I figured out the issue 🤦‍♂️ . Looks like we have a resource that only exists in
dev
. Easy to fix with a PR. Thanks for the handy debug log !! 🤓
3 Views