topic Re: Snowflake library : Not able to register tables in Administration and Deployment

Snowflake library : Not able to register tables

mkiran — Wed, 20 Sep 2023 15:14:10 GMT

I am setting up the Snowflake metadata library using native engine and received required details from SNF architect, using these details in LIBNAME statement library is getting assigned successfully and snowflake admin is able to see login on database level, however when trying to register tables through metadata library with same details(took care of case sensitive for parameters) I am getting below error message and no log showsup. I have enabled worksapce server logs and the log stop after library assignment and no errors shows up.

Any leads would be of much help and Thanks in advance.

Re: Snowflake library : Not able to register tables

carl_sommer — Wed, 20 Sep 2023 15:34:06 GMT

If you have the library defined to metadata, can you submit a libname statement using the meta engine and the libdebug option and share the results? 46712 - Option for debugging META Libname Engine libraries (sas.com)

Carl Sommer - SAS Technical Support

Re: Snowflake library : Not able to register tables

mkiran — Wed, 20 Sep 2023 20:28:54 GMT

We see an issue with the ROLES on Snowflake level, existing roles are not working we had to create a new ROLE and assign to SAS service user we are using. Weired thing is exact same permissions were given to the new role but still old one is not working.

However, after registering tables I am not able to open/query table data. when I open the table directly from the library I see below error(same result with Proc SQL too). But we are able to do proc contents on all tables in the library.

Re: Snowflake library : Not able to register tables

carl_sommer — Wed, 20 Sep 2023 20:34:40 GMT

Are you able to see/query data using your native Snowflake libname assignment through SAS code? It sounds like you can get to Snowflake metadata but not data. I think I'd pursue that, possibly as a SAS Tech Support case, and once that is proven working, follow up on the SAS metadata side of things. I am unexperienced with Snowflake, but in general it sounds like there needs to be a GRANT for SELECT

Carl Sommer - SAS Technical Support

Re: Snowflake library : Not able to register tables

mkiran — Thu, 21 Sep 2023 20:50:13 GMT

ODBC driver upgrade from snowflake fixed the issue.