ODBC Connection settings

sqitchers / sqitch

Sensible database change management

https://sqitch.org

MIT License

2.78k stars 214 forks source link

ODBC Connection settings #570

Open NickWhiteleit opened 3 years ago

NickWhiteleit commented 3 years ago

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 commented 3 years ago

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

theory commented 3 years ago

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

NickWhiteleit commented 3 years ago

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 commented 3 years ago

No – Strawberry Perl