CODEWITHSUNDEEP
azure-data-factory
Developer Rajinikanth
Developer Rajinikanth

Reputation: 354

Azure Data Factory Copy Activity Pipeline Destination Mapping String Format Date to Sql Date column Warning

I am doing copy activity to load the data from azure data factory to on premise SQL table. I could see in copy activity column Mapping, there is warning message like source column is string with date and time value (2022-09-13 12:53:28) so that i created target SQL table column is date data type.

While import mapping in copy activity, i could see the whatever date column i mapped in SQL. there is warning message throwing in ADF. kindly advise, how do we resolve it.

screenshot:

enter image description here

Upvotes: 0

Views: 903

Answers (1)

Saideep Arikontham
Saideep Arikontham

Reputation: 6114

The warning just indicates that it copy data will truncate source column data when additional data information is found in a column value. There would not be any error in this case but there might be data loss.

enter image description here

  • In your case, since the column value is 2022-09-13 12:53:28, it will be inserted without any issue into the datetime column without truncation.

  • The following is a demonstration where I try to insert the following source data:

id,first_name,date
1,Wenona,2022-09-13 12:53:28
2,Erhard,2022-09-13 13:53:28
3,Imelda,2022-09-13 14:53:28
  • The copy activity runs successfully and inserts the data. The following is my target table data after inserting:

enter image description here

  • When I insert the following data, it would be truncated to just include a precision of 2 digits of milli seconds as shown below.
id,first_name,date
1,Wenona,2022-09-13 12:53:28.11111
2,Erhard,2022-09-13 13:53:28.11111
3,Imelda,2022-09-13 14:53:28.11111

enter image description here

Upvotes: 0

Related Questions