Is there a way to not expose credentials in the code?

Question

I've been using ipython notebook and there are 2 information (SNOW_USER and PASSWORD) that I need to pass so I can connect to the database. I don't want to expose it for security reasons.

I tried to set as ENV VAR (environmental variables) saving it on my .bash_profile and also on .profile using export SNOW_USER='abc' but it doesn't seem ipython can find it.

import os
print os.environ['SNOW_USER']

I also tried:

%env

But the variables are not showing there either.

Any thoughts on how to do it?

@PadraicCunningham Yes. I shutdown the notebook and open it afterwards. — lizzie
– lizzie, Commented Apr 6, 2016 at 20:09
Try logout. If you open the notebook from your window manager but it hasn't been restarted, you are still using the old environment. — tdelaney
– tdelaney, Commented Apr 6, 2016 at 20:15
@tdelaney, they have logged out and back in so that should not be the issue no? — Padraic Cunningham
– Padraic Cunningham, Commented Apr 6, 2016 at 20:15

Till · Accepted Answer · 2016-04-06 20:10:01Z

1

Try to create a file .env somewhere with in it :

export SNOW_USER="snow_user"
export PASSWORD="password"

and then source it :

source .env

Or just source you bash_profile file :

source ~/.bash_profile

answered Apr 6, 2016 at 20:10

Till

4,6013 gold badges19 silver badges20 bronze badges

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

9 Comments

lizzie Over a year ago

@PadraicCunningham I haven't tried creating .env. It worked out. I'm not sure why the bash_profile didn't work.

Padraic Cunningham Over a year ago

@lizzie, I thought you added to ~/.bash_profille as per your question and comment?

lizzie Over a year ago

@PadraicCunningham I did add to my bash_profile. What I didn't have was the .env file.

Till Over a year ago

@lizzie the .env or the bash_profile work the same. You just have to source it somehow. But usually it is good to have a .env at the root of your project.

lizzie Over a year ago

@Till Great to know!

|

Collectives™ on Stack Overflow

Is there a way to not expose credentials in the code?

1 Answer 1

9 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related