Snowflake installs statistics

Snowflake

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

Features

• CoCo

  • Chat with Snowflake's AI coding agent without leaving VS Code
  • Generate, explain, and fix SQL and Python
  • Attach files, selections, and statements to the conversation as context

• 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

  • Navigate to and view local and deployed objects in your Snowflake Native Apps projects
  • Run, deploy, open, and teardown projects with one click
  • Modify environment variable overrides for templating and deployment

• Snowpark Checkpoints

  • View checkpoints in the current workspace
  • Add, run, clear and restore checkpoints

• SnowConvert Migration Assistant

  • Resolve SnowConvert migration issues (EWIs, FDMs, PRFs) with AI-powered assistance
  • Multiple interaction methods: Issues panel, CodeLens integration, and interactive chat
  • Configurable AI model preferences with automatic fallback
  • Comprehensive explanations and suggested fixes using Snowflake Cortex AI

CoCo

Snowflake CoCo is an AI-driven intelligent agent integrated into the Snowflake platform, optimized for complex data engineering, analytics, machine learning, and agent-building tasks. It uses an autonomous agent framework to interact directly with your Snowflake environment, with deep understanding of Snowflake's Role-Based Access Control (RBAC), schemas, and best practices.

<img src="https://app.snowflake.com/static/vscode-extension-readme/coco.png?v=11" width="340" alt="CoCo"/>

View our online documentation for CoCo here.

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

<img src="https://app.snowflake.com/static/vscode-extension-readme/sign-in.png?v=11" width="340" alt="Sign In"/> <img src="https://app.snowflake.com/static/vscode-extension-readme/execution-context.png?v=11" width="340" alt="Execution Context"/>

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

<img src="https://app.snowflake.com/static/vscode-extension-readme/object-explorer.png?v=11" width="340" alt="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…