To view all the database tables associated with a workspace, select the Datasets tab.
You can filter the list of datasets by typing the name of the table into the search 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 tools and the information about the table. To do this click anywhere on the row, other than the table name or icon, to highlight it, then the information about the table is displayed in the sidebar on the right.
Viewing dataset Information and Activity
Note the Information and Activity tabs on the Dataset panel.
The Information tab shows summary information about the table, such as the number of columns and rows in the table, and the estimated size of the data if it were saved as a file on disk. This information can be out of date if the table has been recently updated but it can be refreshed by clicking the ‘Refresh information’ button.
The Activity tab shows the latest user activity related to the dataset.
Opening or previewing a dataset
You can easily preview the contents of a data table by clicking the ‘Preview data’ button in the Datasets sidebar. This will open up a new dialog showing the first 500 rows of the dataset.
Alternatively, you can open the dataset 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 to preview the data.
The table page also displays information about the dataset columns. 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 search the list of table columns using the Search textbox.