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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
smoqt
Advocate I
Advocate I

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

JanFabricDE_carousel

Fabric Monthly Update - January 2025

Explore the power of Python Notebooks in Fabric!

JanFabricDW_carousel

Fabric Monthly Update - January 2025

Unlock the latest Fabric Data Warehouse upgrades!

JanFabricDF_carousel

Fabric Monthly Update - January 2025

Take your data replication to the next level with Fabric's latest updates!