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

• Object Explorer

  • View detailed information on items within the explorer, grouped by database kind.
  • Copy the object name to your clipboard for use in query authoring

• Stage Operations

  • LIST stage contents
  • GET files from a stage
  • PUT files and folders to an internal stage

• Query Execution

  • Execute single or multi-statement queries

• Query 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

• Snowpark Python Support

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

• Native Apps

  • Added Native Apps side panel allowing you to easily view objects in your Native Apps
  • Action bar to Run, Deploy, Open and Teardown Native Applications

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 view details for that object.

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.

Object Explorer

Located in the Activity Bar, the Object Explorer provides a hierarchical view of your database and application 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.

You can also search for database objects using the search bar at the top of the Object Explorer. To turn this feature off, go to user settings and disable Object Explorer: Search.

Stage Operations

When you expand a stage within the Object Explorer, you will be able to LIST all the files contained within that stage. To GET files, use the available download buttons to download an entire stage, a directory, or a single file. If you are interacting with an internal stage, you can also use the upload button to PUT a single file, multiple files, or an entire directory into the stage.

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

When you click on a cell in the results table, the content of that cell will be displayed to the right. If you wish to select multiple cells or entire columns, you can use SHIFT or CMD/CTRL. Additionally, you can select all columns and rows by using the checkbox located in the upper-left corner of the results grid.

Located in the upper-right corner, there are three buttons:

• The info icon can be used to toggle the visibility of the query and cell details sidebar.
• The save icon can be used to save the local results and is limited to the number of rows shown in the results view.
• The download icon can be used to download the full result to disk as a CSV, provided that the results are still cached. For persisted query results of all sizes, the cache expires after 24 hours.

There are CSV Export configuration settings available under the user setting Export CSV.

Dragging a column header allows you to rearrange the column order. Right-clicking on a column header will allow you to sort, hide, or freeze that column.

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.

Snowpark Python Support

Run and debug Snowpark Python functions that take a Snowpark Session object as the sole parameter. Clicking the Snowflake: Debug option that appears over the function name will run it using your current active session from the extension. You can set breakpoints and view the console output.

Receive automatic syntax highlighting and autocompletion suggestions for SQL statements written within Python files.

To turn off automatic syntax highlighting, disable Auto Detect Sql in Python. Manual syntax highlighting can be denoted using comments.

• Start markers: --startsql, --beginsql, --start-sql, --begin-sql

• End markers: --endsql, --end-sql.

Native Apps

REQUIREMENTS: This feature requires v2.2.0+ of SnowCLI installed.

Creating a new native app

With an empty workspace, using the command palette, Snowflake: Create Native App will provide guidance for creating a new native app from a template. This is the equivalent of snow app create.

Developing a native app

When one or more snowflake.yml for a Native App is detected in the current workspace, a Native App panel will display with UI commands to run, deploy, open and teardown native apps.

• Create new from template
• Run (deploy and re-install)
• Deploy
• Open
• Teardown

It is also possible to enable and disable debug mode from the Native App panel.

• Debug Mode: On/Off

Alternatively, the user can right click this snowflake.yml and see commands in a context menu.

• Snowflake: Run (deploy and re-install) a Native App
• Snowflake: Deploy a Native App
• Snowflake: Open a Native App
• Snowflake: Teardown a Native App