snowflake-snowsql
« Back to VersTracker
Description:
Command-line client for connecting to Snowflake
Type: Cask  |  Latest Version: 1.4.5@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
Version History
Detected Version Rev Change Commit
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