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.soDescription=Snowflake ODBC Driverserver=xxxxxxx.xxxxxx.xxxxx.snowflakecomputing.comPort=443Database=CALL_DBWarehouse=OWR_BI_WHSchema=OWR_BASE_VIEW_SCrole=XXXXXXXXX_ROLE
I forgot to say this is for a Viya 3.5 environment on Linux
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.
The SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment.
Learn how to install the SAS Viya CLI and a few commands you may find useful in this video by SAS’ Darrell Barton.
Find more tutorials on the SAS Users YouTube channel.