Build Query

The Query Editor in Infoveave is a UI-driven tool designed for writing and executing SQL queries over various Datasources. It offers a user-friendly interface where you can drag and drop columns, apply filters, perform operations such as JOIN operations, aggregation functions, and set conditions without needing extensive SQL knowledge.

Steps to Write, Execute, & Analyze Queries

Access Queries and Select Datasource

Streamline the process of formulating queries over existing Datasources in Infoveave to efficiently customize, analyze, and modify data, deriving meaningful insights from complex datasets.

1. To build a query in Infoveave over any existing Datasources using query builder, click on Studio Queries.All Queries, created by you or shared with you will be displayed under the tabs My Query and Shared Query respectively.
2. To formulate a fresh formula, click on New Query.
3. Select the Query Builder option to start building the queries using the query builder.
4. Select the Datasource you want to use from the drop-down list and click Continue. You will now be redirected to the Infoveave Query Builder.

Tip

Queries with the Production tag indicate that they are linked to a workflow in production.

Note

You can now use any column from the dataset in your query without specifying it as a measure or dimension in the Datasource.

Build Query

Infoveave query builder allows you to build queries visually with the simple drag and drop of columns.

Here is a step-by-step process on how to build an SQL query using the query builder.

1. Double-click or drag and drop the columns required from the tables, or click on the + Add Column button to choose the required columns from the table.
2. To define the column aggregation type (e.g., SUM, COUNT, DISTINCT) and alias, click on the required column name added and enter the desired aggregation and alias.
3. Click on the + Add Table button to select additional tables for the JOIN operation.
4. Click on the selected table to specify the join type (INNER, OUTER, LEFT, RIGHT) and assign a table alias.
5. Add the WHERE condition to apply filters as required.
6. Click on the + Add Column button to add columns you want to GROUP BY.
7. Add the HAVING condition to apply filters over the aggregation function as required.
8. Click on the + Add Column button to add columns you want to ORDER BY.
9. To view the created query, click on the Generate Query icon.
10. To execute the query, click on the Execute icon.
11. Save your query with a meaningful name for easy identification and differentiation.