Snowsight runs in your browser. SnowSQL is a command line. DBeaver is JVM. QueryFlow is the native Swift Mac editor for Snowflake — with Claude AI that knows your schema.
Snowflake users on Mac currently choose between four options: Snowsight (Snowflake's official web UI, slow on large queries, browser-based limitations), SnowSQL (CLI tool, no GUI), DBeaver (JVM-based, slow cold start, dated UI), and DataGrip (better than DBeaver but still JVM, $118/yr). None of these are native Mac apps. QueryFlow is the only purpose-built native Swift Snowflake client.
Snowflake's recommended authentication for desktop tools is Programmatic Access Tokens (PATs). QueryFlow uses PATs natively — generate a token in Snowsight, paste it into QueryFlow once, and the connection is set up. The token is stored encrypted in macOS Keychain. No JDBC drivers, no Java runtime, no key file management like SnowSQL requires.
Once connected to Snowflake, QueryFlow's Claude AI integration knows every database, every schema, every table, every column. Ask Claude to write a query against your FACT_ORDERS table joined to DIM_CUSTOMERS and it writes valid Snowflake SQL with your actual column names. Ask why a query is slow and Claude analyzes the query profile. Ask to convert a subquery to a CTE and it rewrites. The schema context makes Claude's output dramatically more useful than generic AI SQL tools.
QueryFlow supports unlimited query tabs. Each tab maintains its own SQL editor state with syntax highlighting (Snowflake dialect, including FLATTEN, LATERAL, PIVOT, QUALIFY). Tabs are auto-named from your FROM clause and restored on next launch. You can have a tab open for your daily revenue query, another for ad-hoc exploration, another for the customer cohort analysis you're building — all alive across sessions.
Any Snowflake query becomes a scheduled job with one click. Pick a trigger (daily 6 AM, every hour, custom cron). Pick a destination (write back to Snowflake as a new table, email the result, upload to S3, push to Google Sheets, send to Salesforce). The scheduler runs locally on your Mac. No Snowflake Tasks to configure, no Airflow cluster to maintain, no Lambda function to deploy.
Beyond ad-hoc querying, QueryFlow's Visual ETL builder treats Snowflake as a first-class source or destination. Build a Snowflake-to-Salesforce reverse ETL pipeline in 5 minutes. Sync a Postgres production database to Snowflake for analysis. Pull Salesforce data into Snowflake daily for reporting. All without leaving the same app you write SQL in.
Snowsight is well-designed but it's a web app. Each query goes through Snowflake's web layer, results render in HTML, and large result sets can be slow to display. QueryFlow connects directly through the Snowflake SQL API v2 with PAT authentication. Query results stream back to your Mac and render in a virtualized table that handles hundreds of thousands of rows without lag.
QueryFlow uses Snowflake's official SQL API v2 with Programmatic Access Tokens — the authentication and connection patterns Snowflake recommends for desktop clients. There is no formal approval process for Snowflake client tools, but QueryFlow follows all the documented best practices.
Yes. The SQL editor handles the full Snowflake dialect including QUALIFY, FLATTEN, LATERAL, PIVOT, UNPIVOT, MATCH_RECOGNIZE, time-travel queries (AT/BEFORE), zero-copy clones, and Snowpark UDF execution via SQL.
When adding a Snowflake connection, you specify the role, warehouse, database, and schema as the default context. You can override per query using USE statements or in the connection settings. Multiple connections to the same account with different roles/warehouses are supported.
QueryFlow only consumes Snowflake credits when you actively run queries. Idle warehouse time is the same as any other client — your warehouse's AUTO_SUSPEND setting controls when compute spins down. QueryFlow does not run background queries or polling that would consume unnecessary credits.
QueryFlow v1.5 uses Programmatic Access Tokens (PAT) as the primary authentication method. Key-pair authentication is on the roadmap. PAT is Snowflake's recommended modern authentication and works for all current use cases.
14-day free trial. Connect Snowflake with a PAT in 60 seconds. Compare to Snowsight, DBeaver, or DataGrip on Mac.