topic Re: SAS 9.4M7 Snowflake Database Server Creation in Administration and Deployment

SAS 9.4M7 Snowflake Database Server Creation

SASWayne — Tue, 09 Aug 2022 07:14:13 GMT

Hello Folks,

I'm trying to setup Snowflake database server in SAS9.4M7 environment using SAS Management console. While doing it, I cannot find "Snowflake server" under new server wizard in SMC, neither "Snowflake library" under new library wizard. We have SAS/Access to Snowflake licensed and I can confirm the same using proc setinit.

Is there a way to bring up "Snowflake Server" into the list of Database servers in new server wizard?

The version of SMC I currently use is for SAS 9.4M3, is this the reason that I'm not able to find Snowflake server?

Thanks!

Re: SAS 9.4M7 Snowflake Database Server Creation

gwootton — Tue, 09 Aug 2022 16:22:47 GMT

Correct, you'll need to use the SAS Management Console of the same version as your Metadata Server. Try running SMC on your Metadata Server host directly.

Re: SAS 9.4M7 Snowflake Database Server Creation

SASKiwi — Tue, 09 Aug 2022 20:05:37 GMT

Alternatively you could just reinstall SAS Management Console from your SAS 9.4 M7 Software Depot.