SQL Editing / Querying Tools

Snowflake provides native SQL editing and querying solutions:

Solution Additional Information
Snowflake clients and interfaces Worksheets Worksheet tab
  • SQL editor directly integrated into the Snowflake web interface with support for multiple, independent working environments.
  • No installation or configuration required.
Snowflake clients and interfaces SnowSQL
  • Python-based command line interface (CLI) 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.

Snowflake also works with various 3rd-party SQL editors, including:

Solution Connection Type Version / Installation Requirements Additional Information
DBeaver SQL client JDBC
  • DBeaver: 4.3.4 (or higher)
  • Snowflake: JDBC Driver — automatically downloaded and installed by DBeaver
  • JDBC driver is also available via snowflake-jdbc (Maven Central Repository) for manual download
SQL Workbench/J client JDBC

Note

This is not the complete list of SQL editors that work with Snowflake; these are known editors that have been tested and/or validated by 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.