topic Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS in SAS Programming

HOW DO I GET DATA FROM SNOWFLAKE TO SAS

ksailaxmi — Fri, 09 Dec 2022 05:04:49 GMT

Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS

LinusH — Fri, 09 Dec 2022 08:14:44 GMT

The most straightforward way is to use SAS/ACCESS to Snowflake, then you "download" data to your SAS session host.

There are several way how to design this, depending on your requirements and constraints, like:

- What is your use case?

- How much data do you need to work with?

- What version of SAS do you have?

- Where is you SAS session executing (relative to your Snowflake instance)

One takeaway is that many Snowflake user tries to keep the data in the DB and have as much of you queries execute there, and then only upload portion of data that is needed for SAS VA/VS (data set needs to be loaded to LASR/CAS).

Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS

ksailaxmi — Mon, 12 Dec 2022 10:28:02 GMT

Hi Linush,

I am working on a retrospective data -Want to take specific data directly from snowflake-
SAS Version 9.4 - Snowflake Enterprise - with Azure Cloud.

Tried this -

proc sql;
connect using SNOW1;

libname mylib snow server='<account>.snowflakecomputing.com' user=myusr|password=mypwd|warehouse=compute_wh
database=mydb schema=mydb role=user;
;

Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS

LinusH — Mon, 12 Dec 2022 12:11:23 GMT

Assuming that your driver etc is already configured, it looks like your statemnts is in the wrong order, using should refer to the exact name in the libname statement
libname mylib snow server='<account>.snowflakecomputing.com' user=myusr|password=mypwd|warehouse=compute_wh
database=mydb schema=mydb role=user;
proc sql;
connect using SNOW as snow1;
select * from connection to snow1 (query goes here);
disconnect from snow1;
quit;

Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS

ksailaxmi — Mon, 12 Dec 2022 12:21:24 GMT

Thanks, Linush - You guessed it right - My driver is not yet configured - I am trying with trial version

Re: HOW DO I GET DATA FROM SNOWFLAKE TO SAS

ksailaxmi — Fri, 16 Dec 2022 11:14:19 GMT

Hi Linush

Please check this, and suggest the needful

libname mylib snow server='ABC.east-us-2.azure.snowflakecomputing.com:443' user=SKESANA|password=XXXXXX@123|warehouse=DATA_SCIENCE_XS
database=GRN_DEV schema=GDW_REP role=FR_DATA_SCIENCE_VIEW;

ERROR

libname mylib snow server='ABC.east-us-2.azure.snowflakecomputing.com:443'
38 ! user=SKESANA|password=XXXXXX@123|warehouse=DATA_SCIENCE_XS
39 database=GRN_DEV schema=GDW_REP role=FR_DATA_SCIENCE_VIEW;
ERROR: The SNOW engine cannot be found.
ERROR: Error in the LIBNAME statement.