User Guide

Back Next

Column Projection Properties

The following table describes the columns projection properties that you configure for complex file targets:

Property	Description
Column Name	The name of the column in the source table that contains data.
Type	The native data type of the resource.
Enable Column Projection	Indicates that you use a schema to publish the data to the target. By default, the columns are projected as binary data type. To change the format in which the data is projected, select this option and specify the schema format. When you create a complex file for an XML schema, select Binary as the resource format. After you create the object, enable column projection and manually select the schema format as XML.
Schema Format	The format in which you stream data to the target. Select one of the following formats: XML JSON Avro Parquet
Use Schema	Specify the XSD schema for the XML format, the sample JSON for the JSON format, or sample Avro file for the Avro format.
Column Mapping	Click View to see the mapping of the data object to target mapping.
Project as Hierarchical Type	Project columns as complex data type for hierarchical data. For more information on hierarchical data, see the Data Engineering Integration User Guide .