This message was deleted.

sparse-intern-71089

09/02/2022, 9:41 PM

This message was deleted.

✅ 1

polite-mechanic-60124

09/02/2022, 9:51 PM

Hey Roni, this is likely an either or situation. Usually with pulumi/terraform it goes through a list of options for where a config option can be set, and once it finds a config option it stops looking

polite-mechanic-60124

09/02/2022, 9:53 PM

It sounds like what you want is a 2nd provider

salmon-motherboard-78006

09/02/2022, 9:53 PM

Well, I may need a few roles throughout the execution...

salmon-motherboard-78006

09/02/2022, 9:53 PM

Is it possible maybe to change a parameter in the config during execution?

salmon-motherboard-78006

09/02/2022, 9:54 PM

usually when setting up a Snowflake environment, you want to use various roles for the different assets

polite-mechanic-60124

09/02/2022, 9:55 PM

Yep. So the right way to do this is to create multiple providers

polite-mechanic-60124

09/02/2022, 9:55 PM

https://www.pulumi.com/registry/packages/snowflake/api-docs/provider/

polite-mechanic-60124

09/02/2022, 9:56 PM

If you haven't done this before, most code uses a default provider

polite-mechanic-60124

09/02/2022, 9:56 PM

What you're going to want to do is for each role you'll want to create a different provider

polite-mechanic-60124

09/02/2022, 10:00 PM

So for example in pseudocode

Copy code

sysadmin_provider = snowflake.Provider("sysadmin",role="SYSADMIN")
securityadmin_provider = snowflake.Provider("securityadmin", role="SECURITYADMIN")

foo_resource = snowflake.foo(arg=bar, pulumi.ResourceOptions(provider=securityadmin_provider)

salmon-motherboard-78006

09/02/2022, 10:01 PM

nice! this is exactly what I was looking for!

salmon-motherboard-78006

09/02/2022, 10:01 PM

thanks!

salmon-motherboard-78006

09/02/2022, 11:15 PM

I'm getting another error that I can't seem to pass through it...

Copy code

File "/Users/roni/.conda/envs/venv/lib/python3.10/site-packages/pulumi_snowflake/schema.py", line 358, in _internal_init
        raise TypeError('__props__ is only valid when passed in combination with a valid opts.id to get an existing resource')
    TypeError: __props__ is only valid when passed in combination with a valid opts.id to get an existing resource

I provide the provider as follows to the Schema object:

Copy code

opts=ResourceOptions(id="blah", provider=sysadmin_provider)

I will try to debug later if it's not obvious

polite-mechanic-60124

09/03/2022, 12:36 AM

I don't think you need the id field

salmon-motherboard-78006

09/03/2022, 12:37 AM

I added the

id

after I got the error... so the

id

didn't help

salmon-motherboard-78006

09/03/2022, 12:37 AM

Copy code

snowflake.Schema(name.upper(),
                            comment=comment,
name=name.upper(),
data_retention_days=30,
database=db_name,
is_managed=False,
is_transient=False,
opts=ResourceOptions(provider=provider))

polite-mechanic-60124

09/03/2022, 12:39 AM

I'll take a look in a bit. I'm on my phone which is not conducive to reading code on github

salmon-motherboard-78006

09/03/2022, 12:40 AM

thank you sir! I'm also trying to uncover the issue on my side!

polite-mechanic-60124

09/03/2022, 12:42 AM

I'd suggest skimming the pulumi code for the snowflake provider.

salmon-motherboard-78006

09/03/2022, 1:08 AM

I think it was something with my repo build... it seems to work now... thanks!

58 Views

Open in Slack

Previous Next

Pulumi Community

No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.