You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Data Trust › Query Studio › Query Builder

Data Profiling

Analyse query result statistics including null rates, distributions, and value ranges.

Overview

Data Profiling in Query Studio analyses the result set of an executed query and provides statistical summaries including row counts, null rates, min/max values, and value distributions. Use data profiling to quickly assess data quality before using the query in reconciliation or validation scenarios.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

• You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
• A query has been created and executed at least once.

Steps

Path: Data Trust › Query Studio › Data Profiling

Figure 1: Summary Statistics

The Summary Statistics view presents statistical analysis of the query result set including row counts, null rates, min, max, and distribution summaries. Use data profiling to quickly assess data quality and identify columns that require further validation.

Figure 2: Execute Query Chain

Click Execute Now to run the query immediately and fetch the result set. The results appear in the Results tab, and the execution status is displayed in the progress indicator.

Figure 3: Data Profiling Page

The Data Profiling Page view presents statistical analysis of the query result set including row counts, null rates, min, max, and distribution summaries. Use data profiling to quickly assess data quality and identify columns that require further validation.

Figure 4: Drill down view

The Drill down view view presents statistical analysis of the query result set including row counts, null rates, min, max, and distribution summaries. Use data profiling to quickly assess data quality and identify columns that require further validation.

Figure 5: Show selected Data

The Show selected Data view presents statistical analysis of the query result set including row counts, null rates, min, max, and distribution summaries. Use data profiling to quickly assess data quality and identify columns that require further validation.