where should I store connection strings when running azure function locally

Question

I'm working on a http-triggered azure function and testing locally. My azure function connects to sql database. I want to store connection strings somewhere (environment variables?) so that they do not show up in the code. And azure function can still access the connection strings like below:

server = os.getenv('SERVERNAME') 
database = os.getenv('DBNAME') 
username = os.getenv('DBUSER') 
password = os.getenv('PWD')

I created user environment variables (SERVERNAME, DBNAME, etc) on my local computer, but the azure function doesn't not seem to be able to access those.

Does anyone know how to set those environment variables so that my azure function can access the variables using os.getenv()? I'm on windows. Thanks.

you want to create an ARM template, and part of that deployment, you'd be fetching your secrets from key vault — Alex Gordon
– Alex Gordon, Commented Sep 23, 2020 at 3:26

Frank Borzage · Accepted Answer · 2020-09-23 01:45:52Z

3

You can refer to this official documentation.

If you develop azure function on the azure portal, you can store Environment variables in application settings.

If you develop azure function locally, you can store it in local.settings.json file.

Example

local.settings.json

I did a test, and found no problem.

edited Sep 23, 2020 at 1:45

answered Sep 22, 2020 at 23:05

Frank Borzage

6,8461 gold badge10 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

where should I store connection strings when running azure function locally

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related