Help with accessing a snowflake table in SAS - Using proc SQL

[RA_SAS]

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

[SASKiwi]

Are you sure there is a table called cars in Snowflake? You can run this to check table names:

proc datasets library = mydblib nolist;
contents data = _all_ nods ;
run;