SQL Editor
Query your governed data directly — with catalog context, auto-complete, and lineage built in.
Query with Full Governance Context
Not just another SQL editor — this one knows your data catalog, quality scores, and lineage.
AI Query Writer
Describe the result you need and Qarion drafts SQL using the selected connector dialect and the current catalog schema. The assistant can also explain inherited SQL and refine a query from plain-language instructions.
- Natural language to SQL generation
- Plain-language SQL explanations
- Follow-up refinement instructions
- Read-only validation before review
Multi-Source Query Workspace
Write SQL against any connected warehouse — Snowflake, BigQuery, PostgreSQL, Databricks, or MySQL. Switch between sources with a single click. Results render inline with pagination, sorting, and CSV export.
- Tab-based multi-query workspace
- Configurable row limits and query timeouts
- Results pagination with sorting and filtering
- Export to CSV or copy to clipboard
Schema-Aware Auto-Complete
The editor understands your schema. As you type, it suggests database names, table names, column names, and even data types — pulled live from your catalog metadata. No more guessing column names.
- Database, schema, table, and column suggestions
- Data type hints in the completion menu
- Table alias support for JOIN queries
- Catalog descriptions shown as hover tooltips
Query History & Saved Queries
Every query you run is saved to your personal history — searchable by content, status, or date. Pin frequently used queries, organize them in folders, and share them with your team.
- Full-text search across query history
- Filter by status (success, failed, running)
- Re-run previous queries with one click
- Shared query library with team access
Lineage & Governance Integration
Every table you reference in a query links back to its catalog entry — complete with quality scores, ownership, lineage, and compliance metadata. You're always one click away from full context about the data you're querying.
- Click-through from tables to catalog pages
- Quality score indicators in query results
- Governance metadata visible during development
- Lineage graph accessible from query context
Pivot Table Builder
Construct pivot queries visually — drag columns into Rows, Columns, Values, and Filters zones. The builder generates the equivalent SQL in real time, letting you explore aggregated data without writing a single line of code. Switch seamlessly between the visual builder and the raw SQL editor.
- Drag-and-drop column zones
- Real-time SQL preview
- Multiple aggregation functions
- Seamless switch to raw SQL
Try the SQL Editor
Connect your first data source and start querying with full governance context.