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

RA_SAS — Wed, 15 Nov 2023 15:48:35 GMT

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

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

SASKiwi — Wed, 15 Nov 2023 19:41:54 GMT

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;

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

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

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