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.
In the Snowflake Driver for SQLTools VS Code marketplace page, click Install.
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
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.npm install
to install dependencies.F5
to start a debuging session. This opens a new VS Code window with the SQLTools Snowflake Driver extension loaded.
Output from the extension with your local changes shows up in the Debug Console
. You can set break points, step through
your code, and inspect variables either in the Debug
view or the Debug Console
...
Copyright (c) 2022 MIT License
This is a community built, maintained, and supported project. If you have a question or need support, please create a new issue.