Data Profiling for SQL Server, Azure SQL Database, and Amazon RDS for SQL Server
Free Tool – SQL Data Profiler
Analyze data patterns in database columns
Data profiling is an important component to ensure data quality to maintain the value of the data. As such, data profiling tools can turn raw data into business intelligence. Data profilers analyze and summarize data to produce valuable insights into data patterns. Consequently, data profiling can eliminate costly errors in databases.
- Profile data in SQL Server tables
- Analyze subsets of data types at a time
- Adjust profiling thresholds to customize the analysis
- Display summary of data in selected table and its columns
- Receive recommendations based on data per column
- View summary of value distribution per column
- Export results to plain text file format
Profile Data in SQL Server Tables
Connect to an instance of SQL Server, select a database, and select a table to profile the data contained in the table and its columns.
Analyze Subsets of Data Types at a Time
Select the types of data to include in the profiling of the database table. Focus on these data types to reduce the time to analyze large data sets and the number of displayed results. For example, initially only profile core elements and subsequently analyze specific areas of interest.
Adjust Profiling Thresholds to Customize the Analysis
Modify the settings of the profiling operation. Set the thresholds for suggesting reference tables, possible anomalies, and different data types.
Display Summary of Data in Selected Table and Its Columns
Display a summary of the data contained in a selected table and each of its columns. For the table, display the number of columns and rows, the last modification date of the data and schema, and the size of the table. For each column, show the name, data type, statistics, and more for a total of 19 properties.
Receive Recommendations Based On Data per Column
Display recommendations based on the data contained in a selected column. These recommendations refer to modifying the data type to accommodate the data better, handling sparse columns, migrating columns to reference or lookup tables, adding foreign key constraints, and more for a total of 37 recommendations.
View Summary of Value Distribution per Column
Profile the distribution of the values in each column. For a selected column, display the list of unique values, their count, and their relative occurrence.
Export Results to Plain Text File Format
Save the chosen settings and options, and the results of the profiling to a tab-delimited plain text file. Import this file into applications such as Microsoft Excel with minimal user interaction.
* Profile SQL Server on-premises and in the cloud, and without installing anything on the profiled instances.
Check out the latest blog posts for product tips & tricks from other users.