Table Level Profiling Details
These details are displayed when you select a table in the left pane.
It displays the name of the table () along with these details:
- Completeness (%): Displays the complete and incomplete rows (in percentage) in the table.
Tip:
- Under table-level profiling details, you can click the name of the column in the Column field to navigate to the respective column-level profiling details. Refer to Column Level Profiling Details.
- In the Table Summary you can sort columns.
Table Summary
It displays these details for every column in the table.
- Column: Names of all the columns in the table. You can click the column name to view column-level profiling details.
- Data Type: The data type in the column.
- Completeness (%): Completeness of records in the column.
- Uniqueness: Uniqueness of the data contained in the column.
- Null Count: Displays the number of null values in every row of the table.
- Semantic Type: Displays the detected semantic types, such as email, phone, city, first name, last name, and so on in the string in this column.
- Stats: Displays various other statistics.
- For integer: Standard Deviation, Minimum value, Average, Maximum value, Variance.
- For string: Min Length, Max Length, and Text Patterns.