View tables
The Tables view is available in the sidebar when you are viewing work in a state. From this view, you can browse the data tables available in the active instance and run SELECT queries against them. This section describes the functionality available in the Tables view.
Activating tables
Before you can work with tables, tables must be activated for your space. To activate them, open the Tables view and click Activate Tables. Activation may take a few minutes. Once it is complete, you will have access to the full tables interface.
Only space administrators can activate tables, and only if tables are enabled for your organization. If you are not a space administrator and need access to tables, contact your space administrator or organization administrator.
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 Tables view is organized around three main areas: navigation, table management, and table exploration.
Navigation: Across the top, you can switch between Tables, Query Builder, and Queries.
Table management: In the top-right corner, you can open the Connection Guide, Import Data, or Deactivate Tables.
Table exploration: In the Tables tab, you can browse the list of available tables, review details such as description, size, row count, and whether a table is external, and select tables for further actions.
List controls: The table list includes options to stage all tables, filter the displayed results, refresh the list, and move through pages of results.
Query tools: You can start querying a table directly with the Query action, or enable the SQL Editor to write SQL manually.
Tables list
The tables list shows all tables in the currently selected snapshot or in the current state.
To stage, delete, rename, or add a description to a table, click the More actions menu (...) at the end of the table row.
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
You can query data directly from the web interface. At this time, only SELECT queries are supported. For the full query syntax, refer to the database system documentation.
Design your SQL query using the query builder or the query editor
Use the query builder to query data without writing SQL. This is recommended if you need data from a single table and are not very familiar with SQL. See the query builder page for more details.
Alternatively, use the SQL editor. Click the toggle to open it, enter your query, and then click Preview. This is useful for more complex queries or for combining data from multiple 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.
See Exporting big data for instructions.
Export results
If you run a query in Preview mode, for example from the SQL editor, and want to retrieve the complete result set, use Save Full Results.
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
Click Connection Guide to view the access credentials for the database associated with your workspace.
Last updated
Was this helpful?