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 !
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.
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.
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.
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!
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.
Ready to level-up your skills? Choose your own adventure.