TabularTranslator interface

Package:

@azure/arm-datafactory

A copy activity tabular translator.

Extends

CopyTranslator

Properties

collectionReference	The JSON Path of the Nested Array that is going to do cross-apply. Type: object (or Expression with resultType object).
columnMappings	Column mappings. Example: "UserId: MyUserId, Group: MyGroup, Name: MyName" Type: string (or Expression with resultType string). This property will be retired. Please use mappings property.
mapComplexValuesToString	Whether to map complex (array and object) values to simple strings in json format. Type: boolean (or Expression with resultType boolean).
mappings	Column mappings with logical types. Tabular->tabular example: [{"source":{"name":"CustomerName","type":"String"},"sink":{"name":"ClientName","type":"String"}},{"source":{"name":"CustomerAddress","type":"String"},"sink":{"name":"ClientAddress","type":"String"}}]. Hierarchical->tabular example: [{"source":{"path":"$.CustomerName","type":"String"},"sink":{"name":"ClientName","type":"String"}},{"source":{"path":"$.CustomerAddress","type":"String"},"sink":{"name":"ClientAddress","type":"String"}}]. Type: object (or Expression with resultType object).
schemaMapping	The schema mapping to map between tabular data and hierarchical data. Example: {"Column1": "$.Column1", "Column2": "$.Column2.Property1", "Column3": "$.Column2.Property2"}. Type: object (or Expression with resultType object). This property will be retired. Please use mappings property.
type	Polymorphic discriminator, which specifies the different types this object can be
typeConversion	Whether to enable the advanced type conversion feature in the Copy activity. Type: boolean (or Expression with resultType boolean).
typeConversionSettings	Type conversion settings

Property Details

collectionReference

The JSON Path of the Nested Array that is going to do cross-apply. Type: object (or Expression with resultType object).

collectionReference?: any

Property Value

any

columnMappings

Column mappings. Example: "UserId: MyUserId, Group: MyGroup, Name: MyName" Type: string (or Expression with resultType string). This property will be retired. Please use mappings property.

columnMappings?: any

Property Value

any

mapComplexValuesToString

Whether to map complex (array and object) values to simple strings in json format. Type: boolean (or Expression with resultType boolean).

mapComplexValuesToString?: any

Property Value

any

mappings

Column mappings with logical types. Tabular->tabular example: [{"source":{"name":"CustomerName","type":"String"},"sink":{"name":"ClientName","type":"String"}},{"source":{"name":"CustomerAddress","type":"String"},"sink":{"name":"ClientAddress","type":"String"}}]. Hierarchical->tabular example: [{"source":{"path":"$.CustomerName","type":"String"},"sink":{"name":"ClientName","type":"String"}},{"source":{"path":"$.CustomerAddress","type":"String"},"sink":{"name":"ClientAddress","type":"String"}}]. Type: object (or Expression with resultType object).

mappings?: any

Property Value

any

schemaMapping

The schema mapping to map between tabular data and hierarchical data. Example: {"Column1": "$.Column1", "Column2": "$.Column2.Property1", "Column3": "$.Column2.Property2"}. Type: object (or Expression with resultType object). This property will be retired. Please use mappings property.

schemaMapping?: any

Property Value

any

type

Polymorphic discriminator, which specifies the different types this object can be

type: "TabularTranslator"

Property Value

"TabularTranslator"

typeConversion

Whether to enable the advanced type conversion feature in the Copy activity. Type: boolean (or Expression with resultType boolean).

typeConversion?: any

Property Value

any

typeConversionSettings

Type conversion settings

typeConversionSettings?: TypeConversionSettings

Property Value

TypeConversionSettings