SQLTools Snowflake Driver

A Visual Studio Code extension which extends the SQLTools extension, with a driver to work with the Snowflake Database. It supports tables and views, as well as running queries on Snowflake.

Installation

From the VS Code Marketplace

In the Snowflake Driver for SQLTools VS Code marketplace page, click Install.

Usage

After installing the Snowflake Driver for SQLTools, you will be able to create connections to Snowflake, explore tables and views, and run queries. For more information on how to use SQLTools please refer to SQLTools extension

What's not implemented:

• externalbrowser authenticator for SSO: The Snowflake NodeJS Connector doesn't implement the SSO authentication
• Intellisense auto completion: Fast code completion has to use the SHOW commands to get search results quickly but it requires to run multiple sql queries for each search term. SQLTools not supporting it at the moment.
• Automatic limit results: Running SELECT * FROM big_table with no limit clause will fetch every row form the table. SQLTools doesn't have abort query function. Please always add LIMIT 100 to the end of your SQL, otherwise you need to abort the query from the snowflake console.

License

Copyright (c) 2020 MIT License