Snowflake library is visible but unable to write to it "You cannot create datasets in this mode"

persephone — Fri, 31 Jan 2025 17:13:16 GMT

We have SAS EG on Windows and our server is on Linux.

I am trying to write data using this script to QAANAL which is alias libname to a Snowflake library.
PROC SQL inobs=10;
CREATE TABLE QAANAL._JMG_TST AS
SELECT *
FROM dsn._ids
;QUIT;

The following error message results.
ERROR: You cannot create or delete datasets, views or indexes in this mode. Try the option METAOUT=DATA. Use Proc
Metalib to create metadata for datasets.

Google teels me to specify METAOUT=DATA when defining the Snowflake library using the LIBNAME statement, but library is auto assigned so I don't need to create a libname statement. Is a new libname statement needed? I tried composing one using the suggested format below but this produced errors.
libname mylib snowflake dsn='your_dsn' schema='your_schema' METAOUT=DATA;

Any suggestions on how I can successfully write from my SAS environment to Snowflake is greatly appreciated!

Re: Snowflake library is visible but unable to write to it "You cannot create datasets in this

persephone — Fri, 31 Jan 2025 17:18:03 GMT

Note - we are licensed for SAS/ACCESS Interface to ODBC

Re: Snowflake library is visible but unable to write to it "You cannot create datasets in this

persephone — Fri, 31 Jan 2025 20:16:02 GMT

This issue has been resolved. An attribute needed to be added in SAS Management Console.

topic Snowflake library is visible but unable to write to it "You cannot create datasets in this mode" in SAS Programming

Snowflake library is visible but unable to write to it "You cannot create datasets in this mode"

Re: Snowflake library is visible but unable to write to it "You cannot create datasets in this

Re: Snowflake library is visible but unable to write to it "You cannot create datasets in this