This post is how to work with environment variables in Synapse.
Ensure you have a spark session created. Refer to PySpark: Create a Spark Session
Get Environment Variable
It should be noted that “str” is the type that variable is. You can change it to whatever is required.
var: str = spark.conf.get('spark.executorEnv.<ENV_NAME>')
Set Environment Variable
spark.conf.set('spark.executorEnv.<ENV_NAME>', '<VALUE>')