SnowSQL for Mac

Command-line client for Snowflake usage

SnowSQL is a terminal-based client built to connect with Snowflake’s cloud data warehouse. It provides a minimal, keyboard-driven way to run SQL statements, move data, and carry out administrative operations without a graphical interface.

Capabilities and common operations

• Connection management (securely opening and switching between Snowflake accounts)
• Session controls (handling authentication, timeouts, and session variables)
• Script execution (running SQL scripts and batch jobs from the command line)
• Query execution and data manipulation (submit queries, fetch results, and load/unload data)
• Administrative tools (performing user, role, and resource management tasks)

Supported platforms and alternatives

SnowSQL is available for macOS and can be used at no cost on that platform. If you prefer a different tool, a suggested substitute is Slab — noted here as a free option for Mac users.

Typical use cases and benefits

• Streamlining workflows by integrating Snowflake commands into shell scripts and CI/CD pipelines
• Automating repetitive data maintenance and operational tasks
• Providing a compact, scriptable interface for developers and data engineers who favor terminals over GUIs

In short, SnowSQL is a practical choice for professionals who need direct, scriptable access to Snowflake from the command line.