topic Re: How to connect snowflake from SAS enterprise guide 8.2 in SAS Enterprise Guide

How to connect snowflake from SAS enterprise guide 8.2

garrysandhu — Wed, 22 Feb 2023 11:04:17 GMT

Hi,

I want to connection to snowflake database/warehouse from SAS enterprise guide 8.2 so that I can run the query within SAS and pull the data to SAS work table. If someone can please provide some information on that. It's urgent. Thanks !

Re: How to connect snowflake from SAS enterprise guide 8.2

ChrisHemedinger — Wed, 22 Feb 2023 14:22:13 GMT

There is a SAS/ACCESS engine for Snowflake, if you have it licensed/installed in your SAS environment. If so, you can assign a libname to your database.

If you don't have that but do have SAS/ACCESS to ODBC, you could fall back to this more generic engine for basic connectivity.

If you don't have that, then SAS Enterprise Guide allows you to connect via ODBC directly from your EG session, but this pulls all data through the local PC (via EG) to send to SAS, and it's pretty inefficient for a production process.

Re: How to connect snowflake from SAS enterprise guide 8.2

garrysandhu — Thu, 23 Feb 2023 05:07:11 GMT

Thanks Chris for this quick response. The link you shared say's it's for SAS enterprise guise 9.4, can you confirm if SAS enterprise guise 8.2 also work the same way and it also support connecting to snowflake.

Re: How to connect snowflake from SAS enterprise guide 8.2

ChrisHemedinger — Thu, 23 Feb 2023 14:06:15 GMT

The SAS version is SAS 9.4, but SAS Enterprise Guide 8.2 is the application version. SAS Enterprise Guide is a client application that connects to a SAS server.