Hi,
I was successful in creating the libname statement to connect to Snowflake but whenever I try to access a table it is giving an error saying ' ERROR: File MYDBLIB.cars.DATA does not exist.'. Below is the code which I used
LIBNAME mydblib snow server="snowflakecomputing.com" warehouse=WH_ALL_L
database=DB_Name schema=SCH_Name user="XXXX" password="XXXX";
proc sql outobs=50000;
create table work.test1 as
select * from mydblib.cars;
run;
' ERROR: File MYDBLIB.cars.DATA does not exist.'.