Share via

TabularTranslator interface

  • Reference
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