The SQL Editor in Colrows is your command centre for data exploration. It’s designed for data engineers, analysts, and technical users who want the power of SQL—enhanced by the intelligence of AI.

Whether you’re running ad-hoc analysis, building reusable queries, or creating visual insights, the SQL Editor makes the experience fast, fluid, and intelligent.

Key Features

1. Multi-source Data Wrangling: The editor seamlessly connects to a wide variety of data sources, enabling users to perform data wrangling tasks with ease. Whether you're working with relational databases, NoSQL systems, or other data storage solutions, the editor supports them all, allowing you to clean, transform, and analyze data from multiple origins.

2. Syntax Highlighting:To facilitate easier query writing and error reduction, the editor includes robust syntax highlighting. This feature visually distinguishes different elements of SQL syntax, such as keywords, functions, and identifiers, making code more readable and helping you spot mistakes quickly.

3. Schema Browser: The integrated schema browser provides an intuitive way to explore and interact with database schemas. Users can easily view tables, columns, relationships, and other schema components, which simplifies the process of writing and optimizing queries.

4. Quick Assist: The editor includes a quick assist feature that offers context-aware suggestions and auto-completions as you write queries. This helps speed up query development and reduces the likelihood of errors by providing relevant recommendations and correcting syntax issues on the fly.

5. Team Collaboration: Designed with collaboration in mind, the editor facilitates teamwork through several key features:

   • Bookmarks: Users can set bookmarks within their queries to quickly navigate to important sections or notes, improving productivity and organization.

   • Query History Cache: The editor maintains a cache of previously executed queries, allowing users to search and retrieve queries they have run in the past. This history also includes queries executed by team members, promoting knowledge sharing and reducing duplicate work.

   • SQL Notebooks: Users can create and share SQL Notebooks with their teammates. These notebooks can contain queries, results, and annotations, making it easy to collaborate on complex data analyses and document findings.

From Query to Chart

Data becomes meaningful when visualized—and Colrows makes that transition effortless.

Once your query returns results, you can instantly plot a chart from within the SQL Editor.

steps:

1. Run your SQL query and view the result grid.

2. Click “Visualize” to open the chart builder.

3. AI suggests a visualization type automatically based on your data pattern (bar, line, scatter, pie, etc.).

4. Adjust axes, labels, and colors as needed.

5. Once satisfied, click Save Chart—it becomes part of your Insights library.

Insights: Your Personal Library of Charts

Every saved chart becomes an Insight—a reusable, dynamic visualization accessible anytime.

Within Insights, you can:

• View all your saved charts

• Access charts shared with you by teammates

• Re-run or edit the chart’s SQL query

• Tag and organize charts by project or topic

• Add charts to dashboards for storytelling

Dashboards

Dashboards let you combine multiple charts into a single, live view.

From the Dashboard menu:

• Create a new dashboard or open an existing one.

• Add charts from your Insights library with a single click.

• Arrange and resize charts to fit your layout.

• Auto-refresh: Every dashboard runs live queries when opened, ensuring you’re always looking at fresh data.

• Remove charts anytime—dashboards are fully dynamic and easy to maintain.

Dynamic Rendering and Caching

Every chart and dashboard in Colrows is dynamic—not a static image.

• Each time you open a chart or dashboard, Colrows re-runs the underlying SQL query to fetch fresh results from your data source.

• This ensures real-time accuracy and consistency across analyses.

• To optimize cost and performance, Colrows uses intelligent caching:

  • Frequently accessed charts are cached temporarily.

  • Cache duration is configurable per workspace or per chart.

  • Cached data is automatically refreshed after expiry.

Sharing Charts and Dashboards

Collaboration is at the heart of Colrows. You can share charts and dashboards securely across your organization—or with the world.

Share within your organization

• Click the Share button on any chart or dashboard.

• Select one or more teammates from your organization.

• Shared items appear automatically under their “Shared with Me” section in Insights or Dashboards.

Share outside your organization

• Generate a public link to share charts or dashboards externally.

• Ideal for clients, partners, or public reports.

• Public links are secure, read-only, and can be revoked anytime.