SQL Development & Management¶
Snowflake provides the following native SQL development and data querying interfaces:
Solution |
Description |
Notes |
|
---|---|---|---|
Browser-based SQL development and editing. |
|
||
Python-based client for performing all tasks in Snowflake, including querying, executing DDL/DML commands, and bulk loading/unloading of data. |
|
||
Snowflake provides an extension for Visual Studio Code to enable Snowflake users to write and execute Snowflake SQL statements directly in VSC. |
|
In addition, Snowflake works with a variety of 3rd-party SQL tools for managing the modeling, development, and deployment of SQL code in your Snowflake applications, including, but not limited to:
Solution |
Version / Installation Requirements |
Notes |
|
---|---|---|---|
Agile Data Engine: No requirements Snowflake: No requirements |
|||
Aginity: Pro or Team Snowflake: No requirements |
|||
DataOps.live: No requirements Snowflake: No requirements |
|
||
DBeaver: 4.3.4 (or higher) Snowflake: JDBC Driver — automatically downloaded and installed by DBeaver |
|||
erwin: Data Modeler 2020 (or higher) Snowflake: No requirements |
|
||
Hackolade: Studio 5.2.0 (or higher) Snowflake: No requirements |
|
||
SeekWell: No requirements Snowflake: No requirements |
|
||
Solita Agile Data Engine: No requirements Snowflake: No requirements |
|||
SqlDBM: No requirements Snowflake: No requirements |
|
||
SQL Workbench: No requirements Snowflake: JDBC Driver — download from the JDBC Driver page in the Maven Central Repository |
|
||
Statsig: No requirements Snowflake: No requirements |
|
Note
This is not a complete list of SQL management tools that work with Snowflake; these are known tools that have been validated for use with Snowflake. Other tools can be used with Snowflake; however, we do not guarantee that all features/functionality in these 3rd-party tools will interoperate with Snowflake.