Hi Jeff   I have checked your post of - connecting SAS to Snowflake with ODBC and tried the same with JDBC   libname snow jdbc complete="DRIVER={SnowflakeDSIIDriver};       SERVER=d123.east-us-2.azure.snowflakecomputing.com:443;       WAREHOUSE=DATA_SCIENCE_XS;    UID=SKESANA;       PWD=abc@123;       database=GRN_DEV ;"       schema=GDW_REP ;       dbcommit=10000  autocommit=no       readbuff=200 insertbuff=200;   LOG:   68   libname snow jdbc complete="DRIVER={SnowflakeDSIIDriver}; 69       SERVER=d123.east-us-2.azure.snowflakecomputing.com:443; 70       WAREHOUSE=DATA_SCIENCE_XS;  UID=SKESANA; 71       PWD=xxx@123; 72       database=GRN_DEV ;" 73       schema=GDW_REP ; ERROR: The JDBC engine cannot be found. ERROR: Error in the LIBNAME statement. 74       dbcommit=10000 autocommit=no          --------          180 ERROR 180-322: Statement is not valid or it is used out of proper order.   75       readbuff=200 insertbuff=200;         Can you please suggest, how to avoid the errors Thanks Sailaxmi K ... View more

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. ... View more

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

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; ; ... View more