- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-18-2022 10:47 AM
(1384 views)
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I forgot to say this is for a Viya 3.5 environment on Linux
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.