Usage Note 66195: The SAS® Cloud Analytic Services (CAS) session terminates when you connect to Snowflake
 |  |  |  |  |
When you connect to a Snowflake database with the Snowflake data connector, the caslib initially connects but then reports that the CAS session has been disconnected. This applies in SAS® Viya® 3.4 and SAS Viya 3.5.
This issue occurs when you use a Snowflake ODBC driver version 2.20.5 or later. The Snowflake ODBC driver version 2.20.4 or earlier is unaffected.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Connector to Snowflake | Microsoft® Windows® for x64 | V.03.04 | 2020.1 | Viya | Viya |
| Linux for x64 | V.03.04 | 2020.1 | Viya | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.4. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.4 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.4&softwareContextId=softwareUpdatesViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS Threaded Kernel Extension for Snowflake 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H9R.html#66195A fix for this issue for SAS/ACCESS Interface to Snowflake 9.41 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/H6S.html#66195| Type: | Usage Note |
| Priority: |
| Date Modified: | 2020-06-25 15:35:50 |
| Date Created: | 2020-06-24 11:04:30 |