ODBC Connection settings

[NickWhiteleit]

I initially asked this on StackOverflow (https://stackoverflow.com/questions/66814943/sqitch-snowflake-using-key-pair-authentication) and was asked to raise it here...

Using Windows 10 and the Strawberry Perl install, the ODBC server needed the full url (account.region..snowflakecomputing.com) and should only need the account.region

[theory]

Where was the URI defined? Command-line or in the configuration file? Can you paste a [redacted] copy here? Thank you!

[theory]

Ugh, didn't mean to direct you to the docker repo. Were you using a Docker image?

[NickWhiteleit]

Hi, It’s defined in the conf file: ``` [engine "snowflake"] client = "C:\\Program Files\\Snowflake SnowSQL\\snowsql.exe" target = ***@***.***/flipr?Driver=SnowflakeDSIIDriver;authenticator=SNOWFLAKE_JWT;priv_key_file=/leit/rsa_key.p8;priv_key_file_pwd=xxx;warehouse=LEIT_WH;uid=xxx ``` (anything with xxx is redacted)

[NickWhiteleit]

No – Strawberry Perl