Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
smoqt
Frequent Visitor

Fabric Pipeline - Copy Data - DateTime2 column mapping issue

I am trying to load a Fabric Data Warehouse table from csv using the Copy Data activity in a pipeline.

 

I have a datetime2 column in my table called __timestamp that is failing.

 

The error:

'Column '__timestamp' of type 'DATETIME2' is not compatible with external data type 'Parquet physical type: BYTE_ARRAY, logical type: UTF8', please try with 'VARCHAR(8000)'

 

Here is the column definition.

smoqt_0-1714406676260.png


Here is the __timestamp column from the file.

smoqt_1-1714406735153.png

 

Here is the inferred mapping.

smoqt_0-1714407724461.png

 

File format settings (first row as header is checked):

smoqt_1-1714407969173.png

 

This works fine when loading the same file to the same table using ADF.  I'd prefer not to change the datatype of the underlying column to VARCHAR(8000) as suggested.  Can you help me understand this?

5 REPLIES 5
v-nikhilan-msft
Community Support
Community Support

Hi @smoqt 
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this. We will update you once we hear back from them.
Thanks

Hi @smoqt 
Apologies for the delay in response.
The internal team wants you to create a support ticket here to understand the issue clearly.
I will request you to please go ahead with Microsoft support on this. 
https://support.fabric.microsoft.com/en-US/support/
After creating the ticket please provide the details here. This would be helpful for internal tracking.
Thanks

Hi @smoqt 
We haven’t heard from you on the last response and was just checking back to see if you got a chance to create a support ticket. Otherwise, will respond back with the more details and we will try to help.
Thanks

Hi, @v-nikhilan-msft.  A ticket was created through our partner.  Thank you.

Hi @smoqt 

Can you please provide the ticket details?

Thanks

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Update Carousel

Fabric Monthly Update - April 2024

Check out the April 2024 Fabric update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors