Hi I ve decided to use Pulumi to set up my Snowflake resourc

Question

Hi I ve decided to use Pulumi to set up my Snowflake resources and `pulumi snowflake` seems to be great for this My problem currently is that I m not able to use different roles during execution For example I use SYSADMIN to create a database and I want to use SECURITYADMIN to create a new role In the config file I set up `snowflake role` to SYSADMIN and I try to change to `os environ SNOWFLAKE ROLE = SECURITYADMIN ` but it doesn t seem to be picked up

polite-mechanic-60124 · Answer

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 · Answer

It sounds like what you want is a 2nd provider

salmon-motherboard-78006 · Answer

Well I may need a few roles throughout the execution

salmon-motherboard-78006 · Answer

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

salmon-motherboard-78006 · Answer

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

polite-mechanic-60124 · Answer

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

polite-mechanic-60124 · Answer

polite-mechanic-60124 · Answer

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

polite-mechanic-60124 · Answer

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

polite-mechanic-60124 · Answer

So for example in pseudocode ```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 · Answer

nice this is exactly what I was looking for

salmon-motherboard-78006 · Answer

thanks

salmon-motherboard-78006 · Answer

I m getting another error that I can t seem to pass through it ```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 ```opts=ResourceOptions id= blah provider=sysadmin provider ``` I will try to debug later if it s not obvious

polite-mechanic-60124 · Answer

I don t think you need the id field

salmon-motherboard-78006 · Answer

I added the `id` after I got the error so the `id` didn t help

salmon-motherboard-78006 · Answer

```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 · Answer

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 · Answer

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

polite-mechanic-60124 · Answer

I d suggest skimming the pulumi code for the snowflake provider

salmon-motherboard-78006 · Answer

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