There are many free and paid SQL editor tools available for Snowflake. In my other article, we have introduced best SQL editor available for Snowflake. In this article, we will check how to access Snowflake using Aginity pro. We have explained step by step process to install Aginity pro for Snowflake.
About Aginity Pro
Aginity Pro is relatively new SQL analysis tool. Aginity pro comes in both free and paid versions. Free version is a packed with many features and makes data engineer’s life easier. Aginity Pro is an easy-to-use application that enhances your performance when you are working with your RDBMS. It uses JDBC drivers to connect to databases such as Netezza, Redshift, Greenplum, Oracle, etc.
Aginity Pro Features
Following are Aginity Pro SQL editor tool capabilities:
- Auto-complete
- Generate DML’s
- Generate DDL’s
- Snippet support
- Reverse engineering
Here are the steps to access Snowflake using Aginity pro in Windows environment.
Download Aginity Pro
Go to Aginity Pro official website and download Aginity Pro free version.
Click on “download” button and fill the form with your correct information and submit it. It will take you to the download page on successful submission and you will receive the software download link to your mail ID too.
Once you download and install, you will have to register for free license key.
Connect to Snowflake Server
Now, the tool is installed and activated. Next step is to connect to Snowflake data warehouse server.
Click on the connections (+) and select snowflake from the drop down. On the connection page, you can manually browse the JDBC driver or let Aginity Pro to download it for you. Enter all the required details.
For example, consider below sample filled form for your reference.
Test Connection
Click on test connection button. If you entered valid information, you will receive a success message.
For example,
Aginity Pro Object Explorer
Once the connection is successful, double click on a added connection name to connect to Snowflake cloud data warehouse server.
You can view the databases, tables, server details, users, etc on the object explorer.
For example,
Execute your First Query
Congratulations! You have configured Aginity Pro for Snowflake data warehouse. Now, execute simple query.
For example,
Related Articles
Hope this helps 🙂