Snowflake

Snowflake data cloud CLI for warehouses, databases, stages, and data pipeline management.

32 commands

Browse by Topic

Getting Started

Quick setup and installation

3commands

Connections

Connection management

5commands

SQL

SQL execution

6commands

Streamlit

Streamlit in Snowflake

6commands

Cortex

AI/ML functions

6commands

Git

Git integration

6commands

Install SnowSQL (macOS)

$ brew install --cask snowflake-snowsql

Install SnowSQL CLI using Homebrew on macOS

Check SnowSQL version

$ snowsql --version

Display the installed SnowSQL version

Connect to Snowflake

$ snowsql -a <account> -u <user>

Connect to a Snowflake account using SnowSQL with account name and username

Add connection

$ snow connection add

Interactively add a new Snowflake connection.

List connections

$ snow connection list

List all configured connections.

Test connection

$ snow connection test --connection <name>

Test a specific connection configuration.

Set default connection

$ snow connection set-default <name>

Set the default connection for commands.

Remove connection

$ snow connection remove <name>

Remove a connection from configuration.

Execute SQL query

$ snow sql -q "SELECT * FROM table LIMIT 10"

Execute a single SQL query.

Execute SQL file

$ snow sql -f script.sql

Execute SQL commands from a file.

SQL with JSON output

$ snow sql -q "SELECT ..." --format json

Execute query and output results as JSON.

SQL with specific warehouse

$ snow sql -q "SELECT ..." --warehouse COMPUTE_WH

Execute query using a specific warehouse.

SQL with database context

$ snow sql -q "SELECT ..." --database MY_DB --schema MY_SCHEMA

Execute query with specific database context.

SQL interactive mode

$ snow sql

Enter interactive SQL mode.

Initialize Streamlit app

$ snow streamlit init

Initialize a new Streamlit in Snowflake project.

Deploy Streamlit app

$ snow streamlit deploy --replace

Deploy Streamlit app to Snowflake.

List Streamlit apps

$ snow streamlit list

List all Streamlit apps in the account.

Get app URL

$ snow streamlit get-url <app-name>

Get the URL for a deployed Streamlit app.

Describe Streamlit app

$ snow streamlit describe <app-name>

Get details about a Streamlit app.

Drop Streamlit app

$ snow streamlit drop <app-name>

Remove a Streamlit app from Snowflake.

Text completion (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.COMPLETE('llama3.1-70b', 'Explain data warehousing')"

Generate text using Cortex LLM.

Summarize text (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.SUMMARIZE(content_column) FROM docs"

Summarize text content using Cortex.

Sentiment analysis (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.SENTIMENT(review_text) FROM reviews"

Analyze sentiment of text data.

Generate embeddings (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.EMBED_TEXT('e5-base-v2', text_column) FROM docs"

Generate text embeddings for semantic search.

Translate text (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.TRANSLATE(text_col, 'en', 'es') FROM docs"

Translate text between languages.

Extract answer (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER(context, 'What is...?')"

Extract answers from context using Cortex.

Setup Git repository

$ snow git setup

Configure Git repository integration.

Create Git repository

$ snow git create-repository <name> --url <repo-url>

Create a Git repository integration.

List Git repositories

$ snow git list-repositories

List configured Git repositories.

Fetch repository

$ snow git fetch <repository-name>

Fetch latest changes from Git repository.

List branches

$ snow git list-branches <repository-name>

List branches in a Git repository.

List files in repo

$ snow git list-files <repository-name> --ref main

List files in a Git repository at a specific ref.

Discussion

Loading comments...

Snowflake

Snowflake data cloud CLI for warehouses, databases, stages, and data pipeline management.

32 commands

Browse by Topic

Getting Started

Quick setup and installation

3commands

Connections

Connection management

5commands

SQL

SQL execution

6commands

Streamlit

Streamlit in Snowflake

6commands

Cortex

AI/ML functions

6commands

Git

Git integration

6commands

Install SnowSQL (macOS)

$ brew install --cask snowflake-snowsql

Install SnowSQL CLI using Homebrew on macOS

Check SnowSQL version

$ snowsql --version

Display the installed SnowSQL version

Connect to Snowflake

$ snowsql -a <account> -u <user>

Connect to a Snowflake account using SnowSQL with account name and username

Add connection

$ snow connection add

Interactively add a new Snowflake connection.

List connections

$ snow connection list

List all configured connections.

Test connection

$ snow connection test --connection <name>

Test a specific connection configuration.

Set default connection

$ snow connection set-default <name>

Set the default connection for commands.

Remove connection

$ snow connection remove <name>

Remove a connection from configuration.

Execute SQL query

$ snow sql -q "SELECT * FROM table LIMIT 10"

Execute a single SQL query.

Execute SQL file

$ snow sql -f script.sql

Execute SQL commands from a file.

SQL with JSON output

$ snow sql -q "SELECT ..." --format json

Execute query and output results as JSON.

SQL with specific warehouse

$ snow sql -q "SELECT ..." --warehouse COMPUTE_WH

Execute query using a specific warehouse.

SQL with database context

$ snow sql -q "SELECT ..." --database MY_DB --schema MY_SCHEMA

Execute query with specific database context.

SQL interactive mode

$ snow sql

Enter interactive SQL mode.

Initialize Streamlit app

$ snow streamlit init

Initialize a new Streamlit in Snowflake project.

Deploy Streamlit app

$ snow streamlit deploy --replace

Deploy Streamlit app to Snowflake.

List Streamlit apps

$ snow streamlit list

List all Streamlit apps in the account.

Get app URL

$ snow streamlit get-url <app-name>

Get the URL for a deployed Streamlit app.

Describe Streamlit app

$ snow streamlit describe <app-name>

Get details about a Streamlit app.

Drop Streamlit app

$ snow streamlit drop <app-name>

Remove a Streamlit app from Snowflake.

Text completion (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.COMPLETE('llama3.1-70b', 'Explain data warehousing')"

Generate text using Cortex LLM.

Summarize text (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.SUMMARIZE(content_column) FROM docs"

Summarize text content using Cortex.

Sentiment analysis (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.SENTIMENT(review_text) FROM reviews"

Analyze sentiment of text data.

Generate embeddings (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.EMBED_TEXT('e5-base-v2', text_column) FROM docs"

Generate text embeddings for semantic search.

Translate text (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.TRANSLATE(text_col, 'en', 'es') FROM docs"

Translate text between languages.

Extract answer (SQL)

$ snow sql -q "SELECT SNOWFLAKE.CORTEX.EXTRACT_ANSWER(context, 'What is...?')"

Extract answers from context using Cortex.

Setup Git repository

$ snow git setup

Configure Git repository integration.

Create Git repository

$ snow git create-repository <name> --url <repo-url>

Create a Git repository integration.

List Git repositories

$ snow git list-repositories

List configured Git repositories.

Fetch repository

$ snow git fetch <repository-name>

Fetch latest changes from Git repository.

List branches

$ snow git list-branches <repository-name>

List branches in a Git repository.

List files in repo

$ snow git list-files <repository-name> --ref main

List files in a Git repository at a specific ref.

Discussion

Loading comments...