Forum Discussion
Error writing data to Lakehouse Table Eventstream
Hi,
I have a basic eventstream with an input from EventHub, manage Fields to rename columns, then write to an existing Lakehouse table.
The schema of the lakehouse table contains timestamp fields, and the data preview in Manage Fields shows the fields as datetime.
Lakehouse schema:
Manage Fields Output:
I am getting the following error when writing to lakehouse.
"First Occurred: 2/12/2025 11:14:40 AM UTC | Resource Name: dst-BronzeLH | Message: Source 'dst-BronzeLH' had 1 occurrences of kind 'OutputDataConversionError.TypeConversionError' between processing times '2025-02-12T11:11:32.0625873Z' and '2025-02-12T11:14:40.6506983Z'
All help appreciated.
Hi bw_chec ,
Please check this post, the data types supported by eventstream and lakehouse are different:
Solved: Hard error writing onto a lakehouse as an eventstr... - Microsoft Fabric Community
The following data types are supported in Lakehouse:
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#data-types-in-warehouse
You may need to convert the data type of the column to datetime2 using T-SQL in the KQL Database:
datetime2 (Transact-SQL) - SQL Server | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi bw_chec ,
Please check this post, the data types supported by eventstream and lakehouse are different:
Solved: Hard error writing onto a lakehouse as an eventstr... - Microsoft Fabric Community
The following data types are supported in Lakehouse:
https://learn.microsoft.com/en-us/fabric/data-warehouse/data-types#data-types-in-warehouse
You may need to convert the data type of the column to datetime2 using T-SQL in the KQL Database:
datetime2 (Transact-SQL) - SQL Server | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.