- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-19-2022 05:24 PM
(2278 views)
Hello Experts,
I'm trying to understand the difference between using 'snow' and 'sasiosnf' in the place of engine in the libname statement to connect with Snowflake using SAS/ACCESS to Snowflake.
Ex-
libname snowlib snow dsn=snowprod;
libname snowlib sasiosnf dsn=snowprod;
Could someone help me with the difference please?
Thanks!
I'm trying to understand the difference between using 'snow' and 'sasiosnf' in the place of engine in the libname statement to connect with Snowflake using SAS/ACCESS to Snowflake.
Ex-
libname snowlib snow dsn=snowprod;
libname snowlib sasiosnf dsn=snowprod;
Could someone help me with the difference please?
Thanks!
4 REPLIES 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I've only found sasiosnf mentioned in documentation in relation to Viya. Have you tried it and does it work? It's possible that snow and sasiosnf are just synonyms for each other. You could always ask SAS Tech Support for clarification.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I have used sasiosnf with SAS 9.4M7 and it works, not tried 'snow' yet. I think it'll give it a shot, will post the results later.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you search the main SAS documentation site you won't find sasiosnf at all so snow appears to be the "official" engine. I've found mention of sasiosnf in SAS Support but not many hits.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Hi @SASWayne,
There isn't a difference in use. SASIOSNF is the actual engine name. SNOW is an alias. Both work.
Best wishes,
Jeff