Data Profiling

Back Next

Override Column Metadata

You can edit the column metadata of delimited files from the flat file, Azure Data Lake Store Gen2, and Amazon S3 v2 connections. Edit the column metadata of delimited files before you run a profile.

You can edit metadata if you want to change the data type, precision, or scale of the columns in the source object. For example, when you run a profile on a flat file connection that does not have an embedded schema, the profile results sometimes display inaccurate inferred data types. You might want to identify such columns and edit the metadata of the columns to change the data type, precision, or scale values.

You can edit the

Native Data Types

Precision

, and

Scale

properties of a column. When you edit metadata, you can change the precision and scale, if applicable for the data type.

To edit the column properties, select a column and click the property value, and then edit metadata based on your requirements. Alternatively, you might want to edit the column properties in bulk.

To edit the column properties in bulk, perform the following steps:

Click

Actions

Override Column Metadata

The

Override Column Metadata

window appears.

In the

Define Metadata

section, specify the following options:

Native Data Type. Click the menu icon and select the data type.

Precision. Enter a precision value. The precision must be greater than or equal to 1.