Navigating the Database tab

Accessing Data Tables

To view all the database tables associated with a workspace, select the Database dropdown and select 'View database tables'.

You can filter the list of database tables by typing the name of the table into the Filter box at the top of the list. There is also an option to sort the datasets either alphabetically or by date.

Once the database table you want to work with is visible, you can view available options and the information about the table. To view options, click the menu icon on the right of the table row.

Database options.png

Previewing a Data Table

You can easily preview the contents of a data table by clicking the ‘Preview data’ button in the menu of the data table. This will open up a new dialog showing a sample of rows from the dataset.

Alternatively, you can open the data table by clicking on the table name. This opens a new table page showing the table’s fields and visualisation options. Click the 'Data Preview' button in the right sidebar to preview the data.

dataTablePreview.png

Viewing data table details

From the data table list, click on the name of a table or use the Open option in the menu.

The table detail page will be shown; this displays information about the data table and its contents. For each column, you can see the name of the column and its data type. Additionally, you may see a description of the columns if this was specified when the data was uploaded into the workspace. You can filter the list of table columns using the filter textbox.

dataTableDetail.png

Updated on December 2, 2024

Was this article helpful?