Tables

Overview

A table is the primary tool on Redivis to view and investigate data. A table can be thought of as a grid made up of variables (columns) and rows (records). You'll see tables:

  • On the Tables tab of datasets

  • On table nodes in a project

Every table has two tabs where you can view the data and interact with it in different ways:

Table characteristics

Field

Notes

Name

The table's name. If in a dataset, must be unique across all tables for that version of the dataset. If in a project, must be unique across all tables currently in the project.

Description

Optional. A free-form description of the table's contents. May not exceed 5000 characters.

Variable count

Total number of variables in the table.

Row count

Total number of rows, or records, in the table.

Size

The size (in bytes) of the table.

Entity

Optional. Documents the concept that one record in this table represents. For example, the table's entity might represent a unique patient, or a specific hospitalization, or a prescription.

Temporal range

Optional. The range of time that this table covers. This can either be set manually, or calculated from the min/max of a particular variable.

If calculated from a variable, that variable must have type date, dateTime, or integer. If the variable is an integer, its values will be assumed to represent a year and must be in the range [0, 9999].

Sample

If this table is sampled, you will see a marker for whether you are looking at the full dataset or the 1% sample. You can click here to switch between them.

Viewing variables

The Variables tab provides a searchable list of the table's variables. In order to view this panel, you will need metadata access to the corresponding table.

Clicking any variable will display that variable's statistics panel. This shows some common summary statistics calculated from the variable's data.

Viewing cells

The cell view allows you to quickly preview and explore the table's data as a grid, regardless of the table's size. To open, click on the Cells tab for the table. In order to view this panel, you will need data access to the corresponding table.

In the cells view, you can similarly click on variables (the grid headers) to view their summary statistics and compare across variables.

Easily explore the cells of your table — even if it has billions of records.

Comparing variables

You can compare two variables by holding Cmd / Ctrl (Mac / Windows) before clicking on the variable for comparison. This is helpful for comparing univariate statistics and distributions across variables.

Comparing tables

In order to compare two tables, click the compare icon to the right of the variables search. This will allow you to compare the table to other versions of your dataset, or if in a project, to other tables in that project.

Variables highlighted in green exist in the original table but not the compared table. Those in red exist in the compared table but not the original table. Clicking on any variable (that exists in both tables) will bring up summary statistics for that variable, with statistics and distributions compared across tables.

Compare tables across versions and within you project by clicking the compare icon

Querying tables

Project transforms provide the most robust and reproducible mechanism for querying tables on Redivis. However, you can execute SQL queries directly on a table for when you want to perform a quick, one-off analysis. In order to perform a query, you will need data access to the corresponding table.

To query the table, click the query icon to the right of the variable search bar. This will open a SQL editor with scaffolding to reference the current table. The query syntax follows the same rules as the transform SQL query syntax.

If your query is valid, you will be able to click the run button at the top-right of the query editor, applying this query to both the variables and cells view of the table. You can return the table to its original state at any time by closing the query editor.

Run SQL queries directly on the table to perform quick analyses or comparisons