how-to-guides

No menu items for this category

Profiler Tab

The Profiler & Data Quality tab is displayed only for Tables. It has three sub-tabs for Table Profile, Column Profile, and Data Quality.

The table profile helps to monitor and understand the table structure. It displays the number of rows and columns in the table. You can view these details over a timeframe to understand how the table has been evolving. It displays the profile sample either as an absolute number or as a percentage of data. You also get details on the size of the data as well as when the table was created.

Table Profile

Table Profile

The Table Profile tab also displays timeseries graphs on Data Volume, Table Updates, and Volume Change.

The Data Volume chart gives an overview on how the data is evolving across a time period.

Table Profile: Data Volume

Table Profile: Data Volume

In Table Updates chart, users can view the changes that happened in the table in terms of data inserts, updates, and deletes.

Table Profile: Table Updates

Table Profile: Table Updates

In Volume Change chart, users can view the changes that happened in the table in terms of data volume for inserts, updates, and deletes.

Table Profile: Volume Change

Table Profile: Volume Change

The Column Profile tab provides a summary of table metrics similar to the Table Profile tab. It displays the number of rows and columns over a period of time. It displays the profile sample either as an absolute number or as a percentage of data. You also get details on the size of the data as well as when the table was created.

The column profile helps to monitor and understand the column structure with a summary of metrics for every column. You can view the type of each column, the value count, null value %, distinct value %, unique %, the tests run as well as the test status.

Column Profile of a Table

Column Profile of a Table

By clicking on any column, you can view more detailed reports about that column.

Column Profile of a Column

Column Profile of a Column

The Column Profile for a particular column also displays timeseries graphs on Data Counts, Data Proportions, Data Range, Data Aggregate, Data Quartiles, and Data Distribution. Based on the type of column you are viewing, you can verify the accuracy of the data values.

The data counts chart provides information on the Distinct Count, Null Count, Unique Count, and Values Count.

Column Profile: Data Counts

Column Profile: Data Counts

The data proportions chart displays the Distinct, Null, and Unique Proportions.

Column Profile: Data Proportions

Column Profile: Data Proportions

The length of the string that are stored in the database is profiled. The data range displays the Minimum, Maximum, and Mean values, which can be helpful for users who are doing an NLP or Text analysis.

Column Profile: Data Range

Column Profile: Data Range

Column Profile: Data Aggregate

Column Profile: Data Aggregate

This chart displays the First Quartile, Median, Inter Quartile Range, and the Third Quartile.

Column Profile: Data Quartiles

Column Profile: Data Quartiles

The distribution of the character length inside the column is displayed to help you get a sense of the structure of your data.

Column Profile: Data Distribution

Column Profile: Data Distribution