Best SQL Editor Available for Snowflake

  • Post author:
  • Post last modified:November 18, 2022
  • Post category:Snowflake
  • Reading time:7 mins read

Snowflake supports JDBC and ODBC connectors. There are many best, free and paid query editor tools available in the market. The widely used and popular query tool includes Aginity pro, SQuirrel SQL Client tool, SQL Workbench, etc. In this article, we will check SQL Editor Available for Snowflake. All the tools discussed in this articles are free and paid version. You can choose any tools based on your work nature and organization policies.

SQL Editor Available for Snowflake

Following are the list of commonly used Snowflake SQL editor tools.

  • Aginity Pro
  • Snowflake SQL (SnowSQL)
  • Snowflake Web UI
  • SQL Workbench
  • DBeaver

Now let us check these tools in brief.

Aginity Pro (Free and Paid)

Aginity Pro is a new SQL analysis tool. It is free and an easy-to-use application that enhances your performance when you are working with your Snowflake data warehouse. It uses JDBC drivers to connect to databases such as Netezza, Redshift, Greenplum, etc.

Aginity Pro - SQL Editor Available for Snowflake

The Aginity Pro is packed with many features that helps developers and administrator to manage the Snowflake server easily.

Related Article

Snowflake SQL (SnowSQL)

SnowSQL is a Python based command line client for connecting to Snowflake to execute SQL queries and perform all DDL and DML operations. The SnowSQL also allows you to load data into and unload data out of database tables.

SQL Editor Available for Snowflake - SnowSQL

You can download CLI from the Snowflake web interface.

Following is the example of SnowSQL usage:

C:\Users\viths>snowsql -a xyz224444.us-east-2 -u snuser
Password:
* SnowSQL * v1.2.1
Type SQL statements or !help
snuser#WH@(no database).(no schema)>select CURRENT_DATE;
+--------------+
| CURRENT_DATE |
|--------------|
| 2019-12-08   |
+--------------+
1 Row(s) produced. Time Elapsed: 0.336s

Related Article

Snowflake Web UI

Snowflake provide graphical user interface (GUI) to execute the queries without installing any tools. It runs on your browser. It is powerful and fully functional tool to execute queries on the Snowflake cloud data warehouse.

The only drawback of this tool is that query results are not clearly visible. You have to export and check results.

Another best part about Snowflake web UI is that it also supports SQL queries formatting. You can follow official documentation.

SQL Workbench

SQL workbench is a free tool available to connect to various databases. It works with jdbc drivers. Apart from Snowflake, you can SQL workbench to connect various other RDBMS like Netezza, Redshift, Oracle, etc.

DBeaver

DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts. Apart from Snowflake, it supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Hive, Presto, etc.

DBeaver allows you to connect to Snowflake using the JDBC driver. You can download JDBC drivers or add the path to existing JDBC drivers.

Related Articles

Hope this helps 🙂

Tags: ,