Snowflake

This extension enables you to connect to Snowflake, write and execute sql queries, and view results without leaving VS Code.

Features

• Snowflake SQL Intellisense

  • Autocompletion for object names, keywords, and built-in functions
  • Signature help for built-in functions
  • Documentation for keywords and built-in functions on hover

• Accounts & Sessions

  • Connect to and quickly switch between multiple Snowflake accounts
  • View and set role, database, schema, and warehouse for the active session
  • Enable secondary roles for the active session

• Database Explorer

  • View detailed information on items within the explorer
  • Copy the object name to your clipboard for use in query authoring

• Query Execution

  • Execute single or multi-statement queries

• Query Results & History

  • View and sort query results
  • Export query results to a CSV file
  • View history of executed queries and their results
  • Copy previously executed queries

Intellisense

This extension provides autocomplete support for database object names, built-in functions, and Snowflake SQL keywords. Database, schema, and table name suggestions will show up as you type your query.

Keywords and object names display first in the list, followed by built-in functions.

Function parameters will be highlighted as you type, and a link to the function documentation is available in the info panel.

With your cursor inside an identifier, right click and select Snowflake: View Object Details to navigate to the object in the database explorer.

Accounts & Sessions

Located in the Activity Bar, the Account view lets you authenticate to Snowflake and switch between multiple accounts.

Once logged in, you'll be able to see and change your active database, schema, role, and warehouse.

Database Explorer

Located in the Activity Bar, the Database Explorer provides a hierarchical view of your database objects:

• Schemas
• Tables
• Views
• Stages
• Pipes
• Streams
• Tasks
• Functions
• Procedures

You can copy the object name to your clipboard by clicking the inline action icon on the right of the highlighted line. Clicking on an object will open up the object details view in the Panel, displaying additional information for each object.

Query Execution

You can use the inline "Execute" links to execute a given statement.

To execute multiple queries, select the ones you want to run and press CMD/CTRL+Enter. You can also use the "Execute All Statements" button in the upper right corner of the editor window to run all queries in the current file.

Query results will be displayed in the Panel.

Query Results

Clicking on a cell in the results table will display the cell text to the right. To copy a cell value, right click on a cell and select "Copy Cell Content".

To sort the results by a specific column, click on the column's header. Clicking again will reverse the sort order, and clicking a third time will disable the sort.

Query History

View previous queries executed in the Query History view, located in the Activity Bar. Clicking on a query will bring up its results in the query results view.

Hovering over an item in the Query History view will allow you to copy the query or remove it from your local history.

To clear all queries from history, click the icon in the top right of the Query History title bar.