Auditing data

Overview

As edits are applied to a version, they will automatically be propagated to that version's table, visible on the Table table of the version interface. It is highly recommended that you validate and audit this table before you release your version.

The version table behaves much like other tables across Redivis, with a few additional features specific to auditing data within the version. Note that the cell preview is not available on unreleased versions.

Variable changes

When viewing the table, variable level modifications will be highlighted, with added variables in green, modified variables in yellow, and deleted variables in red. Note that variable modifications only highlight changes at the variable level (that is, retyped or renamed), not whether individual values of that variable were modified.

Variables will be highlighted when added (green), modified (yellow), and removed (red).

Summary statistics

As in other tables, you can view variable summary statistics by clicking on any variable in your table. This allows you to see the general distribution of a variable and validate it against your expectations of the data.

Additionally, if you are inspecting a variable in a subsequent version that also existed in the previous version, clicking on that variable will open a comparison of the variable across the two versions. This can aid in identifying any unexpected changes due to any edits in the new version.

Compare variable summary statistics across versions

Querying data

Like other tables, the version table allows you to run custom SQL queries to create more customized statistics and metrics.

Additionally, anyone with edit access to the dataset will be able to use the unreleased version within a project, allowing them to merge the pending version with other tables and leverage various querying interfaces within the project.

Note that if any edits are made to a pre-released version, they will immediately propagate to any projects that are using that pre-released version.