Condividi tramite


TabularTranslator Class

Definition

A copy activity tabular translator.

[System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.TabularTranslator+TabularTranslatorConverter))]
public class TabularTranslator : Azure.Analytics.Synapse.Artifacts.Models.CopyTranslator
[<System.Text.Json.Serialization.JsonConverter(typeof(Azure.Analytics.Synapse.Artifacts.Models.TabularTranslator+TabularTranslatorConverter))>]
type TabularTranslator = class
    inherit CopyTranslator
Public Class TabularTranslator
Inherits CopyTranslator
Inheritance
TabularTranslator
Attributes

Constructors

TabularTranslator()

Initializes a new instance of TabularTranslator.

Properties

AdditionalProperties

Additional Properties.

(Inherited from CopyTranslator)
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.

TypeConversion

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

TypeConversionSettings

Type conversion settings.

Applies to