SQL Editing / Querying Tools

Snowflake provides the following native SQL editing and querying interfaces:

Solution

Description

Snowflake clients and interfaces

Worksheets Worksheet tab

  • Browser-based SQL editor integrated directly into the Snowflake web interface.

  • No installation or configuration required.

  • Supports multiple, independent working environments that can be opened/closed, named, and reused across multiple sessions (all work is automatically saved).

Snowflake clients and interfaces

SnowSQL

  • Python-based client for performing all tasks in Snowflake, including querying, executing DDL/DML commands, and bulk loading/unloading of data.

  • Download from the Snowflake web interface and install using provided installer.

In addition, Snowflake works with a variety of 3rd-party SQL editors and data querying/modeling tools, including, but not limited to:

Solution

Version / Installation Requirements

Aginity Pro / Aginity Team

  • Aginity: Pro or Team

  • Snowflake: No requirements

DBeaver SQL client

  • DBeaver: 4.3.4 (or higher)

  • Snowflake: JDBC Driver — automatically downloaded and installed by DBeaver

SeekWell

  • SeekWell: No requirements

  • Snowflake: No requirements

SqlDBM

  • SqlDBM: No requirements

  • Snowflake: No requirements

SQL Workbench/J client

Note

This is not a complete list of SQL editors that work with Snowflake; these are known editors that have been validated for use with Snowflake. Other editors can be used with Snowflake; however, we do not guarantee that all features/functionality in these 3rd-party editors will inter-operate with Snowflake.