Running a Column Profile on JSON and XML Data Sources

Running a Column Profile on JSON and XML Data Sources

Overview

Overview

You can create column profiles on flat file data sources that use the CSV format or on semi-structured data sources that use the JSON or XML format.
JSON and XML formats are widely used in databases and in data interchange. JSON and XML use a hierarchical format to transmit structured data over a network connection.
A profile finds and analyzes all data irregularities across data sources in the enterprise and hidden data problems that put data projects at risk. Running a profile on any data source in the enterprise gives you a good understanding of the strengths and weaknesses of its data and metadata.
To detect data irregularities in a data source that uses JSON or XML format, perform the following tasks:
  1. Create a flat file data object or complex file data object on the data source.
  2. Create a column profile on the data object.
You can create, edit, and view the column profile for JSON or XML data sources in the Developer tool. You can view the profile in the Analyst tool in summary view and detailed view.

0 COMMENTS

We’d like to hear from you!