Snowflake CLI

What problem does it solve?

Manually interacting with Snowflake, running ad-hoc SQL, deploying applications, or managing objects can be repetitive and inefficient, especially in automated workflows. This skill empowers users to automate a wide range of Snowflake operations directly from the command line.

Core Features & Use Cases

• SQL Execution & Templating: Run SQL queries and scripts with powerful client-side templating using Jinja or standard syntax.
• Application Deployment: Deploy Streamlit applications and Snowpark UDFs/procedures directly from your local environment or CI/CD.
• Object & Stage Management: Create, list, describe Snowflake objects and manage files on internal stages with ease.
• Use Case: Automate a daily data pipeline by writing a shell script that uses snow sql to execute a series of SQL transformations, snow stage copy to upload new data files, and snow snowpark deploy to update a Python stored procedure, all without manual intervention.

Quick Start

Execute an inline SQL query

snow sql -q "SELECT CURRENT_VERSION()" -c default

Run a SQL script from a file

snow sql -f my_script.sql -c default

Deploy a Streamlit application

snow streamlit deploy --replace -c default