BookmarkSubscribeRSS Feed
garrysandhu
Calcite | Level 5

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 !

3 REPLIES 3
ChrisHemedinger
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!
garrysandhu
Calcite | Level 5

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
Community Manager

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.

SAS For Dummies 3rd Edition! Check out the new edition, covering SAS 9.4, SAS Viya, and all of the modern ways to use SAS!

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 2200 views
  • 1 like
  • 2 in conversation