topic Re: Need help setting up a SNOWFLAKE odbc.ini entry that is set up to pass keypair authentication in Administration and Deployment

Need help setting up a SNOWFLAKE odbc.ini entry that is set up to pass keypair authentication

dlawto2 — Thu, 18 Aug 2022 14:47:57 GMT

I am having issues setting up the odbc.ini entry for snowflake that includes passing the keypair authentication needed for snowflake. My entries are as follows:

[DSN_NAME]
Driver=/usr/lib64/snowflake/odbc/lib/libSnowflake.so
Description=Snowflake ODBC Driver
server=xxxxxxx.xxxxxx.xxxxx.snowflakecomputing.com
Port=443
Database=CALL_DB
Warehouse=OWR_BI_WH
Schema=OWR_BASE_VIEW_SC
role=XXXXXXXXX_ROLE

Re: Need help setting up a SNOWFLAKE odbc.ini entry that is set up to pass keypair authentication

dlawto2 — Thu, 18 Aug 2022 14:48:43 GMT

I forgot to say this is for a Viya 3.5 environment on Linux

Re: Need help setting up a SNOWFLAKE odbc.ini entry that is set up to pass keypair authentication

anuraagjv — Tue, 30 Aug 2022 01:18:40 GMT

What error message are you getting? Is it complaining about a missing setting? All the research I come across indicates a corruption to the DSN.