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 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

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