NUVOLOS
Sign In
  • Getting Started
    • Introduction to Nuvolos
    • Documentation structure
    • Nuvolos basic concepts
      • Organisational hierarchy
      • Applications
      • Distribution
      • Data integration
      • Snapshots
      • Background tasks
    • Navigate in Nuvolos
    • Quickstart tutorials
      • Research
      • Education (instructor)
      • Education (student)
  • Features
    • Applications
      • Application resources
      • Sessions
        • Session Logs
      • Install a software package
      • Create a persistent .bashrc
      • Automatic code execution
      • Long-running applications
      • Troubleshooting applications
      • New applications or licenses
      • Configuring applications
      • Exporting applications
      • Add-ons
        • MariaDB add-on
        • PostgreSQL add-on
        • OpenSearch add-on
        • MongoDB add-on
        • Redis add-on
        • PostGIS add-on
        • Rclone mount add-on
        • Neo4j add-on
    • File system and storage
      • File navigator
      • Large File Storage
      • Preview files
      • Mount Dropbox
      • Access S3 buckets with RClone
      • Access remote files with SSHFS
      • Access files on SharePoint Online
    • Object distribution
      • Distribution strategies
      • The distributed instance
    • Snapshots
      • Create a snapshot
      • Restore a snapshot
      • Delete a snapshot
    • Database integration
      • Create datasets
      • View tables
      • Build queries
      • Upload data
      • Access data from applications
        • Set up ODBC drivers
        • Obtain tokens for data access
        • Find database and schema path
      • DBeaver integration
    • Environment variables and secrets
    • Searching
      • Page
      • Find an application
      • Find an organisation
      • Find a space
      • Find an instance
      • Find a state
    • Video library
    • Nuvolos CLI and Python API
      • Installing the CLI
      • Using the CLI
  • User Guides
    • Research guides
      • Inviting a reviewer
      • GPU computation
    • Education guides
      • Setting assignments
        • Programmatical assignment handling
      • Documenting your course
      • Setting up group projects
        • Collaborative application editing
      • Configuring student applications
      • Archiving your course
      • Student guides
        • Joining a course
        • Working on assignments
        • Leaving a course
    • Application-specific guides
      • JupyterLab
      • RStudio
      • VSCode
      • Stata
      • MATLAB
      • Terminal
      • Terminal [tmux]
      • Apache Airflow
      • Apache Superset
      • D-Wave Inspector
      • MLFlow
      • Databricks Connect
      • Dynare.jl
      • CloudBeaver
      • InveLab
      • Overleaf
      • Metabase
      • DNDCv.CAN
      • OpenMetaData
      • Uploading data to the Large File Storage
    • Data guides
      • Setting up a dataset on Nuvolos
      • Importing data on Nuvolos
      • A complete database research workflow (Matlab & RStudio)
      • Accessing data as data.frames in R
      • Working with CRSP and Compustat
      • Working with the S&P 500®
  • Pricing and Billing
    • Pricing structure
    • Resource pools and budgets
    • Nuvolos Compute Units (NCUs)
  • Administration
    • Roles
      • Requesting roles
    • Organisation management
    • Space management
      • Invite to a space
      • Revoke a space user
      • HPC spaces
      • Resting spaces
    • Instance management
      • Invite to an instance
    • Enabling extra services
    • Monitoring resource usage
      • NCU Limits and Capacities
  • Reference
    • Application reference
      • InveLab
        • Dataset selection
        • Modules
          • Time-series visualisation
          • Moment estimation
          • Mean-variance frontiers
          • Frontiers
          • Dynamic strategy
          • Portfolio analysis
          • Performance analysis
          • Benchmarking
          • Carry trade strategies
          • Risk measures
          • Conditional volatility
          • Replication
          • Factor factory
          • Factor tilting
          • Valuation
    • Glossary
  • FAQs
    • FAQs
    • Troubleshooting
      • Login troubleshooting
        • I forgot my email address
        • I forgot my identity provider
        • I can't log in to Nuvolos
        • I forgot my password
        • I haven't received the password reset email
        • I haven't received the invitation email
      • Application troubleshooting
        • I can't see an application
        • I can't start an application
        • I can't create an application
        • I can't delete an application
        • I can't stop a running application
        • JupyterLab 3 troubleshooting
        • Spyder 3.7 troubleshooting
      • Administration troubleshooting
        • I can't see a space
        • I can't create a space
        • I can't delete a space
        • I can't invite admins to my space
        • I can't see an instance
        • I can't create an instance
        • I can't delete an instance
        • I can't invite users to an instance
        • I can't see distributed content in my instance
        • I can't see a snapshot
        • I can't create a snapshot
        • I can't delete a snapshot
        • I can't revoke a user role
        • I can't upload a file
        • I can't delete a file
        • I can't invite students to my course
      • Content troubleshooting
        • I can't find my files in my Linux home
        • I can't find my files among the Workspace files
        • I restored a snapshot by mistake
Powered by GitBook
On this page
  • Column selection and preview
  • Filters
  • Aggregation functions and filters
  • Sort conditions
  • Limit condition
  • Review and submit the query

Was this helpful?

  1. Features
  2. Database integration

Build queries

PreviousView tablesNextUpload data

Last updated 5 months ago

Was this helpful?

Nuvolos offers an easy-to-use query builder interface for building and running SQL queries. To open the query builder, navigate to the tables view and click the Query table button next from the list of table actions or the Query button available next to the table name.

Column selection and preview

The first step concerns the selection of the columns to include in the query. The user can select all columns via the "Select all" button or select a subset of the columns by clicking on the column name in the list of columns on the left. E.g. in the screenshot below, three columns were selected.

Selected columns will appear in a list on the right side as shown in the screenshot below. To remove a column from selection, click on the red 'clear' button next to the column name in the selected columns list. Otherwise, use the "Remove all" button to unselect all selected columns.

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

Filters

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.

In the second step, the user can add conditions that filter selected columns for rows that meet certain criteria. Filters can be added for any of the selected columns using the ADD FILTER button and they can be deleted using the red bin button:

  • Filtering a FLOAT or NUMERIC column

For NUMERIC and FLOAT columns, all types of filters are allowed (equal, not equal, greater than, less than,...). It is also possible to use the "in" filter to upload a file that contains the filtering values.

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

  • Filtering a VARCHAR (String) column

Varchar or string columns can be filtered using non-order filters such as (equal, not equal,...) but not filters such as greater than or less than.

  • Filtering DATE, TIME, and DATETIME columns

To filter date and time columns, date and time pickers are used. A date picker lets users select a date, time, or a range of dates and/or times.

To easily select past dates, you can click on the date field on the date picker to get a list of months (single click) or years (double click) as shown below.

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.

Aggregators help grouping values in selected columns, forming groups based on the values of other columns. It is possible to add one or more aggregators via the ADD AGGREGATION FUNCTION button, and the ADD AGGREGATION FILTER is used to add aggregation filters.

In the screenshot below, an aggregation function was added to group by and the count the number of each distinct value of the column FLOAT_COLUMN. Additionally, a filter was added to return rows where the count is greater than 100

Sort conditions

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

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

Limit condition

A limit condition limits the number of rows returned by the query and it is a required field.

Review and submit the query

The final step consists of reviewing the SQL query and submitting it. By clicking on 'Submit for data export', the constructed SQL query will be executed and the user will be able to download a zipped file containing the outcome of the query in CSV format. An option is available to obtain a snippet code that the user can use to run the constructed query from an application. To obtain a snippet, click on the 'Run from application' button and select the programming language you want to use to run the query. A modal will open from which the user can copy the generated code and instructions on how to run it.