CODEWITHSUNDEEP
azure-data-factory
Alexander
Alexander

Reputation: 407

Type conversion settings missed in Azure Data Factory in Copy activity

I would like to use option allowDataTruncation from Type conversion settings in Copy activity in Azure Data Factory, but this option is missed. In my pipeline, in one copy activity source(Postgres), sink (parquet, adls) I can use it, but in another copy activity source(parquet, adls), sink (synapse) I dont see this option. Why is that?

1 enter image description here

2 enter image description here

Upvotes: 0

Views: 677

Answers (2)

Dinesh vishe
Dinesh vishe

Reputation: 3598

First -- give source proper enter image description here

See all source data is showing properly

  1. create able as source column and then map as shown in screenshot. we have shown proper screenshot for better understanding

enter image description here

enter image description here

enter image description here

enter image description here

see all column mapping with correct data

Upvotes: 0

Rakesh Govindula
Rakesh Govindula

Reputation: 11327

In copy activity, the Type conversion settings are not supported for both Copy command and Polybase copy methods.

These settings for synapse or only supported for Bulk insert or Upsert copy methods.

enter image description here

enter image description here

So, to use the type conversion settings in copy activity, you need to use Bulk insert copy method.

Go through this SO answer by @GregGalloway to undertstand about these copy methods.

Upvotes: 1

Related Questions