Connect Validation Workflow

Validation workflow with {data.validator} and RStudio Connect

Let’s prepare the simple example. We will take mtcars and modify it a little bit. As the report is scheduled to recalculate every 24 hours, the data used for report will be different each day. It mocks the behavior of database update.

random_factor <- runif(1, min = -1, max = 1)
data_for_validation <-
  mtcars %>%
  mutate(drat = drat * random_factor)

The validation will be either successful or failure - approximately half of the days in each state. We can later react differently based on the validation status.

report <- data_validation_report()

validate(data_for_validation, name = "Verifying cars dataset") %>%
  validate_if(drat > 0, description = "Column drat has only positive values") %>%
  validate_cols(in_set(c(0, 1)), vs, am, description = "vs and am values equal 0 or 1 only") %>%
  validate_cols(within_n_sds(3), mpg, description = "mpg within 3 sds") %>%
  validate_rows(num_row_NAs, within_bounds(0, 2), vs, am, mpg, description = "not too many NAs in rows") %>%
  validate_rows(maha_dist, within_n_mads(10), everything(), description = "maha dist within 10 mads") %>%

Validation summary: 
 Number of successful validations: 4
 Number of failed validations: 1
 Number of validations with warnings: 0

Advanced view: 

|table_name             |description                          |type    | total_violations|
|Verifying cars dataset |Column drat has only positive values |error   |               32|
|Verifying cars dataset |maha dist within 10 mads             |success |               NA|
|Verifying cars dataset |mpg within 3 sds                     |success |               NA|
|Verifying cars dataset |not too many NAs in rows             |success |               NA|
|Verifying cars dataset |vs and am values equal 0 or 1 only   |success |               NA|

Now let’s see the validation report - we cannot predict whether it will be failure or successes at the time that you observe it.


As we are having the validation we can base the next steps on the results.

is_validation_success <- all((get_results(report) %>% pull(type)) == "success")

In case there is everything fine with our updated dataset we will update the pin on Connect. You can learn more about the pins here. That pin can be later used by our Shiny applications, with no need for additional data manipulations and validations.

if (is_validation_success) {
  board <- board_rsconnect()
  pin_write(data_for_validation, "validated_data_example")