Failure creating a snowflake warehouse

[mkoehrsen]

Hello!

• 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)

Issue details

I was trying out the minimum case of creating a warehouse using Pulumi. It failed with the following error:

    time="2022-01-05T13:52:27-05:00" level=error msg="error: 001003 (42000): SQL compilation error:\nsyntax error line 1 at position 38 unexpected '-'.\nparse error line 1 at position 42 near '97'." func="gosnowflake.(*snowflakeConn).queryContextInternal" file="connection.go:356"
 
    error: update failed
 
  snowflake:index:Warehouse (reporting):
    error: 1 error occurred:
    	* creating urn:pulumi:dev::snowflake-poc::snowflake:index/warehouse:Warehouse::reporting: 1 error occurred:
    	* 001003 (42000): SQL compilation error:
    syntax error line 1 at position 38 unexpected '-'.
    parse error line 1 at position 42 near '97'.

The warehouse was in fact created but then the error occurs on this SQL statement:

SHOW PARAMETERS IN WAREHOUSE reporting-8cd4816

Steps to reproduce

1. Run pulumi new python
2. Configure snowflake credentials through the environment
3. Edit __main__.py to have the following content:

"""A Python Pulumi program"""

import pulumi
import pulumi_snowflake as snowflake

snowflake.Warehouse("reporting", warehouse_size="XSMALL")

4. Run pulumi up

Expected:

Expected command to complete successfully and warehouse to be created.

Actual:

Warehouse was created but with failure as described above.

[mkoehrsen]

Found that the easy workaround is to specify the physical name.

[leezen]

@mkoehrsen Long time, no see!

Thanks for filing the issue. This is due to autonaming typically suffixing with -<hex> so it sounds like we'll need to adjust how autonames work in this provider.