Snowflake Client
The Snowflake GUI Client for Mac.
A fast, native Snowflake GUI client for Mac. Sign in with password and MFA, key-pair, browser SSO, or an access token. Browse databases, edit cells, run scripts, switch warehouse and role from the toolbar. Free and open source.
Features
Built for Snowflake.
Four Auth Methods
Password with MFA, key-pair JWT, browser SSO, or a programmatic access token. Secrets live in the macOS Keychain.
Warehouse and Role Switcher
Change the active warehouse or role from the toolbar. No USE WAREHOUSE typing between queries.
Snowflake CLI Connections
Reads ~/.snowflake/config.toml. Pick an existing CLI connection by name instead of re-entering credentials.
Schema-Aware Autocomplete
Suggests databases, schemas, tables, columns, and Snowflake functions. Reads your schema on connect.
Inline Cell Editing
Edit any cell in the data grid. Add or delete rows. Review every pending change before commit. Full undo and redo.
AI SQL Assistant
Ask in English, get Snowflake SQL. Explain or rewrite slow queries. Works with Claude, OpenAI, and local Ollama models.
Data Grid
Browse and edit data.
Sort, filter, and edit Snowflake data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.
SQL Editor
Write queries faster.
Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.
Capabilities
What you can do.
- Browse databases, schemas, tables, and views
- Run multiple queries in tabs with separate result sets
- Switch warehouse and role from the toolbar
- Edit table structure: columns, types, defaults
- Import CSV and JSON files
- Stream-export large result sets
- Full-text search across query history
- Safe mode blocks UPDATE without WHERE
Connect
Get connected in seconds.
# Connect with TablePro
Account: myorg-myaccount
User: analyst
Auth: Key Pair
Private Key: ~/.ssh/snowflake_key.p8
Warehouse: COMPUTE_WH
# Or via Snowflake CLI
snow sql -q "SELECT CURRENT_VERSION()"Supported versions
Snowflake Standard, Enterprise, Business Critical (all regions)
Connection types
- Username & Password (MFA supported)
- Key-Pair (JWT)
- Browser SSO
- Programmatic Access Token
How to
Connect to Snowflake in four steps.
- 1
Install TablePro and the Snowflake plugin
brew install --cask tablepro. Settings > Plugins, install Snowflake from the registry.
- 2
Find your account identifier
Snowsight: Account menu > copy account identifier. Looks like myorg-myaccount or xy12345.us-east-1.
- 3
Add a Snowflake Connection
Click New Connection. Pick Snowflake. Enter the account identifier, user, and an auth method.
- 4
Connect
Click Connect. Databases appear in the sidebar. Pick a warehouse and role from the toolbar.
FAQ
Common Snowflake questions.
How do I authenticate with Snowflake?
Four ways. Username and password (MFA included), key-pair JWT, browser SSO through your identity provider, or a programmatic access token.
Can I reuse my Snowflake CLI connections?
Yes. TablePro reads ~/.snowflake/config.toml. Pick a connection by name and it fills in account, user, and auth settings.
Can I switch warehouse or role without writing SQL?
Yes. Both are toolbar dropdowns. The change applies to the current session immediately.
Does it work with MFA?
Yes. Duo push and passcode prompts work during sign-in. Credentials stay in the macOS Keychain.
Does it need a JDBC or ODBC driver?
No. TablePro talks to Snowflake over its REST connector protocol. No Java runtime, nothing extra to install.
Try TablePro for free.
Free and open-source. macOS 14+. Apple Silicon and Intel.