HOW DO I GET DATA FROM SNOWFLAKE TO SAS

[LinusH]

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).

[ksailaxmi]

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;
;

[LinusH · Accepted solution]

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;

[ksailaxmi]

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.

[ksailaxmi]

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