This message was deleted.
# generals
sparse-intern-71089
09/02/2022, 9:41 PMThis message was deleted.
✅ 1
p
polite-mechanic-60124
09/02/2022, 9:51 PMHey 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 PMIt sounds like what you want is a 2nd provider
s
salmon-motherboard-78006
09/02/2022, 9:53 PMWell, I may need a few roles throughout the execution...
salmon-motherboard-78006
09/02/2022, 9:53 PMIs it possible maybe to change a parameter in the config during execution?
salmon-motherboard-78006
09/02/2022, 9:54 PMusually when setting up a Snowflake environment, you want to use various roles for the different assets
p
polite-mechanic-60124
09/02/2022, 9:55 PMYep. So the right way to do this is to create multiple providers
polite-mechanic-60124
09/02/2022, 9:55 PMpolite-mechanic-60124
09/02/2022, 9:56 PMIf you haven't done this before, most code uses a default provider
polite-mechanic-60124
09/02/2022, 9:56 PMWhat 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 PMSo 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)s
salmon-motherboard-78006
09/02/2022, 10:01 PMnice! this is exactly what I was looking for!
salmon-motherboard-78006
09/02/2022, 10:01 PMthanks!
salmon-motherboard-78006
09/02/2022, 11:15 PMI'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 Copy code
opts=ResourceOptions(id="blah", provider=sysadmin_provider)p
polite-mechanic-60124
09/03/2022, 12:36 AMI don't think you need the id field
s
salmon-motherboard-78006
09/03/2022, 12:37 AMI added the
ididsalmon-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))p
polite-mechanic-60124
09/03/2022, 12:39 AMI'll take a look in a bit. I'm on my phone which is not conducive to reading code on github
s
salmon-motherboard-78006
09/03/2022, 12:40 AMthank you sir!
I'm also trying to uncover the issue on my side!
p
polite-mechanic-60124
09/03/2022, 12:42 AMI'd suggest skimming the pulumi code for the snowflake provider.
s
salmon-motherboard-78006
09/03/2022, 1:08 AMI think it was something with my repo build... it seems to work now... thanks!
59 Views