Condit
condit/connectors/snowflake

Chat with your Snowflake data in plain English

Ask Snowflake questions in plain English — Condit writes the SQL, runs it, and explains the result. Your schema and data go straight from your machine to Snowflake and whichever LLM you choose; Condit’s own servers are never in the loop.

↓ Download Condit

Why Condit for Snowflake

  • Browse your whole account, or scope to one schema. Leave database/schema blank when connecting and Condit enumerates every database and schema your role can see; fill both in for full column detail on just one.
  • AI that sees across schemas. Ask a question that spans tables in different schemas — that structure is in the prompt automatically, not something you paste in by hand.
  • Teach it your schema once. Add plain-English notes to tables and columns in Condit’s semantic layer; the AI uses them on every question after that.
  • Nothing routes through Condit’s servers. Queries run directly between your machine and Snowflake over your own connection.

How it works

  1. Download Condit (free, no account) and add a Snowflake connection — account, username/password, warehouse, and optionally a database/schema to scope to.
  2. Condit reads your account’s databases and schemas — pin one, or leave it open to browse everything your role can access.
  3. Ask your question in plain English in the Chat tab.
  4. Condit writes the SQL using your schema — and any semantic-layer notes — as context.
  5. Review the generated SQL, run it, and see the results, or drop into the SQL editor to adjust it yourself.

Example

You → which customers in the SALES schema have an open ticket in SUPPORT from the last 30 days?
SQL → SELECT c.* FROM SALES.CUSTOMERS c JOIN SUPPORT.TICKETS t ON t.customer_id = c.id WHERE t.status = 'open' AND t.created_at >= …

A join across two different schemas, generated without you writing the cross-schema reference yourself.

FAQ

Does Condit support Snowflake?

Yes — username/password authentication. (SSO/OAuth were tried and removed; most users’ accounts aren’t set up for enterprise SSO.)

Can Condit query across schemas?

Yes — leave the database/schema fields blank when connecting and Condit enumerates every schema your role can see.

Does Condit run my SQL locally?

Queries go directly from your machine to Snowflake over your own connection — never through Condit’s servers.

Does my data reach the cloud?

Only if you pick a hosted LLM (OpenAI, Anthropic, etc.) — then your schema and relevant results go straight to that provider, never to Condit. Pick a local model via Ollama and nothing leaves your machine.

Can I use my own LLM?

Yes — OpenAI, Anthropic, Gemini, Groq, or fully local via Ollama.

Also connecting to Databricks? See the Databricks connector →

↓ Download Condit