topic Re: Libname statement for SAS/ACCESS to Snowflake in SAS Programming

Libname statement for SAS/ACCESS to Snowflake

SASWayne — Fri, 19 Aug 2022 21:24:18 GMT

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!

Re: Libname statement for SAS/ACCESS to Snowflake

SASKiwi — Sat, 20 Aug 2022 01:03:08 GMT

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.

Re: Libname statement for SAS/ACCESS to Snowflake

SASWayne — Sat, 20 Aug 2022 07:25:11 GMT

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.

Re: Libname statement for SAS/ACCESS to Snowflake

SASKiwi — Sun, 21 Aug 2022 00:29:10 GMT

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.

Re: Libname statement for SAS/ACCESS to Snowflake

JBailey — Sat, 24 Feb 2024 02:21:52 GMT

Hi @SASWayne,

There isn't a difference in use. SASIOSNF is the actual engine name. SNOW is an alias. Both work.

Best wishes,
Jeff