BookmarkSubscribeRSS Feed
dlawto2
Obsidian | Level 7

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

2 REPLIES 2
dlawto2
Obsidian | Level 7

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

anuraagjv
SAS Employee

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.

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

CLI in SAS Viya

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.

Discussion stats
  • 2 replies
  • 570 views
  • 0 likes
  • 2 in conversation