Description:
Command-line client for connecting to Snowflake
|
|
Type: Cask
|
Latest Version: 1.5.0@0
|
Tracked Since: Dec 28, 2025
|
|
Links:
Homepage |
@SnowflakeDB |
formulae.brew.sh
|
|
Category: Databases
|
|
Tags:
snowflake
sql
database
cli
data-warehouse
analytics
|
|
Install:
brew install --cask snowflake-snowsql
|
About:
SnowSQL is the official command-line client for Snowflake, enabling users to execute SQL queries and manage data warehouses from the terminal. It supports advanced features like multi-statement queries, query pagination, and variable substitution for complex automation workflows. The tool integrates seamlessly with Snowflake's secure authentication and account management capabilities.
|
Key Features:
- Secure authentication using Okta, Azure AD, and other SSO providers
- Support for multi-statement queries and variable substitution
- Query pagination and result formatting options
- Local configuration file management for multiple connections
- Copy command support for bulk data loading and unloading
|
Use Cases:
- Automating data pipeline tasks and ETL processes via shell scripts
- Running ad-hoc analytical queries directly from the terminal
- Database administration and user management tasks
- CI/CD integration for database migrations and schema updates
|
Alternatives:
-
psql
– PostgreSQL client, not compatible with Snowflake's architecture
-
dbeaver
– GUI-based universal database tool, not optimized for CLI automation
-
odbc-jdbc-drivers
– Lower-level drivers requiring additional configuration, less user-friendly
|
| Detected |
Version |
Rev |
Change |
Commit |
| Apr 17, 2026 4:48pm |
1.5.0 |
0 |
VERSION_BUMP |
90f2fe02 |
| Aug 26, 2025 4:52pm |
1.4.5 |
0 |
VERSION_BUMP |
b543e90b |
| Aug 1, 2025 10:22pm |
1.4.4 |
0 |
VERSION_BUMP |
affc47ca |
| Aug 12, 2024 10:34pm |
1.3.2 |
0 |
VERSION_BUMP |
dd595a2d |
| Jun 28, 2024 1:35pm |
1.3.1 |
0 |
VERSION_BUMP |
a239f415 |
| Jan 24, 2024 8:32pm |
1.2.31 |
0 |
VERSION_BUMP |
3c3dde4c |
| Nov 13, 2023 8:55pm |
1.2.30 |
0 |
VERSION_BUMP |
fdb394eb |
| Oct 10, 2023 5:47pm |
1.2.29 |
0 |
VERSION_BUMP |
23678dba |
| Jun 16, 2023 8:05am |
1.2.27 |
0 |
VERSION_BUMP |
b2f01c43 |
| Apr 18, 2023 7:15am |
1.2.24 |
0 |
VERSION_BUMP |
ce91448f |
|