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:
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.
Clone this repository and open it in VS Code.
Run npm install to install dependencies.
Press 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.