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
  • 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
  • Activating tables
  • Overview
  • Tables list
  • Column list and table preview
  • Running queries
  • Design your SQL query via the query builder or in the query editor
  • Review the results
  • Connection guide

Was this helpful?

  1. Features
  2. Database integration

View tables

PreviousCreate datasetsNextBuild queries

Last updated 2 years ago

Was this helpful?

The Tables view can be found in the sidebar once you are viewing work in a state. You can view the data tables available in the active instance and run SELECT queries on the tables. This section details the functionality accessible from this view.

Activating tables

Tables can only be activated by and only if your organization has tables enabled. If you are not a space administrator but you need to work with tables, please bring up the issue with your space and organization administrator(s).

In order for you to be able to work with tables, make sure you have tables enabled. To enable tables navigate to the Tables view and click on the Activate Tables button. The process might take a few minutes. Once it completes, you will have a fully featured interface you can interact with.

If you have running applications and you activated the tables during the session, please make sure to restart your applications in the instance so your database credentials and information can be appropriately loaded.

Overview

The functionalities as a list:

  1. Tables and columns.

  2. The query builder: build your SQL statement using a user-friendly UI.

  3. The query history.

  4. Tables list.

  5. Tables columns: can be viewed by clicking on the table name.

  6. Table preview: can be viewed by clicking on the table name.

  7. Query table using the query builder.

  8. SQL Editor - create your own SQL statements here.

  9. Connection guide - for application users.

Tables list

The tables list is the list of tables in the currently selected snapshot or current state.

It is possible to stage, delete, rename, and describe tables - hovering over a line will reveal the possible actions.

Column list and table preview

In order to see the columns list, click the table name, and select Explore columns. Similarly, select Preview table to look at the first ten rows of the table.

In order to guide documentation, it is also possible to give a description to columns in the Explore columns view.

Running queries

Design your SQL query via the query builder or in the query editor

  • Alternatively from the SQL editor (click on the toggle to reveal), you can directly type in your query and then click on PREVIEW. This can be useful if you need complex queries or combine data from different tables

Review the results

If what you see makes sense, you can proceed to run the full query from an application or to save the full results of the query (export).

Run from application

If you click on the "Run From Application" button, you will be given an option to select which application to run the query from. Selecting the appropriate application will provide you with instructions on how to run the query either on Nuvolos or on your local machine.

If you will repeatedly access the same data, we recommend exporting the results instead of running it each time from the application. For programmatic access (i.e. iterating through dates, etc..) running from an application can be easier. However, in all cases data that will be reused is recommended to be saved either to disc or to a new table.

Export results

If you run a query with Preview mode (e.g. using the SQL editor) and you want to get the full results of the query then you can use the SAVE FULL RESULTS option.

Extracting results

Compressed files are stored with the .gz extension, which is a short-hand for gzip.

On MacOS and Linux to extract a gzip files you can use the gzip tool, for example:

gzip -d example.gz

would extract the contents of example.gz to the same folder.

Windows does not have a native gzip extraction tool, however most standard tools are able to unzip gzip files such as:

Connection guide

Clicking the connection guide gives you information on access credentials to the database behind your particular workspace. You can find more about connecting via applications in this guide.

It is possible to run queries directly from the web interface. Currently, only SELECT queries are allowed. For the complete syntax of such a construct, please refer to the .

To query data using the query builder (this is recommended if you need data from a single table and you are not very familiar with SQL). Check the query builder page for more details.

See for instructions.

database system documentation
here
Exporting big data
WinRar
7zip
WinZip
space administrators
The activate tables option