Data Profiling

Data Profiling helps you explore and understand the data stored in your sources. It examines your tables and columns to gather statistics and metrics, then combines them with an intuitive interface that lets you delve into the most common or random values without writing a single query.

Why profile your data?

Profiling gives you insight into the structure, quality, and content of your data before you rely on it. You can use it for:

Assessing data quality and determining its reusability.

Gaining a deeper understanding of your data structure.

Identifying potential data issues and areas that need improvement.

Reviewing data before developing software that relies on it.

Controlling how much of your sensitive data is exposed to users.

What you can see

Profiling results are presented as a series of badges, graphs, and widgets that summarize different statistics of your data at a glance — from value distribution and completeness to common formatting patterns and top values.

Profiling Badges surface the most important characteristics of your data, such as its status, details, and characteristics, so you can grasp the state of a column without opening it.

You stay in control of what gets profiled and shared. Profiling runs in one of three modes — Full, Statistical, or None — so you can expose exemplary data points where they are useful and hide them where confidentiality matters.

Supported sources

The following data sources are supported for data profiling:

Amazon AthenaAmazon Aurora MySQLAmazon Aurora PostgreSQLAmazon RedshiftAzure SQL DatabaseAzure SQL EdgeAzure Synapse AnalyticsDatabricksGoogle BigQueryIBM Db2IBM Db2 LUWMariaDBMicrosoft Fabric - Data LakehouseMicrosoft Fabric - Data WarehouseMySQLOracleOracle e-Business SuitePercona Server for MySQLPostgreSQLSAP HanaSAP Sybase ASESnowflakeSQL ServerVertica