Hi all, has anybody had success creating stages in...
# general
r
Hi all, has anybody had success creating stages in Snowflake specifying a format name? If try the following the stage is created:
Copy code
stage = snowflake.Stage("example_stage",
    url=f"<gcs://my-gcs-bucket>",
    storage_integration='my-snowflake-integration',
    database='MY_DATABASE',
    schema='MY_SCHEMA',
    file_format='TYPE = CSV')
But if I change the last line to:
Copy code
file_format='FORMAT_NAME = MY_FORMAT_NAME'
It fails and doesn’t create the stage
b
what’s the failure message?
r
Sorry for the late reply. This is what I get just before it fails with `pulumi up --logtostderr --logflow -v=9`:
Copy code
I1003 09:10:51.975103    5014 log.go:81] Unmarshaling property for RPC[tf.Provider[snowflake].Create(urn:pulumi:dw-dev::snowfl[my_pulumi_project]::snowflake:index/stage:Stage::stage-[my_name]/snowflake_stage).news]: url={ [my_url] }
    I1003 09:10:51.975115    5014 schema.go:516] Created Terraform input: storage_integration = [my_integration]
    I1003 09:10:51.975123    5014 schema.go:516] Created Terraform input: url = [my_url]
    I1003 09:10:51.975128    5014 schema.go:516] Created Terraform input: database = [my_db]
    I1003 09:10:51.975131    5014 schema.go:516] Created Terraform input: file_format = FORMAT_NAME = csv_default
    I1003 09:10:51.975133    5014 schema.go:516] Created Terraform input: name = [my_name]
    I1003 09:10:51.975140    5014 schema.go:516] Created Terraform input: schema = [my_schema]
    I1003 09:10:51.975142    5014 schema.go:526] Terraform input storage_integration = "my_integration"
    I1003 09:10:51.975145    5014 schema.go:526] Terraform input url = "my_url"
    I1003 09:10:51.975147    5014 schema.go:526] Terraform input database = "my_db"
    I1003 09:10:51.975150    5014 schema.go:526] Terraform input file_format = "FORMAT_NAME = csv_default"
    I1003 09:10:51.975151    5014 schema.go:526] Terraform input name = "my_name"
    I1003 09:10:51.975154    5014 schema.go:526] Terraform input schema = "my_schema"

    error: update failed