How to connect snowflake from SAS enterprise guide 8.2

[garrysandhu]

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 !

[ChrisHemedinger]

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.

[garrysandhu]

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. 

[ChrisHemedinger]

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.