Build queries

Nuvolos provides an easy-to-use query builder for creating and running SQL queries. To open it, go to the Tables view, click the table name, and then select Query table from the available table actions, or click the Query button beside the table name.

Column selection and preview

The first step is to choose which columns to include in the query. To select all available columns, click Select all. To select only specific columns, click the names of the columns in the list on the left.

As you select columns, they appear in the Selected columns list on the right. To remove an individual column, click the red clear button next to its name. To remove all selected columns at once, click Remove all.

At least one column must be selected in order to move to the next step!

Filters

In the second step, you can add conditions to filter the selected columns and return only rows that meet specific criteria. To add a filter, click Add filter and choose one of the selected columns. To remove a filter, click the red cross button next to it.

Adding filters is an optional step and the user can skip it. However, all added filters must be valid in order to proceed to the next step.

• Filtering a FLOAT or NUMERIC column

For NUMERIC and FLOAT columns, all filter types are available, including equal, not equal, greater than, and less than. You can also use the in filter to upload a file containing the values to filter by.

FLOAT and NUMERIC filters can only take numbers as filtering values.

• Filtering a VARCHAR (String) column

For VARCHAR or string columns, you can use non-order-based filters such as equal and not equal, but not order-based filters such as greater than or less than.

• Filtering DATE, TIME, and DATETIME columns

For date and time columns, filtering is done using date and time pickers. These allow you to select a specific date, time, or a range of dates and times.

To select a past date more easily, use the top bar of the date picker. Click the month and year displayed at the top of the calendar once to switch to month selection, then click it again to switch to year selection.

Aggregation functions and filters

Adding aggregation functions and filters is an optional step and the user can skip it. However, all added aggregators and filters must be valid in order to proceed to the next step.

Aggregation functions let you group values in the selected columns and calculate summary results based on those groups. You can add one or more aggregation functions by clicking Add aggregation function, and use Add aggregation filter to filter the aggregated results.

For example, you can group rows by the distinct values in FLOAT_COLUMN and count how many times each value appears. You can then add an aggregation filter to return only results where the count is greater than 100.

Sort conditions

Sorting is an optional step and the user can skip it.

You can add one or more sorting conditions for the selected columns or for columns created by aggregation functions.

Limit condition

The Limit condition specifies the maximum number of rows returned by the query and is required.

Review and submit the query

The final step is to review the SQL query and submit it. Click Submit for data export to execute the query and download the results as a zipped CSV file.

You can also generate a code snippet to run the query from an application. To do this, click Run from application and select the programming language you want to use. A modal will open with the generated code and instructions, which you can copy and use in your application.