Hi, I was trying to create an environment variable with multiple email addresses. Eg: email1@gmail.com, email2@gmail.com, tried multiple ways such as with semicolon it give: Illegal semicolon, not in group error, if used Coma, it gives illegal address error etc. Although i am aware that i can add email addresses individually but that is not feasible as Any change in team members will result in changing values at multiple places. So does anyone know if this is possible or is currently supported by matillion.
1 Like
Hello @sandeep.kaur
Welcome to the Matillion Community, and thank you for your post. You can achieve this by using the Grid Variable as opposed to the Environment Variable. I have added our documentation for you.
I hope that helps.
Kind regards, Joe
Thank you so much. But my original idea was to not alter the pipeline after publishing it. Since environment variable sits independently in each environment. I can simply go ahead and change environment variable in production rather than altering pipeline first in dev then deploy it in test and then production. So, I was wondering if there is a way we can do it do it using environment variable.
Regards,
Sandeep Kaur.
Thanks for the update. There are a number of options you could explore.
It could be possible to split up an environment variable into a grid variable using a Python script, albeit not the most straightforward approach.
Or you could have a table in your scheme with the list of email addresses on it and use that instead.
I hope one of these options is a solution for you and we can get that going, please keep me posted.
Kind regards, Joe