Interface DatamartContext.DataProfilerResult

Enclosing interface:
DatamartContext

public static interface DatamartContext.DataProfilerResult
  • Method Details

    • getDimensions

      ResultMatrix getDimensions()
      Returns:
      ResultMatrix with a row for each dimension profiled. Columns are:

      • "Min" - Lowest value according to the natural order of the dimension field type (String, Date...).
      • "Max" - Lowest value according to the natural order of the dimension field type (String, Date...).
      • "#" - Number of values in total (matching the number of rows in the query result set).
      • "#Nulls" - Number of rows with a null value (i.e. missing value).
      • "#Distinct" - Number of distinct values.
      • "Sample" - The first 10 such values.

    • getMeasures

      ResultMatrix getMeasures()
      Returns:
      ResultMatrix with a row for each numeric projection profiled. Columns are:

      • "Min" - Lowest value.
      • "Max" - Highest value.
      • "Mean" - Population's mean or average value.
      • "Std" - Population's standard deviation.
      • "#" - Number of values in total (matching the number of rows in the query result set).
      • "#Nulls" - Number of rows with a null value (i.e. missing value).

    • getMap

      Map<String,Object> getMap()
      All the results in a map format, for fluent access in Groovy.
      Returns:
      Map containing entries <dim-name>."Sample", <measure-name>."Mean" etc.