Try our plataform
Query Builder

What is Query Builder?

Query Builder (also called Queries) is a feature that allows you to query data already loaded into your Via Kondado destination (data warehouse) without writing SQL. You build queries visually — selecting tables, fields, filters, and joins — and the platform translates everything into an internal query format called KSQL.

Note: This feature is in beta and is only available for customers with an active Via Kondado destination.

How to access

You can access Query Builder in two ways:

  • Side menu: QUERIES (next to Integrations, Connectors, Destinations, and Models)
  • CREATE+ menu → Query

The menu item is hidden for trial users without an active Via Kondado destination.

Usage modes

Query Builder offers two working modes:

1. Query Mode (manual)

Build your query step by step:

  1. Destination — choose the Via Kondado destination (Select2 by name/ID)
  2. Origin — select the source table (or another saved query that has been executed)
  3. Joins — add joins with other tables or saved queries
  4. Fields — select Dimensions, Metrics, and Calculated Fields
  5. Filters — define AND/OR conditions, operators, and values
  6. Sorting & Limit — sort and limit results (maximum 1,000 rows)
  7. UNION — combine multiple tables/queries

2. Assistant Mode (AI)

Use the built-in AI assistant to create queries from natural language — without building anything manually:

  • Select the Via Kondado destination at the top (required before you start)
  • Describe what you want to know in English (e.g., "Show me sales by channel for the last 30 days")
  • The assistant analyzes your data, builds the query, and runs it automatically — results appear in the side panel
  • Click "View query" to open the generated query in the Query tab and tweak it manually if you want
  • Attachments: you can attach files (CSV, Excel, PDF, or image) for context — up to 5 MB per file
  • Conversation history: every conversation is saved and can be renamed or deleted; use "New conversation" to start fresh
  • Feedback: rate each answer with 👍 / 👎 to help us improve the assistant
Important: Assistant Mode is experimental and requires a Via Kondado destination. Other destination types are not supported.

Available actions

After building and running your query:

  • Run query — executes the query and displays results in a table
  • Save query — saves for future use (with name and optional Custom ID)
  • Download CSV — exports results in CSV format
  • Visualize Data — opens the connection modal for Looker Studio/Power BI

Terminology

Concept Description
Field Data column available for selection (use "field", never "column")
Calculated Fields Fields created with custom expressions using the builder
Dimensions Fields used for grouping data (e.g., date, channel, product)
Metrics Numeric fields for analysis (e.g., revenue, quantity)
Joins Union of tables/queries with equality conditions
Custom ID Friendly identifier (snake_case) used in URLs for BI tools

Prerequisites

  • Have an active Via Kondado destination configured
  • Have data already loaded at least once (integrations executed)
  • For Assistant Mode: destination must be Via Kondado type (does not work with other destinations)

Limits

  • Maximum of 1,000 rows per query executed in the interface
  • Saved queries can be used in dashboards and BI without row limits
  • Calculated fields support expressions with mathematical operators and functions

BI and AI tool integration

After you run and save a query, the "Visualize Data" button opens a modal with direct connection options:

  • Power BI
  • Looker Studio
  • Claude (via MCP)
  • ChatGPT (via MCP)
  • Others — generic connection instructions

The query's Custom ID is used to identify it in BI tools. The "Visualize Data" button is only enabled after the query has been run and saved.

Next steps

How to create a query in Query Builder

Build, run, and save a query over your Via Kondado data without writing SQL.

1
Open Queries

In the menu, click QUERIES (or CREATE+ then Query) and start a new query.

2
Choose the destination

Select the Via Kondado destination and the source table you want to query.

3
Build the query

Add fields (dimensions and metrics), filters, joins, and sorting. Alternatively, use Assistant Mode and describe what you want in natural language.

4
Run

Click Run query and review the results in the table (up to 1,000 rows).

5
Save and connect

Click Save query, give it a name and a Custom ID; then use Visualize Data to connect to Power BI, Looker Studio, Claude, or ChatGPT.

Frequently asked questions

Do I need to know SQL to use Queries?▼
No. Query Builder builds the query visually (fields, filters, joins). Advanced users can still edit the internal query (KSQL) directly.
Which destinations can I query?▼
Only Via Kondado destinations. External destinations such as BigQuery, Postgres, Redshift, or Snowflake are not queryable by Query Builder — they remain pipeline destinations only.
What is the row limit?▼
The interface returns up to 1,000 rows per run (default of 100). Saved queries used in dashboards and BI tools are not subject to this limit.
What is Assistant Mode?▼
It is a built-in AI assistant that creates the query from a natural-language description and runs it automatically. It is an experimental feature and also requires a Via Kondado destination.
How do I connect my query to Power BI or Looker Studio?▼
Run and save the query, then click "Visualize Data" and choose the tool (Power BI, Looker Studio, Claude, ChatGPT, or Others).
Why don't I see the "Queries" menu?▼
The item is hidden for accounts without an active Via Kondado destination. Create a Via Kondado and load data at least once to unlock the menu.
I got an error when running the query. What should I do?▼
The screen shows a copyable error ID. Share that ID with support so we can quickly locate and investigate the issue.
Written by·Published 2026-06-30