How to use private key path with config.toml

[ATMDawidS]

Description

I am able to specify my private key path and authenticator type in the command line using --private-key-path --authenticator SNOWFLAKE_JWT but those option are missing from the toml configuration file

Context

I will simplify executing, building, testing and deploying my python code to Snowflake

[sfc-gh-turbaszek]

It's supported:

[connections.pkp]
user = "jdoe"
account = "foo"
private_key_path = "/path/to/key.pem"
authenticator = "SNOWFLAKE_JWT"

[ATMDawidS]

what version is that in?

[sfc-gh-turbaszek]

@ATMDawidS since 1.2.0 as far as I can tell. Have you tried connection similar to the one above?

[ATMDawidS]

Thanks for your help. I got it working.

[ATMDawidS]

@sfc-gh-turbaszek I noticed that when I'd run my python script locally and private_key_path are set as above (in toml configuration file ) then I get "TypeError: Expected bytes or RSAPrivateKey, got <class 'NoneType'>"

I use "with Session.builder.getOrCreate() as session" to create SF session from local execution

Password in toml works.

That does not happen when I build or deploy.

[armenavd]

Hi guys use private_key_file and it should work :)